I am not getting excepted results from azure search index with complex type data field

PIDUGU Harish 0 Reputation points
2024-07-03T10:42:30.3166667+00:00

I have created an index with this json, however In query view, I got unexcepted results

"name": "permits-index",

"fields": [

    {

        "name": "Permit_ID",

        "type": "Edm.String",

        "key": true,

        "searchable": true,

        "sortable": true,

        "filterable": true,

        "facetable": true

    },

    {

        "name": "Work_Desc",

        "type": "Edm.String",

        "searchable": true,

        "sortable": true,

        "filterable": true,

        "facetable": true

    },

    {

        "name": "IssueDate",

        "type": "Edm.DateTimeOffset",

        "searchable": true,

        "sortable": true,

        "filterable": true,

        "facetable": true

    },

    {

        "name": "RiskLevel",

        "type": "Edm.String",

        "searchable": true,

        "sortable": true,

        "filterable": true,

        "facetable": true

    },

    {

        "name": "WorkOrder",

        "type": "ComplexType",

        "fields": [

            {

                "name": "Number",

                "type": "Edm.Double",

                "searchable": true,

                "sortable": true,

                "filterable": true,

                "facetable": true

            },

            {

                "name": "Func_Loc",

                "type": "Edm.String",

                "searchable": true,

                "sortable": true,

                "filterable": true,

                "facetable": true

            },

            {

                "name": "FunctionalLocationdesc",

                "type": "Edm.String",

                "searchable": true,

                "sortable": true,

                "filterable": true,

                "facetable": true

            },

            {

                "name": "Equipment_No",

                "type": "Edm.String",

                "searchable": true,

                "sortable": true,

                "filterable": true,

                "facetable": true

            },
Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
845 questions
{count} votes