RE: Again : Query formulation help

2016-11-27 Thread Prasanna S. Dhakephalkar
, exists(query({!v='code4:'})) ) Regards, Prasanna -Original Message- From: Michael Kuhlmann [mailto:k...@solr.info] Sent: Thursday, November 24, 2016 4:29 PM To: solr-user@lucene.apache.org Subject: Re: Again : Query formulation help Hi Prasanna, there's no such filter out-of

RE: Again : Query formulation help

2016-11-24 Thread Prasanna S. Dhakephalkar
:( Thanks Michael. Regards, Prasanna. -Original Message- From: Michael Kuhlmann [mailto:k...@solr.info] Sent: Thursday, November 24, 2016 4:29 PM To: solr-user@lucene.apache.org Subject: Re: Again : Query formulation help Hi Prasanna, there's no such filter out-of-the-box.

Re: Again : Query formulation help

2016-11-24 Thread Michael Kuhlmann
Hi Prasanna, there's no such filter out-of-the-box. It's similar to the mm parameter in (e)dismax parser, but this only works for full text searches on the same fields. So you have to build the query on your own using all possible permutations: fq=(code1: AND code2:) OR (code1: AND c

Again : Query formulation help

2016-11-24 Thread Prasanna S. Dhakephalkar
Hi, Need to formulate a distinctive field values query on 4 fields with minimum match on 2 fields I have 4 fields in my core Code 1 : Values between 1001 to Code 2 : Values between 1001 to Code 3 : Values between 1001 to Code 4 : Values between 1001 to I want to

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

Query formulation help

2016-10-26 Thread Prasanna S. Dhakephalkar
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 How can this be achieved ? Thanks. Prasanna.

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
016 8:24 AM To: 'solr-user@lucene.apache.org' Subject: query formulation Greetings Group, I am attempting to formulate a query that gives me all the records such that 1. The record does not have field a_id 2. If a_id field exists then it should have a value 20 So,

query formulation

2016-09-09 Thread Prasanna S. Dhakephalkar
Greetings Group, I am attempting to formulate a query that gives me all the records such that 1. The record does not have field a_id 2. If a_id field exists then it should have a value 20 So, for 1. I used -a_id:* (got 25 results) For 2. I used a_id:20 (got 3 results) Fo