Azure Search empty Collection filter

Question

I have a simple question:

How do I filter empty Collection(Edm.String) fields? I want to select only those documents that have a field of type Collection - empty. Is that possible?

Answer 1

Hi Nikola, You can use ‘any’ for this purpose. See the example here: https://stackoverflow.com/questions/50046757/how-to-filter-an-empty-array-in-azure-search

Answer 2

Hi Bruce,

thanks for the answer. Using /any() returns all the documents that do have something in that field. What I need is the opposite, to retrieve only those that have the field empty. Is there a negation of this query?

Answer 3

Just put ‘not’ in front of it: not tags/any()