Hi,

I would really appreciate any hint/guide to fix this query issue. A Java
webapp hits solr with a query that does not returns any result but works for
other states. (FL, CA for instance)
>From logs:
[code]
solr path=/select
params={facet=on&facet.mincount=5&facet.sort=count&q=listing.property.state:"OR"&facet.limit=12&facet.field=listing.property.city_fStr&wt=javabin&rows=0&version=2}
hits=0 status=0 QTime=0
[/code]

>From searching the web, I also tried:
listing.property.state:OR
listing.property.state:\"OR\"
listing.property.state:\"+OR\"
listing.property.state:+OR
and probably multiple combinations of the above
returning facet count = 0
There are results for Oregon, also tried facet.mincount=1 (Portland includes
30+ results in my dev laptop)
I would say the issue is with q=listing.property.state:"OR"

I also tried removing
or
from stopswords.txt
but kept getting 0 count

All this was tested using Solr 3.5.0

I'm clueless here, any help will be greatly appreciated.

Best Regards,
Asi

--
View this message in context: http://lucene.472066.n3.nabble.com/Oregon-OR-cities-facet-query-issue-maybe-related-to-OR-being-a-reserved-word-tp3682633p3682633.html
Sent from the Solr - User mailing list archive at Nabble.com.

> I would really appreciate any hint/guide to fix this query
> issue. A Java
> webapp hits solr with a query that does not returns any
> result but works for
> other states. (FL, CA for instance)
> From logs:
> [code]
> solr path=/select
> params={facet=on&facet.mincount=5&facet.sort=count&q=listing.property.state:"OR"&facet.limit=12&facet.field=listing.property.city_fStr&wt=javabin&rows=0&version=2}
> hits=0 status=0 QTime=0
> [/code]
>
> From searching the web, I also tried:
> listing.property.state:OR
> listing.property.state:\"OR\"
> listing.property.state:\"+OR\"
> listing.property.state:+OR
> and probably multiple combinations of the above
> returning facet count = 0
> There are results for Oregon, also tried facet.mincount=1
> (Portland includes
> 30+ results in my dev laptop)
> I would say the issue is with
> q=listing.property.state:"OR"
>
> I also tried removing
> or
> from stopswords.txt
> but kept getting 0 count
>
> All this was tested using Solr 3.5.0
>
> I'm clueless here, any help will be greatly appreciated.

OR is a reserved word in lucene query parser. You can try other query parser like term query parser plugin.

q={!term f=listing.property.state}OR

http://lucene.apache.org/solr/api/org/apache/solr/search/TermQParserPlugin.html

Hello,

I'm no expert here (just started learning/using Solr a few months ago) but I ran into the same issue of needing to search for and facet on the OR abbreviation.

What worked for me was to double-escape OR (a la :\\OR) for queries and single escape (:\OR) when doing a facet query.

The page http://stackoverflow.com/questions/5890401/sunspot-solr-queries-ending-with-logical-operators-and-or-not-result-in-error led me to the solution.

James

-----Original Message-----
From: asi123 [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 23, 2012 10:41 AM
To: [EMAIL PROTECTED]
Subject: Oregon (OR) cities facet query issue, maybe related to OR being a reserved word?

Hi,

I would really appreciate any hint/guide to fix this query issue. A Java
webapp hits solr with a query that does not returns any result but works for
other states. (FL, CA for instance)
>From logs:
[code]
solr path=/select
params={facet=on&facet.mincount=5&facet.sort=count&q=listing.property.state:"OR"&facet.limit=12&facet.field=listing.property.city_fStr&wt=javabin&rows=0&version=2}
hits=0 status=0 QTime=0
[/code]

>From searching the web, I also tried:
listing.property.state:OR
listing.property.state:\"OR\"
listing.property.state:\"+OR\"
listing.property.state:+OR
and probably multiple combinations of the above
returning facet count = 0
There are results for Oregon, also tried facet.mincount=1 (Portland includes
30+ results in my dev laptop)
I would say the issue is with q=listing.property.state:"OR"

I also tried removing
or
from stopswords.txt
but kept getting 0 count

All this was tested using Solr 3.5.0

I'm clueless here, any help will be greatly appreciated.

Best Regards,
Asi

--
View this message in context: http://lucene.472066.n3.nabble.com/Oregon-OR-cities-facet-query-issue-maybe-related-to-OR-being-a-reserved-word-tp3682633p3682633.html
Sent from the Solr - User mailing list archive at Nabble.com.
******************************************************************************************
This message may contain confidential or proprietary information intended only for the use of the
addressee(s) named above or may contain information that is legally privileged. If you are
not the intended addressee, or the person responsible for delivering it to the intended addressee,
you are hereby notified that reading, disseminating, distributing or copying this message is strictly
prohibited. If you have received this message by mistake, please immediately notify us by
replying to the message and delete the original message and any copies immediately thereafter.

Thank you.-
******************************************************************************************
FAFLD