Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: java-user@lucene.apache.org
Received-SPF: pass (nike.apache.org: domain of dean.hiller@broadridge.com
 designates 64.18.2.217 as permitted sender)
From: "Hiller, Dean  x66079" <dean.hiller@broadridge.com>
To: "java-user@lucene.apache.org" <java-user@lucene.apache.org>
Date: Mon, 20 Jun 2011 21:15:39 -0400
Subject: RE: how to do something like sql in () clause
Thread-Topic: how to do something like sql in () clause
Thread-Index: Acwvqg6Wc0tCOeW/R26Bcdhu0MQyvgABqdnQ
Message-ID: 
 <08230D4C8E666D479F6DE495A7684DCD0AC2EA4B@JSCPCWEXMAA1.bsg.ad.adp.com>
References: 
 <08230D4C8E666D479F6DE495A7684DCD0AC2EA14@JSCPCWEXMAA1.bsg.ad.adp.com>
 <F9A9EB6E-86D8-4146-82AC-6D6FB94A151D@gmail.com>
 <08230D4C8E666D479F6DE495A7684DCD0AC2EA42@JSCPCWEXMAA1.bsg.ad.adp.com>
 <C8C5B9B6-0CD9-4B17-817C-7DA8245AF43A@gmail.com>
In-Reply-To: <C8C5B9B6-0CD9-4B17-817C-7DA8245AF43A@gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Thanks much,=20
Dean

-----Original Message-----
From: Denis Bazhenov [mailto:dotsid@gmail.com]=20
Sent: Monday, June 20, 2011 6:27 PM
To: java-user@lucene.apache.org
Subject: Re: how to do something like sql in () clause

SQL IN operator behaves as OR operator. So as Occur.SHOULD does. It will ma=
tch document only if _one or more_ of the child queries match.

BooleanQuery query =3D new BooleanQuery();
query.add(new TermQuery(new Term("accountId", "1")), Occur.SHOULD);
query.add(new TermQuery(new Term("accountId", "2")), Occur.SHOULD);
query.add(new TermQuery(new Term("accountId", "3")), Occur.SHOULD);

On Jun 21, 2011, at 11:01 AM, Hiller, Dean x66079 wrote:

> But the issue is that it MUST be 1, OR MUST be 2 so does that still work?
>=20
> Also, how do you write that in the query syntax?
>=20
> Thanks,
> Dean
>=20
> -----Original Message-----
> From: Denis Bazhenov [mailto:dotsid@gmail.com]=20
> Sent: Monday, June 20, 2011 5:50 PM
> To: java-user@lucene.apache.org
> Subject: Re: how to do something like sql in () clause
>=20
> You could use BooleanQuery with Occur.SHOULD quantificator
>=20
> http://lucene.apache.org/java/3_0_3/api/core/org/apache/lucene/search/Boo=
leanClause.Occur.html#SHOULD
>=20
> On Jun 21, 2011, at 9:24 AM, Hiller, Dean x66079 wrote:
>=20
>> I need to do something like a lucene query with
>>=20
>> Where accountId in ( 1, 2, 3, 4)
>>=20
>> Is there a way to do that in Lucene Query language?
>>=20
>> Thanks,
>> Dean
>>=20
>> This message and any attachments are intended only for the use of the ad=
dressee and
>> may contain information that is privileged and confidential. If the read=
er of the=20
>> message is not the intended recipient or an authorized representative of=
 the
>> intended recipient, you are hereby notified that any dissemination of th=
is
>> communication is strictly prohibited. If you have received this communic=
ation in
>> error, please notify us immediately by e-mail and delete the message and=
 any
>> attachments from your system.
>>=20
>=20
> ---
> Denis Bazhenov <dotsid@gmail.com>
>=20
>=20
>=20
>=20
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>=20
> This message and any attachments are intended only for the use of the add=
ressee and
> may contain information that is privileged and confidential. If the reade=
r of the=20
> message is not the intended recipient or an authorized representative of =
the
> intended recipient, you are hereby notified that any dissemination of thi=
s
> communication is strictly prohibited. If you have received this communica=
tion in
> error, please notify us immediately by e-mail and delete the message and =
any
> attachments from your system.
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>=20

---
Denis Bazhenov <dotsid@gmail.com>


This message and any attachments are intended only for the use of the add=
ressee and
may contain information that is privileged and confidential. If the reade=
r of the =

message is not the intended recipient or an authorized representative of =
the
intended recipient, you are hereby notified that any dissemination of thi=
s
communication is strictly prohibited. If you have received this communica=
tion in
error, please notify us immediately by e-mail and delete the message and =
any
attachments from your system.
=0D

---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org