lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From SandroZbinden <>
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


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:
Sent from the Solr - User mailing list archive at

View raw message