Querbuilder returning results for % in the keyword

[Sb2512]

Hi All,

We have a requirement we need to search for results with percentage in content for example (97% off or 97%).

We are using ootb queryBuilder full text API for this.

But we are getting results which have 97(without %)also in the page.

What needs to be done to exclude such results from showing up in queryBuilder API.

We tried with both fulltext=97% and fulltext="97%"(in quotes).

For example we only want results which have "97%" as a whole in the page and exlude pages which have "97" in content.

Please find the below screenshots for reference for we-retail.

Page having 97 in the content

[nitesh_kumar]

Hi @Sb2512 ,

If you know the property field where you need to search then you can form your query like this

SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([<path>]) and s.[jcr:title] like '%97%\%'

Hope this helps!

Regards,

Nitesh

[Sb2512]

Can this be done using Query Builder API...We have search results with pagination so query builder seems to be better as it has lot more capabilities for our use case

[AsifChowdhury]

Hello @Sb2512 ,

If you want to search in the content you may have to write a custom predicate for that.

You will find a similar topic has been discussed in this thread: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/special-characters-search-... 

Thank you

[Sb2512]

For us ,we will have full text content search not a property search.

Can writing custom predicate will restrict pages with 97 in the search results.

One Page has 97 and one page has 97%.

I want to restrict Page with "97" to be shown in the search results.

[AsifChowdhury · Accepted solution]

You can read this thread: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/special-characters-search-... 

There you have a complete discussion for requirement.