Hi Kunal,Thank you for your reply.Looks like we are facing some issues with the results returned in the first requirement itself[i.e, when a single keyword is passed as a search parameter on the page], it is returning some unwanted results too.Checking on it and will keep you posted with our observa...

Hi Kunal,Missed out on making few things clear in the previous post.I mean when "ABC DEF" is provided as an input in the search page, we are trying to search for occurences of "ABC", "DEF" and "ABC DEF" seperately, rather than a single keyword[i.e, "ABC DEF"], by means of the above query.

Hi Kunal,The query seems to be working fine now.A minor clarification required from your end:1] In case, in the problem statement mentioned above, if we have "ABC" and "DEF" as the search keyword provided on the page, rather than "ABC DEF" [which was mentioned initially], then the below query should...

Hi Kunal,Will check on this and post back the results.

Hi Kunal,When tried, the query is working fine with a very minor change of ISCHILDNODE(s,parent). Thanks a lot for this query.However, one additional problem we are facing is it is looking for properties at page jcr:content level. If this page has a component c1, and if that has any  property it is ...

Hi Kunal,I tried with s.[hideInSearch] and it is returning zero results.Will try and see again ,if I can get anything on this.

Hi Kunal,It is returning zero results.

Hi Kunal,Thank you for your reply. Will check on this and let you know how it goes.

Hi Scott,Thank you for your reply.While trying to handle this via application code, we are facing some other issues. That being the reason, we wanted to somehow get unique page paths [like "/content/abc/def"] via this query itself.

Hi All,We have a below JCR-SQL2 query as below :SELECT DISTINCT Path FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/x/y]) AND (CONTAINS(s.[cq:tags],'ABC DEF^600') OR CONTAINS(s.blocktitle,'ABC DEF^400') OR (s.blocktitle LIKE 'ABC DEF%') OR CONTAINS(s.bodycopy,'ABC DEF^100') OR (s.bodycopy LIKE...