CODEWITHSUNDEEP
aemquery-builder
Surya Chandra
Surya Chandra

Reputation: 1591

How to implement search using Query Builder API for partial search text in CQ/AEM

I have a requirement to fetch search results based on partial text match. For example, if there is a node under products say "apple-iphone-6" and the user enters "iphone" text in the searchbox, I should still be able to fetch the result.

I tried the below query on querybuilder and it worked:

http://localhost:4502/bin/querybuilder.json?path=/etc/commerce/products&type=nt:unstructured&nodename=*iphone*

But, how to implement this programatically for the *iphone* part? I am creating a query using the predicates as follows

        String searchTerm = "iphone";
        map.put("path", "/etc/commerce/products");
        map.put("type", "nt:unstructured");
        map.put("nodename", searchTerm);

        Query query = queryBuilder.createQuery(PredicateGroup.create(map), session);
        SearchResult result = query.getResult();

But I do not get any results, reason being, the node name(apple-iphone-6) does not exactly match the search term (iphone). But the same thing works fine in case I append * to the nodename value which then implements partial text based search in the querybuilder example. What change should I do in the code to get results based on partial node name matches?

Upvotes: 3

Views: 4649

Answers (3)

Anmol Bhardwaj
Anmol Bhardwaj

Reputation: 674

For just the nodename the answer posted is correct, but if you want to search inside properties as well then :

map.put("fulltext","*"+searchTetm +"*");
map.put("fulltext.relPath","jcr:content");

Upvotes: 0

Suresh Gupta
Suresh Gupta

Reputation: 603

in this case "like" opration can be used:

EX-> patial text serach for jcr:title

    map.put("group.1_property", "fn:lower-case(@jcr:content/jcr:title)");
    map.put("group.1_property.value", "%"+fulltextSearchTerm + "%");
    map.put("group.1_property.operation", "like");

Upvotes: 3

d33t
d33t

Reputation: 1161

You already have found the solution on your own, the NodenamePredicateEvaluator accepts wildcard arguments, so you would need to surround the search term with wildcards, for example like this:

String searchTerm = "iphone";
...
map.put("nodename", "*" + searchTerm + "*");

Upvotes: 7

Related Questions