RE: How to query Solr for empty field or specific value

2013-07-02 Thread Van Tassell, Kristian
Thank you! -Original Message- From: Jack Krupansky [mailto:j...@basetechnology.com] Sent: Tuesday, July 02, 2013 3:05 PM To: solr-user@lucene.apache.org Subject: Re: How to query Solr for empty field or specific value Better to define color.not_null as a boolean field and always

Re: How to query Solr for empty field or specific value

2013-07-02 Thread Jack Krupansky
Better to define color.not_null as a boolean field and always initialize as either true or false. But, even without that you need write a pure negative query or clause as (*:* -term) So: select?q=*:*&fq=((*:* -color:[* TO *]) OR color:blue) and select?q=*:*&fq=((*:* -color.not_null