RE: Query formulation help

["Prasanna S. Dhakephalkar" <pr...@merajob.in>]

Hi John,

I need to formulate a query where the both query variable are from document.
Like get me all documents where var_1 >  var_2 (var_1 and var_2 both are in document.)

Thanks and Regards,

Prasanna.


-----Original Message-----
From: John Bickerstaff [mailto:john@johnbickerstaff.com] 
Sent: Wednesday, October 26, 2016 9:26 PM
To: solr-user@lucene.apache.org
Subject: Re: Query formulation help

For what it's worth- you can do some complex stuff - including using document fields as "variables" -- I did it on an Solr query endpoint (like
/search) because I had stuff that was constant for every query.  The syntax is challenging, but it can be done.

I won't confuse the issue more unless you need something like that - let me know if you do.

On Wed, Oct 26, 2016 at 9:52 AM, Tom Evans <te...@googlemail.com> wrote:

> On Wed, Oct 26, 2016 at 4:00 PM, Prasanna S. Dhakephalkar 
> <pr...@merajob.in> wrote:
> > Hi,
> >
> > Thanks for reply, I did
> >
> > "q": "cost:[20000 TO (20000+5000)]"
> >
> > Got
> >
> >   "error": {
> >     "msg": "org.apache.solr.search.SyntaxError: Cannot parse
> 'cost:[20000 to (20000+5000)]': Encountered \" <RANGE_GOOP> \"(20000+5000)
> \"\" at line 1, column 18.\nWas expecting one of:\n    \"]\" ...\n    \"}\"
> ...\n    ",
> >   }
> >
> > I want solr to do the addition.
> > I tried
> > "q": "cost:[20000 TO (20000+5000)]"
> > "q": "cost:[20000 TO sum(20000,5000)]"
> >
> > I has not worked. I am missing something. I donot know what. May be 
> > how
> to invoke functions.
> >
> > Regards,
> >
> > Prasanna.
>
> Sorry, I was unclear - do the maths before constructing the query!
>
> You might be able to do this with function queries, but why bother? If 
> the number is fixed, then fix it in the query, if it varies then there 
> must be some code executing on your client that can be used to do a 
> simple addition.
>
> Cheers
>
> Tom
>

Re: Query formulation help

[Erick Erickson <er...@gmail.com>]

Assuming these are numerics, use function queries I should think, see:
https://cwiki.apache.org/confluence/display/solr/Function+Queries#FunctionQueries-AvailableFunctions.
You'll see lt, gt, etc.

Best,
Erick

On Fri, Nov 4, 2016 at 11:23 PM, Prasanna S. Dhakephalkar
<pr...@merajob.in> wrote:
> Hi John,
>
> I need to formulate a query where the both query variable are from document.
> Like get me all documents where var_1 >  var_2 (var_1 and var_2 both are in document.)
>
> Thanks and Regards,
>
> Prasanna.
>
>
> -----Original Message-----
> From: John Bickerstaff [mailto:john@johnbickerstaff.com]
> Sent: Wednesday, October 26, 2016 9:26 PM
> To: solr-user@lucene.apache.org
> Subject: Re: Query formulation help
>
> For what it's worth- you can do some complex stuff - including using document fields as "variables" -- I did it on an Solr query endpoint (like
> /search) because I had stuff that was constant for every query.  The syntax is challenging, but it can be done.
>
> I won't confuse the issue more unless you need something like that - let me know if you do.
>
> On Wed, Oct 26, 2016 at 9:52 AM, Tom Evans <te...@googlemail.com> wrote:
>
>> On Wed, Oct 26, 2016 at 4:00 PM, Prasanna S. Dhakephalkar
>> <pr...@merajob.in> wrote:
>> > Hi,
>> >
>> > Thanks for reply, I did
>> >
>> > "q": "cost:[20000 TO (20000+5000)]"
>> >
>> > Got
>> >
>> >   "error": {
>> >     "msg": "org.apache.solr.search.SyntaxError: Cannot parse
>> 'cost:[20000 to (20000+5000)]': Encountered \" <RANGE_GOOP> \"(20000+5000)
>> \"\" at line 1, column 18.\nWas expecting one of:\n    \"]\" ...\n    \"}\"
>> ...\n    ",
>> >   }
>> >
>> > I want solr to do the addition.
>> > I tried
>> > "q": "cost:[20000 TO (20000+5000)]"
>> > "q": "cost:[20000 TO sum(20000,5000)]"
>> >
>> > I has not worked. I am missing something. I donot know what. May be
>> > how
>> to invoke functions.
>> >
>> > Regards,
>> >
>> > Prasanna.
>>
>> Sorry, I was unclear - do the maths before constructing the query!
>>
>> You might be able to do this with function queries, but why bother? If
>> the number is fixed, then fix it in the query, if it varies then there
>> must be some code executing on your client that can be used to do a
>> simple addition.
>>
>> Cheers
>>
>> Tom
>>
>