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