Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Anderson_Hamer
Anderson_Hamer
Offline

Badges

Badges
19

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
25

Posts & Comments

Posts & Comments
69

Discussions

Discussions
0

Questions

Questions
0

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Anderson_Hamer
Customize the badges you want to showcase on your profile
Re: How to exclude node in aem using Query builder and JCR-SQL2? - Adobe Experience Manager 29-09-2021
Thank you. notexists operation works!

Views

411

Like

1

Replies

0
How to exclude node in aem using Query builder and JCR-SQL2? - Adobe Experience Manager 29-09-2021
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 but query is giving exception while running, SELECT * FROM [cq:PageContent] AS s WHERE ISDESCENDANTNODE(s, '/content/en_GB/about-us') NOT (jcr:content) Can you please help me to understand why above sql...

Views

425

Likes

0

Replies

2
How to get browser details in AEM Servlet? - Adobe Experience Manager 03-09-2021
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);Below are log infoFF browser:-browserName !!!!!!!Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Firefox/91.0secNa !!!!!!! nullChrome brwoserbrowserName !!!!!!!Mozilla/5.0 (Mac...

Views

873

Likes

0

Replies

9
Re: How to combine two queries in AEM? - Adobe Experience Manager 11-08-2021
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?

Views

772

Like

1

Replies

1
Re: How to combine two queries in AEM? - Adobe Experience Manager 11-08-2021
Sorry, zero result. This groping is not helping.

Views

772

Like

1

Replies

0
Re: How to combine two queries in AEM? - Adobe Experience Manager 11-08-2021
Great. Thank you Ram. It works (y). Can we do index if in case of sql2 query?

Views

772

Likes

2

Replies

1
Re: How to combine two queries in AEM? - Adobe Experience Manager 11-08-2021
Seems regex is not supported - https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/regex-in-querybuilder/td-p/295552

Views

787

Like

1

Replies

3
Re: How to combine two queries in AEM? - Adobe Experience Manager 11-08-2021
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 if there any we can manage this?

Views

788

Like

1

Replies

0
Re: How to combine two queries in AEM? - Adobe Experience Manager 11-08-2021
sorry, zero result. I think jcr:content/*/cq:headerVal is not working

Views

802

Like

1

Replies

0
How to combine two queries in AEM? - Adobe Experience Manager 11-08-2021
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 condition path=/content/myproject/sites/en-us 1_property=jcr:primaryType 1_property.value=cq:PageContent 2_property=cq:template 2_property.value=/apps/myproject/templates/full-content-page This query is ...

Views

817

Likes

0

Replies

12