We are currently migrating our applications from AEM 6.1 to AEM 6.4. One of these applications makes use of SQL2 to access certain nodes.
While these queries give expected results in AEM 6.1, the same query gives 0 results in the 6.4 environment.
The content nodes are the same as we built the content package from the already working 6.1 environment and installed it in the local 6.4 environment.
SELECT * FROM [nt:unstructured] As node WHERE ISDESCENDANTNODE (node, '/content/surveymanagement/site-confirmation-author') and node.[sling:resourceType]= 'wcm/foundation/components/parsys'
The above query returns the expected node in 6.1 but gives no nodes in 6.4
When I remove the "node.[sling:resourceType]" condition, it atleast lists out the relevant nodes. So it seems there is something off with the sling:resouceType condition. Is there anything that has changed in the querying syntax? I am unable to get any information on this elsewhere.
Also, when I replaced the sling:resourceType condition with a NAME() condition, the query works. There are other queries that are giving similar issues, so I would much rather get the old queries to work than to look for workarounds.
I hope someone can help me with this. Thanks in advance!
Thank you for the reply. But unfortunately this still doesn't work for me. I am able to query nodes in another project based on the sling:resourceType value. I am not sure if it is project related. Ideally, I don't think it will be.
I am sharing screenshots of the query and it's response. I am also attaching a screenshot of the node that should ideally be returned.Am I doing something wrong here?