Re: Query formulation help

2016-11-05 Thread Erick Erickson
rstaff [mailto:j...@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" --

RE: Query formulation help

2016-11-04 Thread Prasanna S. Dhakephalkar
ent: 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

RE: Query formulation help

2016-10-26 Thread Prasanna S. Dhakephalkar
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 ev

Re: Query formulation help

2016-10-26 Thread John Bickerstaff
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

Re: Query formulation help

2016-10-26 Thread Tom Evans
On Wed, Oct 26, 2016 at 4:00 PM, Prasanna S. Dhakephalkar wrote: > Hi, > > Thanks for reply, I did > > "q": "cost:[2 TO (2+5000)]" > > Got > > "error": { > "msg": "org.apache.solr.search.SyntaxError: Cannot parse 'cost:[2 to > (2+5000)]': Encountered \" \"(2+5000) \"\"

Re: Query formulation help

2016-10-26 Thread John Bickerstaff
Ahh - I see what you're after (I think) This page should be helpful for you: https://cwiki.apache.org/confluence/display/solr/Function+Queries again, I'd try using the Admin UI as a test phase to get things right (and see the syntax in the URL that comes back on the response) Open the edismax s

Re: Query formulation help

2016-10-26 Thread Shawn Heisey
On 10/26/2016 9:00 AM, Prasanna S. Dhakephalkar wrote: > Hi, Thanks for reply, I did "q": "cost:[2 TO (2+5000)]" Solr doesn't support doing math in that way in a query, except with dates. It's invalid syntax for a range query. Tom's reply was correct, but was phrased in a way that makes

Re: Query formulation help

2016-10-26 Thread John Bickerstaff
ot worked. I am missing something. I donot know what. May be how to > invoke functions. > > Regards, > > Prasanna. > > > -Original Message- > From: Tom Evans [mailto:tevans...@googlemail.com] > Sent: Wednesday, October 26, 2016 3:07 PM > To: solr-user@lucene.a

RE: Query formulation help

2016-10-26 Thread Prasanna S. Dhakephalkar
ething. I donot know what. May be how to invoke functions. Regards, Prasanna. -Original Message----- From: Tom Evans [mailto:tevans...@googlemail.com] Sent: Wednesday, October 26, 2016 3:07 PM To: solr-user@lucene.apache.org Subject: Re: Query formulation help On Wed, Oct 26, 2016 at

Re: Query formulation help

2016-10-26 Thread Tom Evans
On Wed, Oct 26, 2016 at 8:03 AM, Prasanna S. Dhakephalkar wrote: > Hi, > > > > May be very rudimentary question > > > > There is a integer field in a core : "cost" > > Need to build a query that will return documents where 0 < > "cost"-given_number < 500 > cost:[given_number TO (500+given_numb

Re: query formulation

2016-09-11 Thread John Bickerstaff
Awesome! If I can get 2 or 3 more-experienced SOLR people to agree to assist, I can put together something really good. I like this stuff and am willing to put in the time just to see the result. I'll contact you off the list. All - anyone else willing to volunteer to answer questions to suppor

Re: query formulation

2016-09-11 Thread Alexandre Rafalovitch
1. There are tutorials. Actually a number of them. But none of them - as far as I remember - go very far into the query language. They kind of stop of basic queries. I remember the first time I realized I can get multiple subqueries working together (for https://gist.github.com/arafalov/5e04884e5ae

Re: query formulation

2016-09-11 Thread John Bickerstaff
All, I've found that figuring out the subtle nuances of the query language is a *daunting* task for someone unfamiliar with SOLR. I'm not aware of any comprehensive documentation (in the form of a tutorial or similar really useful tool) It seems the information is scattered all over the place an

Re: query formulation

2016-09-10 Thread Erick Erickson
Background for Shawn's comments can be found here: https://lucidworks.com/blog/2011/12/28/why-not-and-or-and-not/ Solr's query language is NOT strict boolean logic as explained above. Although with proper grouping (parenthesizing) and tricks like Shawn mentioned it can be pretty close. Best, Eri

Re: query formulation

2016-09-09 Thread Shawn Heisey
On 9/9/2016 9:17 PM, Prasanna S. Dhakephalkar wrote: > Further search on net got me answer > > The query to be > > a_id:20 OR (*:* NOT a_id:*) > > I don't understand this syntax The basic problem here is that negative queries don't work. If you're going to subtract X, you have to start with somet

RE: query formulation

2016-09-09 Thread Prasanna S. Dhakephalkar
Hi, Further search on net got me answer The query to be a_id:20 OR (*:* NOT a_id:*) I don't understand this syntax I am bit raw at solr query formations :) Regards, Prasanna. From: Prasanna S. Dhakephalkar [mailto:prasann...@merajob.in] Sent: Saturday, September 10, 2016 8:2