How to manage the Special characters in Full Text AEM Query search | Community
Skip to main content
October 12, 2023
Solved

How to manage the Special characters in Full Text AEM Query search

  • October 12, 2023
  • 2 replies
  • 1307 views

We are trying to implement search using Full text AEM query. For the keywords without special characters, we are able to get the results, but the presence of any special character is breaking and there is no result.

 

 

 

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

@k_bobade Assuming you are using querybuilder.json, in above screen shot. Please check response marked as correct in below post:

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/provide-restricted-access-to-bin-querybuilder-json/td-p/462794

Quoting from the same thread:

Try the XPATH or JCR-SQL2 equivalent of the above query which has support for wildcard character in jcr:contains 

(You can arrive at the same using Explain Query: Tools -> Operations -> Diagnosis -> Query Performance -> Explain Query -> Key in your Query builder predicates -> You can see the XPATH and JCR-SQL2 equivalent and index used)

 

There is no explicit mention about wildcard support in fulltext Query Builder predicate. 

2 replies

krati_garg
Adobe Employee
krati_gargAdobe EmployeeAccepted solution
Adobe Employee
October 12, 2023

@k_bobade Assuming you are using querybuilder.json, in above screen shot. Please check response marked as correct in below post:

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/provide-restricted-access-to-bin-querybuilder-json/td-p/462794

Quoting from the same thread:

Try the XPATH or JCR-SQL2 equivalent of the above query which has support for wildcard character in jcr:contains 

(You can arrive at the same using Explain Query: Tools -> Operations -> Diagnosis -> Query Performance -> Explain Query -> Key in your Query builder predicates -> You can see the XPATH and JCR-SQL2 equivalent and index used)

 

There is no explicit mention about wildcard support in fulltext Query Builder predicate. 

Adobe Employee
October 12, 2023

Hello ,

In AEM special characters in search text are completely ignored and replaced by space.

For eg. hello@12 is searched as hello 12

will result in assets having either hello or 12 or both.