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.
