Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
MIME-Version: 1.0
In-Reply-To: <CALy4+QX-f1MvBei=ZsaNOhVayZ=YTA3ZdQKCW4or3CSzjXnZOQ@mail.gmail.com>
References: <CALy4+QXco2gya9sHyy6bKAEgSGn-Ev3Q+kCxakP3KoDy6v3CtQ@mail.gmail.com>
 <74B24A76-C633-42D8-9AD2-D5CC2B31AFCB@gmail.com> <E8124FDE9719ED8EC93A5FA628C829F8@udngroup.com>
 <CALy4+QX-f1MvBei=ZsaNOhVayZ=YTA3ZdQKCW4or3CSzjXnZOQ@mail.gmail.com>
From: Erick Erickson <erickerickson@gmail.com>
Date: Mon, 23 May 2016 10:33:13 -0700
Message-ID: <CAN4YXve=Z7cJtfMfjPTxXB_omtAasqsWhpfiwJ+Q4Loxi6c7jw@mail.gmail.com>
Subject: Re: How to use "fq"
To: solr-user <solr-user@lucene.apache.org>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
archived-at: Mon, 23 May 2016 17:33:40 -0000

Steven:

I'm not sure you can, the terms query parser is built to
OR things together.

You might be able to use some of the nested query stuff.
Or, assuming you have an _additional_ fq clause
you want to use just use it as:
fq=3D{!terms f=3Dcategory}1,2,3,4,...N&fq=3Dwhaterver

Then you're taking advantage of the default
behavior of multiple "fq" clauses.

And I'd do one other thing, I'd add "cache=3Dfalse" (at least I'm
pretty sure this works):
fq=3D{!terms f=3Dcategory cache=3Dfalse}1,2,3,4,...N
on the assumption that it's highly unlikely that you'll send in
another fq clause _exactly_ like the one you're creating.

Best,
Erick

On Mon, May 23, 2016 at 9:41 AM, Steven White <swhite4141@gmail.com> wrote:
> Thank you Erik and Scott.  {!terms} did the job!!  I tested like so:
> fq=3D{!terms f=3Dcategory}1,2,3,4,...N
>
> I read that {!terms} treats the terms in the list as OR, if I have a need
> to force AND on my terms, how do I do that?
>
> Steve
>
>
> On Mon, May 23, 2016 at 9:39 AM, Scott Chu <scott.chu@udngroup.com> wrote=
:
>
>>
>> Yonik has a very well article about term qp:
>>
>> Solr Terms Query for matching many terms - Solr 'n Stuff
>> http://yonik.com/solr-terms-query/
>>
>>
>> Scott Chu=EF=BC=8Cscott.chu@udngroup.com
>> 2016/5/23 (=E9=80=B1=E4=B8=80)
>> ----- Original Message -----
>> From: Erik Hatcher
>> To: solr-user
>> CC:
>> Date: 2016/5/23 (=E9=80=B1=E4=B8=80) 21:14
>> Subject: Re: How to use "fq"
>>
>>
>> Try the {!terms} query parser. That should make it work well for you. Le=
t
>> us know how it does.
>>
>>    Erik
>>
>> > On May 23, 2016, at 08:52, Steven White <swhite4141@gmail.com> wrote:
>> >
>> > Hi everyone,
>> >
>> > I'm trying to figure out what's the best way for me to use "fq" when t=
he
>>
>> > list of items is large (up to 200, but I have few cases with up to 100=
0).
>> >
>> > My current usage is like so: &fq=3Dcategory:(1 OR 2 OR 3 OR 4 ... 200)
>> >
>> > When I tested with up to 1000, I hit the "too many boolean clauses", s=
o
>> my
>> > fix was to increase the value of maxBooleanClauses. However, reading [=
1]
>> > warns that increasing the value of maxBooleanClauses has negative impa=
ct.
>> > The link offers an alternative usage like so:
>> > fq=3Dcategory:1&fq=3Dcategory:2... But I cannot use it because I need =
my "fq"
>> > to be treated as OR (my default is set to AND).
>> >
>> > I'm trying to understand what's the best way for me to coded this so I
>> > don't get a performance or memory hit.
>> >
>> > Thanks
>> >
>> > Steve
>> >
>> > [1]
>> >
>> http://solr.pl/en/2011/12/19/do-i-have-to-look-for-maxbooleanclauses-whe=
n-using-filters/
>>
>>
>> -----
>> ???????????
>> ??? AVG ?? - www.avg.com
>> ??: 2015.0.6201 / ???: 4568/12281 - ????: 05/23/16
>>