Level 2

Resuelto

Special Characters Search using Querybuilder

Forum|Forum|8 years ago
August 3, 2018
24 respuestas
12278 visualizaciones

Hi All,

I have a query regarding the search in JCR:content,

1. In the AEM using QueryBuilder. When I try searching with keyword "

KalmKap®" the trademark symbols are not getting searched. Instead of that it is searching for the keyword "Kalmkap".

2. The special characters like "[", "]", "{", "}", and many..... my search is not working...

Below is my Query::

group.1_fulltext.relPath=jcr:content/@jcr:title

group.1_fulltext=[KalmKap]

group.1_fulltext.relPath=jcr:content/@jcr:title

group.1_fulltext=KalmKap®

kindly help me out on this........

Este tema ha sido cerrado para respuestas.

Mejor respuesta de arunpatidar

If you want to do this only with QueryBuilder then create custom predicate

e.g.

Code:

aem63app-repo/CaseInsensitiveLikePredicate.java at master · arunpatidar02/aem63app-repo · GitHub

Query

path=/content/we-retail/us/en/products

caseinsensitive.property=jcr:content/@jcr:title

caseinsensitive.value=%portland®%

arunpatidar

Community Advisor

Hi,

I am not sure if this is the bug or design issue. But you can try same with SQL2 or QueryBuilder API.

In XPATH you can run like below:

/jcr:root/content/AEM63App/en//*

[

(jcr:contains(., 'KalmKap(®)?'))

]

Arun Patidar

M

MeenuRajput

Level 3

Hi @arunpatidar ,

We're using jcr SQL2 and below mentioned is my query :

SELECT * FROM [cq:PageContent] AS s WHERE ISDESCENDANTNODE([/content/somepath]) AND (CONTAINS(s.[subtitle],"*home-page*") OR CONTAINS(s.[jcr:title],"*home-page*") OR CONTAINS(s.[jcr:description],"*home-page*"))

On search of text ("home-page") containing a special character, I get zero results. However, I do have 'home-page' in content nodes as per given conditions.

Could you please help me to correct my query to get results for text having a special character?

VeenaVikraman

Community Advisor

I think you should save the text using hex code for ® symbol. It will be ® .

smacdonald2008

Level 10

Nice suggestion veena!

sai_kumart66079Autor

Level 2

No that didn't work.... still my results are KalmKap.

VeenaVikraman

Community Advisor

Ohk. Will check on this and tell you . Did you try Arun's solution ?

sai_kumart66079Autor

Level 2

Tried with Arun's solution... But that didn't work.Arun Patidar

arunpatidar

Community Advisor

Hi Sai,

I gave try for XPATH query again,

works for me.

1. Result with query which you were trying; gives result for both demoText® and demoText

2. Result with below query gives only result which contains at least one ®

If you are not able to get the desire results you can try JAVA API for Search.

Thanks

Arun

Arun Patidar

S

Sb2512

Level 3

@arunpatidar Is there any way for when we search for demoText® Search we get only pages which have demoText® and not demoText.

As right now it shows for both demoText® and demoText.

I need to get the pages with only demoText® when i searched for demoText®.

arunpatidar

Community Advisor

You can try using like operator.

Arun Patidar

Techaspect_Solu

Level 7

Hi,

We could achieve your requirement by using the below query. We'd suggest you to give it a try and check if it works.

For trying the below query, go to "/content/we-retail/ca/en/men" and change jcr:title property in title component to "Featured products ®". Then hit the following query from http://localhost:4502/libs/cq/search/content/querydebug.html

path=/content/we-retail/ca/en/men

property=jcr:title

property.operation=like

property.value=%®%

p.limit=-1

You should see the result now.

Hope this helps!

Regards,

TechAspect Solutions