SQL2 ISDESCENDANTNODE question

[Clive_Stewart]

SELECT * from [cq:PageContent] AS t WHERE ISDESCENDANTNODE(['/content/'])

On local host this returns a large result set

On the testing server it does not report an error, but returns no results.
It is as if there is no content  under /content/ on the testing server.
But that is not the case.

SELECT * from [cq:PageContent] AS t works on both localhost and on the testing server.

Regards

Clive

[Jörg_Hoh · Accepted solution]

Hi Clive,

JCR Query performs a permission check on each entry of the result set; and if you don't have read access to that node, the node is removed from the result set. So please check the permissions of the user you are using to do this query.

kind regards,
Jörg