Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.

Query Builder Debugger - Query Question

Avatar

Level 4

Hi All,

 

I am trying to query a specific URL that's in both component configs and plain RTEs in a specific path but the query builder debugger can't seem to find results that I know are def. on the pages.

Can anyone help me with what I may be doing wrong with this query?

path=/content/(website)
fulltext=(FULL URL)
p.limit=-1

I'm a complete noob obviously so any help would be appreciated.

Kind Regards.

10 Replies

Avatar

Community Advisor

Hi @RooRue,

Syntactically, there is no issue with the query -

path=/content/we-retail

fulltext=pants

p.limit=-1

 

This will find all [nt:base] JCR nodes matching any %pants%

Rohan_Garg_0-1678761681115.png

 

The issue might be with the URL itself. Can you share the URL you are looking for ?

Also, can you try using a subset of the complete URL ?

 

I tried the below query for a dummy search with https:// based URL- 

Rohan_Garg_1-1678762370093.png

 

You can refer to the below cheat-sheet for quick reference -

https://github.com/paulrohrbeck/aem-links/blob/master/querybuilder_cheatsheet.md

Avatar

Community Advisor

@RooRue :

 

able to fetch it using fulltext . Make sure you provided the Path properly . Can please share the what is the property name.

SivakumarKanoori_0-1678768871180.png

 

Thanks,
Siva

Avatar

Community Advisor

@RooRue - The URL pattern and syntax both are correct.

Best guess could be an inadvertent space when copy pasting the URL perhaps.

Can you try using a subset of the URL like /s/request-enquiry & see if still you get no result ?

 

Alternatively, you can add specific selectors to the query like property name to filter results instead of full text search.

To see if the node has property PROPERTY_NAME under path /content/(website)

path=/content/(Website)
type=nt:unstructured (sling:OsgiConfig for configuration nodes)
property=PROPERTY_NAME
property.value=www.support.amp.com.au/s/request-enquiry 

Avatar

Level 4

It's strange, I try these queries and I only get 1 result and that's to a page that has a subsection of this URL, not the full URL. I still can't get it to find the URL on the main page I know it's on and the test page I made for this. 

Could there be something that causes the query builder to not always be up-to-date with the aem content? 

We recently did a migration from prem to cloud.. the QB URL is the cloud environment URL.. just so confused why something that seems this simple isn't working as expected.

Avatar

Community Advisor

The query builder usually reflects instant results for any changes made to the repository. (excluding the time taken for the query to execute)

There is nothing in the documentation which highlights the difference in QB for on-prem vs cloud.
(https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/implementing/develo...)

 

Avatar

Level 4

Dang, then I am really lost as to why I can't seem to get this url to return in the results.

Avatar

Community Advisor

Let us try to get someone else into this discussion to see if they can help.

@arunpatidar - Can you help with this query?

It is a simple full text query which is working for us but not for @RooRue!

 

Thanks in advance!

Rohan Garg

Avatar

Community Advisor

Hi @RooRue 
Can you please share a sample node as json or screenshot.

It will help to understand the node type, property name and values



Arun Patidar

Avatar

Community Advisor

@RooRue :

 

I am able to get the results as below.

SivakumarKanoori_0-1678762519015.png

 

 

You can tell , what is the url you are trying to get it.

Thanks,
Siva