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
Solved! Go to Solution.
Views
Replies
Total Likes
You can read this thread: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/special-characters-search-...
There you have a complete discussion for requirement.
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
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
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
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.
You can read this thread: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/special-characters-search-...
There you have a complete discussion for requirement.
Views
Likes
Replies