search_cop icon indicating copy to clipboard operation
search_cop copied to clipboard

Can I'm using query with nil/null/empty?

Open eddiefisher opened this issue 9 years ago • 2 comments

like: Book.search("author: Rowling sdn: null") Book.search("author: Rowling sdn: empty") Book.search(author: Rowling, sdn: '' ")

eddiefisher avatar Feb 05 '16 12:02 eddiefisher

you can search for empty values via the = operator, like

Book.search("author=''")

searching for explicit null's is currently not supported and would require a special syntax/operator, since the string "null" could be a valid value.

Something like elasticsearch/lucene's _exists_:author

mrkamel avatar Feb 05 '16 13:02 mrkamel

tnx

eddiefisher avatar Feb 05 '16 13:02 eddiefisher