jackrabbit-dev 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 Tue, 13 Apr 2010 16:27:05 GMT
Hello,

JCR querries 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"


Not 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