Sharepoint 2013 Search Keyword Query Language (KQL) field value is null or empty

Question

I have a search query, in which I want certain a field to return results where its value is empty :

(contentclass:sts_listitem OR IsDocument:True) SPSiteUrl:http://sharepoint2013b:41000/sites/Catalog ListId:e56dfdd7-4f96-4fa5-b4d5-da75fd56aefd (wstaxidMetadataRegion:**EMPTY**) 

How do I do that? Could not see any option from : http://msdn.microsoft.com/en-us/library/ee558911.aspx

Answer 1

Agnes Molnar has your answer.

http://www.itunity.com/article/filter-empty-values-search-693

For example, I wanted to exclude all expired items without excluding items that have no expiration date.

So based on the referenced example, I added:

-ExpirationTime:1900-01-01..{Today-1}

So any result that does have an expiration date, and whose expiration date is less than today, does not get returned.

Answer 2

Something based off whats here already, but put together fully for how I needed it and in case anyone else needs this.

Where a start date is blank or before now and an end date is blank or after now is as follows.

-EndDate:1900-01-01..{Today} -StartDate:{Today}..3000-12-31

Answer 3

The only option I found was to do a search as so:

NOT (MetadataProperty:"ABC" OR MetadataProperty:"DEF" OR MetadataProperty:"GHI") and send it Search Query JSON using window.location.href or entering it in the search box

http://MyServer/site/Searchpage.aspx?Default={"k":"NOT (MetadataProperty:\"ABC\" OR MetadataProperty:\"DEF\" OR MetadataProperty:\"GHI\")","r":[]}