Hello again,
we managed to filter nodes with offset and limit like the following:
final Query query = jcrQueryManager.createQuery("SELECT * FROM [mgnl:page]), Query.JCR_SQL2);
query.setLimit(resultsPerPage);
query.setOffset(offset);
In content/categories we have a Collection of categoryIds.
How to select only pages that have a specific categoryId with limit and offset?
So like the following. How to achieve it?
SELECT * FROM [mgnl:page] AS p WHERE 'categoryid' IN (p.content.categories)
Another question is: How to get number of total Results when limiting?
Thank you very much.