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.
1,062 questions
AzureSearch - query for missing/null json elements
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 86%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deanna Delapasse
1
Reputation point
I have indexed documents with a "MetadataFields" key whose values are json.
"MetadataFields": "{\"continent\":\"north america\",\"country\":\"united states\",\"region\":\"x34\",\"tagnumber\":\"abc-123\"}
I'm able to search for a specific match in Search Explorer using
MetadataFields/tagnumber:abc-123
But I cannot figure out how to find documents where this attribute is null or missing. Is this possible? What is the proper syntax?
{count} votes
-
brtrach-MSFT 16,586 Reputation points Microsoft Employee2021-11-09T03:56:25.457+00:00 Hi @Deanna Delapasse , we have been researching your question for the past couple of days but unable to locate a solution. This might mean that it is not possible but we would like to work with you offline to ensure that we exhaust all possible paths.
We will send you a private message with further steps on how to reach us via email.
Sign in to comment
Sign in to answer