jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ana Osman <ana.os...@gmail.com>
Subject JCR query fails when filtering through more than 25 results
Date Wed, 14 Apr 2010 10:26:12 GMT
Hello,

JCR queries which should return more than 25 results fail when filters 
are applied.

Working queries:

SELECT * FROM nt:base WHERE (jcr:primaryType = 'mgnl:contentNode' OR 
jcr:primaryType = 'mgnl:content') AND name <> 'description_files' AND 
year<'2003' AND jcr:path LIKE '/wsDocumentList/Board-of-Directors/%' 
ORDER BY name asc
->this one is OK; it returns 25 results

SELECT * FROM nt:base WHERE (jcr:primaryType = 'mgnl:contentNode' OR 
jcr:primaryType = 'mgnl:content') AND name <> 'description_files' AND 
year<='2002' AND jcr:path LIKE '/wsDocumentList/Board-of-Directors/%' 
ORDER BY name asc
-> this one is OK; it return 25 results, so the "<=" comparator is not a 
problem

SELECT * FROM nt:base WHERE jcr:path LIKE 
'/wsDocumentList/Board-of-Directors/%'
-> this one returns 485 results, but it doesn't have any other filter 
except "jcr:path LIKE"


Non working queries:

SELECT * FROM nt:base WHERE (jcr:primaryType = 'mgnl:contentNode' OR 
jcr:primaryType = 'mgnl:content') AND name <> 'description_files' AND 
year<='2003' AND jcr:path LIKE '/wsDocumentList/Board-of-Directors/%' 
ORDER BY name asc
-> this should return 63 results, but is not returning anything...


We are using jackrabbit version 1.6.0. Any ideea why the filtering is 
causing problems when dealing with more results? Any ideea how should we 
fix this problem?

Many thanks,
Ana Osman

Mime
View raw message