Level 3

Solved

What should be the query to fetch all the pages which are having a specific word or start with that word in AEM query builder ?

7 replies
3704 views
Translate All

In my site i have a search bar on my UI where user can search for any specific page which starts with a letter or having that word in the page name. let suppose i have these pages "Check user details", "Check employee details", "User checkout timing details". And now user is searching with the keyword check, so it should return all the pages having word "check"

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Mahedi_SabujAccepted solution

Community Advisor

You can utilize the nodename predicate to search for pages by their name.

type = cq:Page
path = /content/aem-demo
nodename = *check*
p.limit = -1

https://experienceleague.adobe.com/docs/experience-manager-65/content/implementing/developing/platform/query-builder/querybuilder-predicate-reference.html?lang=en#nodename

Mahedi Sabuj

TarunKumar

Community Advisor

Hi @monish_gavali ,

In your query builder map you can use fulltext search functionality.
Something like below:

       map.put("path", "/content/<sample-path>");
     //searchText would be your variable or user input from search bar
        map.put("fulltext", searchText);
        map.put("type", "cq:Page");

Thanks
Tarun

Translate

salamswapnil

Community Advisor

Hi @monish_gavali

Please check below link for exactly similar use case. You have to use full text search query but it needs to be tweaked slightly.

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/fulltext-in-query-doesn-t-work-for-partial-search-term/m-p/402524

Translate

Mahedi_Sabuj

Accepted solution

Community Advisor

You can utilize the nodename predicate to search for pages by their name.

type = cq:Page
path = /content/aem-demo
nodename = *check*
p.limit = -1

https://experienceleague.adobe.com/docs/experience-manager-65/content/implementing/developing/platform/query-builder/querybuilder-predicate-reference.html?lang=en#nodename

Translate

Mahedi Sabuj

M

monish_gavaliAuthor

Level 3

It worked for me but what if i want to create some query in the below thing.

Translate

Mahedi_Sabuj

Community Advisor

Equivalent XPath Query

/jcr:root/content/aem-demo//element(*, cq:Page)
[
  (jcr:like(fn:name(), '%check%')) 
]

You can refer to this link for more details.
https://experienceleague.adobe.com/docs/experience-manager-65/assets/JCR_query_cheatsheet-v1.1.pdf?lang=en

Translate

Mahedi Sabuj

Imran Khan

Community Advisor

Below query will help

http://localhost:4502/libs/cq/search/content/querydebug.html?_charset_=UTF-8&query=type%3Dcq%3APage%0D%0Apath%3D%2Fcontent%2Fproject%2Fea%2Fen%0D%0Afulltext%3DEnglish*

type=cq:Page
path=/content/project/ea/en
fulltext=English*

Translate

kautuk_sahni

Adobe Employee

@monish_gavali Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

Translate

Kautuk Sahni

Sign up

Login with SSO

Login to the community

Login with SSO