Using multiple PredicateGroups in QueryBuilder

Is there any way, we can implement partial text search instead of fulltextsearch?

VatsalGupta wrote...

Hi Darren,

I believe your requirement should be solved by using multiple predicate groups like below..
 

1. PredicateGroup predicateGroup1 = null;
2. Map<String, String> map = new HashMap<String, String>();
3. PredicateGroup predicateGroup2 = null;
4. Map<String, String> map2 = new HashMap<String, String>();
5.  
6. map1.put("path", "/content");
7. map1.put("type", "cq:Page");
8. map1.put("group.p.or", "true");
9. map1.put("group.1_fulltext", fulltextSearchTerm);
10. map1.put("group.1_fulltext.relPath", "jcr:content");
11. map1.put("group.2_fulltext", fulltextSearchTerm);
12. map1.put("group.2_fulltext.relPath", "jcr:content/@cq:tags");
13.  
14. map2.put("group.p.or", "true");
15. map2.put( "group.3_path" , "/content/geometrixx/en/company/management" );
16. map2.put( "group.4_path" , "/content/geometrixx/en/company/bod" );
17. ...
18.  
19. predicateGroup1 = PredicateGroup.create(map);
20. predicateGroup2 = PredicateGroup.create(map2);
21.  
22. predicateGroup1.add(predicateGroup2);
23. ...
24. queryBuilder.createQuery(predicateGroup1, session);

 

Hope it helps.

Regards

Vatsal

 

Thanks Vatsal. I would not have thought you could nest PredicateGroups.

Your welcome.

In fact if you would want to do a bit more complex query e.g applying a NOT operation on a Predicate group, that can also be done -

predicateGroup1 = PredicateGroup.create(map); predicateGroup2 = PredicateGroup.create(map2); predicateGroup2.setNegated(true); predicateGroup1.add(predicateGroup2);

You can check more operations here -

http://dev.day.com/docs/en/cq/current/javadoc/com/day/cq/search/PredicateGroup.html

Regards

Vatsal