It's really unclear what you want here. First you say "Now I want to select all patients that have no image"
Then you say " I get all patients because every patient has an empty image_imgid field" Then you say " I only want to recive Gary Walker as a result" What is it you really want here? Best, Erick On Thu, Oct 3, 2013 at 5:22 AM, SandroZbinden <zbin...@imagic.ch> wrote: > Hi there > > I have a patient and image that are denormalized for the solr index (see the > image attached) > > Now I want to select all patients that have no image. I would usually do > this with the following query: > > select?*q=-image_imgid:[0 TO *]* and then group by patient_patid > > <http://lucene.472066.n3.nabble.com/file/n4093287/Denormalized_Table.png> > > The problem is that with this query I get all patients because every patient > has an empty image_imgid field. > > Is there a way to get only the patients without any images with one single > query ? In my case I only want to recive Gary Walker as a result. > > > Best regrads Sandro Zbinden > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Search-for-non-empty-fields-in-a-index-with-denormalized-tables-tp4093287.html > Sent from the Solr - User mailing list archive at Nabble.com.
