SQL2 ISDESCENDANTNODE question | Community
Skip to main content
C
Clive_Stewart
Level 6
October 16, 2015
Solved

SQL2 ISDESCENDANTNODE question

  • October 16, 2015
  • 1 reply
  • 1228 views


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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by joerghoh

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

1 reply

joerghoh
Adobe Employee
joerghohAdobe EmployeeAccepted solution
Adobe Employee
October 16, 2015

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

Terms & ConditionsAccessibility statement

Loading footer...