How to write ATG RQL includes query?

Recently I had to write an ATG Repository Query (RQL) to load collection using “IN” query. I found the ATG API documents are not good enough to tell the story clearly. Below given example load all employees with give ids. The important API to understand is QueryBuilder.createIncludesQuery(QueryExpression valueExpression, QueryExpression propertyExpression); You would have noticed that [...]
Continue reading…

 

How to write contains/suggestion/match query using ATG RQL?

There are times when you may have to write contains query to support a suggestion drop-down or standard search functionality. ATG Object Oriented Query Language (RQL) supports contains query with the help of simple RQL API. QueryBuilder.createPatternMatchQuery(QueryExpression, QueryExpression, Integer) would help you fire a contains query against your relational data store.

Continue reading…