@arunpatidar thanks, custom predicate helped to achieve this.

@arunpatidar thanks for sharing. I have three scenarios, it works for two scenarios but not the third one Apply date filter correctly (works fine)Get those shops as well which doesn't have closingDate property (works fine)Get those shops as well where closingDate property exists but it is empty (Doe...

I have following AEM query to get such shops which has closing date greater than current date and it works fine.   path=/content/data/shops type=nt:unstructured group.p.or=true group.1_daterange.property=closingDate group.1_daterange.lowerBound=2024-10-27T00:00:00  But there is possibility that clos...

I have written blog on this topic if could help the people facing this issueWildcard Case Insensitive Search using AEM Query Builder API 

Ok I found following solution and it is working perfectly.  @Component(factory = "com.day.cq.search.eval.PredicateEvaluator/likeIgnoreCase")public class CaseInsensitiveLike extends AbstractPredicateEvaluator { private static final Logger log = LoggerFactory.getLogger(CaseInsensitiveLike.class); ...

@pulkitvashisth thanks for your message. I don't want to perform fulltext search. Search on a specific property

I want to search a text in lower case in query builder api in aem. For example my node is /conent/mydata/stores. It has store id nodes, each store id node has store information in properties like storeName etc. I need to search store by storeName using query builder api. The search should work lower...

@arunpatidar So I need to do following two steps ? Listener to listen changes (Will it work on adobe cloud)Use Replication API (I need to use replication API code in my servlet to push node changes from author to publish ) ?

I am working on AEM project to be deployed on Adobe cloud. I have a requirement that whenever a store data node of nt:unstructured type say "store1" on the path /content/data/stores/store1 is created in JCR on author, it should be pushed on publish instance as well automatically. I guess we can use ...

I have following query in aem to use in query builder api type=nt:unstructuredpath=/content/datap.limit = -1 it returns resultset like/content/data/offers, (crxde, html, json)/content/data/offers/ec3e6681-5c2b-433b-8797-6a4dbe88e0d7, (crxde, html, json)/content/data/offers/0340d857-e7dc-4074-90a1-2f...