Thank you. notexists operation works!

I am trying to get a page that do not have jcr:node node.Query builderTried with Query builder but it is not excluding the nodepath=/content/en_GB/about-us property=jcr:primaryType property.value=cq:PageContent nodeExists.notexists=jcr:content p.limit=-1 JCR-SQL2Tried to create a SQL for the same bu...

I am trying to get browser name in servlet but it is giving me all browser details. Is there any way to get accurate browser name ? String browserName = req.getHeader("User-Agent"); String secNa = req.getHeader("sec-ch-ua"); LOG.info("browserName !!!!!!!"+browserName); LOG.info("secNa !!!!!!!"+secNa...

Kishore - This dept "2_property.depth=5" works  thanks. But it is returning the pageContent(page). I need to see the node where cq:headerVal lives. Can you tell me why it is not retuning node?

Sorry, zero result. This groping is not helping.

Great. Thank you Ram. It works (y). Can we do index if in case of sql2 query?

Seems regex is not supported - https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/regex-in-querybuilder/td-p/295552

Please find below xpath  //element(*, cq:Page) [ (jcr:content/@cq:template = '/apps/myproject/templates/full-content-page' and jcr:content/_x002a_/@cq:headerVal = 'col3') ]jcr:content/*/ became "jcr:content/_x002a_/" I think * is parsed as "_x002a_". I tried escape this * but no luck. can you tell i...

sorry, zero result. I think jcr:content/*/cq:headerVal is not working

I am trying to get a node based on 2 conditions,Condition number 1 - It should be /apps/myproject/templates/full-content-page templateConditionnumber 2 - It should have property as cq:headerVal and value should be "col3" I have created a query for these 2  conditions. Below query will be meet 1st co...