Major Description
Create node /content/usergenerated/qtest with jcr:primaryType nt:unstrucuted.
Add 2 String properties: stringa = "a", stringb = "b".
Use query tool in CRX/DE to do SQL2 search:
This search will find qtest:
SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/usergenerated/]) AND (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
This search will find qtest:
SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/usergenerated/]) AND (CONTAINS(s.[stringb], 'b'))
This search will not find qtest:
SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/usergenerated/]) AND (s.[stringa] = 'x' OR CONTAINS(s.[stringb], 'b'))
