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?#QuerySELECT * 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])
#Errorjava.text.ParseException...