Re: Use function in condition

Emir Arnautovic Mon, 05 Sep 2016 01:49:12 -0700

Hi Nabil,

Can you please share exact queries that are executed and results.


Thanks,
Emir


On 05.09.2016 10:43, nabil Kouici wrote:

Hi Emir,
Yes I confirm, it's working. But if I put the same condition in fq the result 
is different (result is correct when I put condition in q).
Thank you.
Regards,Nabil.

       De : Emir Arnautovic <emir.arnauto...@sematext.com>
  À : solr-user@lucene.apache.org
  Envoyé le : Lundi 5 septembre 2016 10h30
  Objet : Re: Use function in condition

Hi Nabil,


It should work. I've just tested on gettingstarted collection (sample
that comes with Solr) and this query returns expected results. Here is
what test query looks like:

http://localhost:8983/solr/gettingstarted/select?q=*:*&fq={!frange
l=1}or(query($q1),query($q2))&q1=id:adata&q2=id:apple

Can you please doublecheck if your query part returns any results.

Regards,
Emir


On 05.09.2016 09:54, nabil Kouici wrote:

Hi All,
Any feedback please.
Regards,Nabil.

         De : nabil Kouici <koui...@yahoo.fr.INVALID>
   À : "solr-user@lucene.apache.org" <solr-user@lucene.apache.org>
   Envoyé le : Vendredi 2 septembre 2016 13h45
   Objet : Re: Use function in condition

Hi Emir,

Thank you for your response.
Yes your request is working but only if it's function queries.
If you mix function query with normal query, this will not work. For example:
fq={!frange 
l=1}and(query($sub1),or(query($sub2),query($sub3)))&sub1=F3:Active&sub2={!frange 
u=2000}sum(F3,F4)&sub3={!frange l=3000}sum(F5,F6)
Regards,Nabil.

         De : Emir Arnautovic <emir.arnauto...@sematext.com>
   À : solr-user@lucene.apache.org
   Envoyé le : Lundi 29 août 2016 14h06
   Objet : Re: Use function in condition

Hi Nabil,


Can you try following:

fq={!frange l=1}and(query($sub1),or(query($sub2),query($sub3)))&sub1={!frange 
l=1000}sum(F1,F2)&sub2={!frange u=2000}sum(F3,F4)&sub3={!frange l=3000}sum(F5,F6)

Thanks,
Emir

On 29.08.2016 11:50, nabil Kouici wrote:

Hi solr users,
I'm still not able to find a solution either with function query :(
My need is simple, I'd like to execute these combined filters :
(Sum F1 and F2 greater than 1000) AND ( (sum F3 and F4 lower than 2000) OR (sum 
F5 and F6 greater then 3000) )
Could you please help me to translate these conditions to solr syntaxe.
Regards,Nabil.

           De : Emir Arnautovic <emir.arnauto...@sematext.com>
     À : solr-user@lucene.apache.org
     Envoyé le : Jeudi 25 août 2016 16h51
     Objet : Re: Use function in condition

Hi Nabil,


You have limited set functions, but there are logical functions: or,
and, not and you have query function so can do more complex queries:

fq={!frange l=1}and(query($sub1),termfreq(field3, 300))sub1={!frange 
l=100}sum(field1,field2)

And will return 1 for doc matching both function terms.

It would be much simpler if Solr supported relational functions: gt, lt, eq.

Hope this gives you ideas how to proceed.

Emir

On 25.08.2016 12:06, nabil Kouici wrote:

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/

Re: Use function in condition

Reply via email to