lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From SandroZbinden <zbin...@imagic.ch>
Subject Search for non empty fields in a index with denormalized tables
Date Thu, 03 Oct 2013 09:22:33 GMT
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.

Mime
View raw message