Highlighted

AEM Sql2 subqury is not working

codingStar

28-10-2019

Hi,

I am trying to use SQL2 sub-query while I am executing the query getting error. Below is my query and error. Can someone look share whats wrong i am doing here?

#Query

SELECT * FROM [nt:base] WHERE [sling:resourceType] = 'mywebsite/components/content/button' AND [buttonURL] IN(SELECT [jcr:path] FROM [dam:Asset] AS s WHERE CONTAINS(s.*, 'mysearchKeyword') AND [jcr:path] ISDESCENDANTNODE([/content/dam/mywebsite])) AND ISDESCENDANTNODE([/content/mywebsite/dashboard])

#Error

java.text.ParseException: Query: SELECT * FROM [nt:base] WHERE [sling:resourceType] = 'mywebsite/components/content/button' AND [buttonURL] IN(SELECT(*)[jcr:path] FROM [dam:Asset] AS s WHERE CONTAINS(s.*, 'mysearchKeyword') AND [jcr:path] ISDESCENDANTNODE([/content/dam/mywebsite])) AND ISDESCENDANTNODE([/content/mywebsite/dashboard]); expected: static operand