How do I do a boolean OR in solr?

Question

I am completely new at this...

I am using durpal with the apachesolr module.

I have the following filter:

(  tid:19895 OR tid:19937 ) AND  type:poster"

This does not return any results, but if I have the following, it returns the results as expected

(  tid:19937 ) AND  type:poster"

EDIT: This is all in a filter. I need to have a list of tids that it could be along with having type be poster. So it has to be type:poster AND one of the following tids: 19895, 19937

score 2 · Answer 1 · answered Jul 16 '11 at 17:58

although:

((tid:(19895 OR 19937)) AND type:poster) should work irrespective of defaultOperator being OR/AND

adding the clauses as separate filter is better, so add two filters as

tid:(19895 OR 19937)

type:poster

should filter out the results working as AND and also cache the results for this filter separately for improved query performance for new queries using this filter.

score 0 · Answer 2 · edited May 23 '17 at 12:12

0

I think its important to note that SOLR isn't a database. Its a search engine and therefore isn't going to work like a database query you may be used to.

adding a + means the field is required

+tid:19895 would mean that TID field is required to equal exactly 19895

The * is the wildcard so adding it means your field would contain the value but not necessarily equal the value.

tid:19895* would mean TID field contains 19895

It looks like the issue is defining the field twice in the same filter???

So try removing the second "tid:"

In my testing I did this: My SOLR query is:

+type:poster

And the Filter is:

tid:19895 OR 19937

Here is another stackoverflow question similar to yours since you obviously have a different syntax than I use.

using OR and NOT in solr query

edited May 23 '17 at 12:12

Community

1
1

answered Jul 08 '11 at 15:52

kasdega

18,396
12
45
89

Tried your rewrite and it didn't work. I looked at that page before posting this and it didn't help me. – AllisonC Jul 08 '11 at 16:00
I had my logic messed up. * is the "wildcard" so leaving it off means an exact match. – kasdega Jul 08 '11 at 16:03
No. It ends up returning all posters (type:poster) – AllisonC Jul 11 '11 at 12:26

score 0 · Answer 3 · answered Jul 12 '11 at 08:19

0

As FYI if defalut boolen clause is "OR" then give the query like this
((tid:(19895 19937)) AND type:poster) This working fine i tested

answered Jul 12 '11 at 08:19

Syed Abdul Kather

608
2
12
29

well I think for some reason the default is AND... that seems to be the way it is working – AllisonC Jul 12 '11 at 12:00
In `schema.xml` you can override the default with ``. – opyate Jul 12 '11 at 17:24
if default is and means((tid:((19895)OR(19937))) type:poster) if you need more deatils about this means i can help you... – Syed Abdul Kather Jul 13 '11 at 13:26

How do I do a boolean OR in solr?

3 Answers3