I don't think your model fits well into Solr. What I'd do is make my <uniqueKey> the patient ID, and put the image names (or links or whatever) in a multiValued field. Then you can do what you want by a simple q=*:* -image_name:[* TO *]
Best, Erick On Mon, Oct 7, 2013 at 9:20 AM, SandroZbinden <zbin...@imagic.ch> wrote: > Okay I try to specify my question a little bit. > > I have a denormalized index of two sql tables patient and table. > > If I add a patient with two images to the solr index my index contains 3 > documents. > > ------------------------------------------- > Pat_ID |Patient_Lastnname | Image_ID | Image_Name > ------------------------------------------- > 1 | Miller | EMPTY| EMPTY > 1 | Miller | 1 | dog.jpg > 1 | Miller | 2 | cat.jpg > ------------------------------------------- > > When I add now another patient without any images the solr index contains 4 > documents. > > ------------------------------------------- > Pat_ID |Patient_Lastnname | Image_ID | Image_Name > ------------------------------------------- > 1 | Miller | EMPTY| EMPTY > 1 | Miller | 1 | dog.jpg > 1 | Miller | 1 | cat.jpg > 2 | Smith | EMPTY| EMPTY > ------------------------------------------- > > > Now I want to select all patients that have no image. (image_id is empty) > > If I query this with the following solr query the result would be Miller and > Smith but I need a query that will return Smith only. > > select?q=-Image_ID:[0 TO *] and then group by pat_id > > What I would need is something like the having clause in sql. So I could > group by pat_id and filter for the one where count is less then 2 > > Bests Sandro > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Search-for-non-empty-fields-in-a-index-with-denormalized-tables-tp4093287p4093903.html > Sent from the Solr - User mailing list archive at Nabble.com.