topic SQL equivalent of XPATH in Alfresco Archive

SQL equivalent of XPATH

amit_wmw — Mon, 20 Apr 2009 12:09:00 GMT

Hello Can anyone please suggest me SQL query equivalent of below XPATH query?Query query = queryManager.createQuery("//app:company_home//element(*, cm:content) [jcr:contains(@cm:author, 'Amit') ]", Query.XPATH);‍I can able to successfully search content with the help of above XPATH query but I am un

Re: SQL equivalent of XPATH

derek — Tue, 21 Apr 2009 08:34:26 GMT

Hi,
There is no SQL query language implementation - despite the static option that suggests otherwise. Using the XPath query with the

…//element…‍

would be horrendous (as I'm sure you've discovered) because it has to walk the entire hierarchy and look at the properties of every node do determine who authored a particular document. Lucene should be used for this type of query.
Regards

Re: SQL equivalent of XPATH

amit_wmw — Wed, 22 Apr 2009 11:10:47 GMT

Hi Derek

Thanks for your suggestions.

Yes, Xpath is slow. Moreover I think there is no way in XPATH to query and retrieve nodes created between two time slots (i.e. say: to retrieve nodes created between 12.00 PM to 03.00 PM), as <= or >= does not works! While there seems to be a possibility for the same in Lucene using range queries.

I know how to use Lucene through Alfresco API(SearchService) but using pure JCR API how can we do it? Is there any basic example/sample for the same? Can anybody please share.

Thanks

Amit.