JCR-SQL-2 query - How do we combine results for different result types using JCR-SQL-2 query?

Question

I am trying to get results from SELECT *FROM [cq:Page] AS sandSELECT *FROM [nt:unstructured] AS t Union is not working for me, any suggestions appreciated

Aditya_Chabuku · Accepted Answer

Hi @kaustubatm1 ,

AEM SQL2 doesnt support keyword "UNION", instead use "JOIN".

However, there should be a relation between both nodes like a parent-child, So then it will work.

I'm giving such an example for your quick referance, But if you want to deep dive & learn more. try link given above.

SELECT * 
FROM [cq:Page] AS p 
JOIN [nt:unstructured] AS u 
ON ISDESCENDANTNODE(u, p)

Tethich · Answer

Hi @kaustubatm1  Try please this version of the query:SELECT * FROM [cq:Page] AS xUNIONSELECT * FROM [nt:unstructured] AS x

Sign up

Login with SSO

Login to the community

Login with SSO