Re: Transaction log "on-disk" guarantees

Hey Jack Thanks a lot. I just googled for fsync and syncLevel instead of searching in the solr wiki. Won't happen again. Here is the link to the solr wiki page that describes to set the syncLevel http://wiki.apache.org/solr/SolrCloud?highlight=%28fsync%29 -- View this message in context: h

Search for non empty fields in a index with denormalized tables

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

Use function return value for range queries

Is there a way to use the function return value for a range query For example: I have two price fields pricea and priceb and now i want to get the values where the sum of the pricea and priceb is between [0 TO 5] Something like *select?q={!func}sum(pricea,priceb):[0 TO 5]* I can't calculate thi

Re: AW: Use function return value for range queries

Thank you very much Jack. I will take a look at this. Bests Sandro -- View this message in context: http://lucene.472066.n3.nabble.com/Use-function-return-value-for-range-queries-tp4093499p4093579.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Search for non empty fields in a index with denormalized tables

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 -