How to query Solr for empty field or specific value

2013-07-02 Thread Van Tassell, Kristian
Hello, I'm using Solr 4.2 and am trying to get a specific value (blue) or null field (no color) returned by my filter query. My results should yield 3 documents (If I execute the two separate filters in different queries, I get 2 hits for one query and 1 for the other). I've tried this (blue

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=((*:*

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