Does CQL support joins across multiple context sets?

[Farrukh Najmi <farrukh@wellfleetsoftware.com>]

Dear SearchWS TC colleagues,

First congratulations on a great specification.

It is not clear from reading [SearchRetrievePt5] whether a CQL query is expected to support doing a join across different context sets.
For example assume a context set name Employee (emp) and a context set name Department (dep).

Is it expected that the following query be supported?

//Find employees named Farrukh who work in department names Sales
emp.name = ‘*Farrukh* AND’ dep.name = ‘*sales*’ AND  emp.departmentId = dep.departmentId

If so, what are the semantics and where is it described in the spec?

I am guessing this is not supported since the grammar does not allow an index to be on the right hand side of a relation (as in: emp.departmentId = dep.departmentId ).

Thanks in advance for your clarification. Perhaps you might consider making this clearer in the next version of the spec. Thank you and best wishes towards gaining approval as an OASIS standard.

[SearchRetrievePt5]

searchRetrieve: Part 5. CQL: The Contextual Query Language Version 1.0. 13 April 2012. OASIS Committee Specification 01. http://docs.oasis-open.org/search-ws/searchRetrieve/v1.0/cs01/part5-cql/searchRetrieve-v1.0-cs01-part5-cql.html.

-- 
Regards,
Farrukh Najmi

Web: http://www.wellfleetsoftware.com