On Thu, Mar 4, 2010 at 16:31, Gadbury <[email protected]> wrote:
> SELECT * FROM Table WHERE id IN (0,2,3);
>
> Is there an equivelent in Jackrabbit 2.0 using the query language JCR_SQL2?
>
> I know the following works (but is there a better way?) :
>
> SELECT * FROM [my:table] WHERE [id]=0 OR[id]=2 OR [id]=3

"IN" is not supported. See
http://www.day.com/specs/jcr/2.0/6_Query.html#Constraint

Regards,
Alex

-- 
Alexander Klimetschek
[email protected]

Reply via email to