Exact difference between Jcr-xql2, xpath query and query builder api

[pavanb46130733]

Hi All,

Can you let me know the differences between Jcr-xql2, xpath query and query builder api .

Which is the best in among three to query the crx3.

Can you share me the official documentation links to these please?

Thanks in advance.

---

Regards,

Pavan Bukka

[smacdonald2008 · Accepted solution]

QUeryBuilder is built upon JCR SQL API. See: Query Builder API

You can use the QueryBuilder API within a custom AEM service and invoke it from an backend Java  HTL component (then display the result set in the HTL front end) -- see: Scott's Digital Community: Creating an AEM HTL component that queries the JCR

JCR SQL/2 docs can be found here: JCR 2.0: 6 Query (Content Repository for Java Technology API v2.0)

Community docs: 9 JCR-SQL2 Queries Every AEM Developer Should Know | 6D Labs

Another good community doc: http://www.aemcq5tutorials.com/tutorials/adobe-aem-cq5-tutorials/aem-query-builder/

As far as XPATH  - in later versions of AEM - this is not used much. Use ether QueryBuilder API or JCR SQL2.