Hi Emir,Thank you for your replay. I've tested the function range query and this is solving 50% my need. The problem is I'm not able to use it with other conditions. For exemple: fq={!frange l=100}sum(field1,field2) and field3:200
or fq=({!frange l=100}sum(field1,field2)) and (field3:200) This is giving me an exception:org.apache.solr.search.SyntaxError: Unexpected text after function: AND Field3:200 I know that I can use multiple fq but the problem is I can have complexe filter like (cond1 OR cond2 AND cond3) Could you please help. Regards,Nabil. De : Emir Arnautovic <emir.arnauto...@sematext.com> À : solr-user@lucene.apache.org Envoyé le : Mercredi 17 août 2016 17h08 Objet : Re: Use function in condition Hi Nabil, You can use frange queries, e.g. you can use fq={!frange l=100}sum(field1,field2) to filter doc with sum greater than 100. Regards, Emir On 17.08.2016 16:26, nabil Kouici wrote: > Hi, > Is it possible to use functions (function query > https://cwiki.apache.org/confluence/display/solr/Function+Queries) in q or fq > parameters to build a complex search expression. > For exemple, take only documents that sum(field1,field2)> 100. Another > exemple: if(test,value1,value2):vallue3 > Regards,Nabil. -- Monitoring * Alerting * Anomaly Detection * Centralized Log Management Solr & Elasticsearch Support * http://sematext.com/