[OASIS Issue Tracker] Commented: (CMIS-716) Query for v1.1

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/CMIS-716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=25256#action_25256 ] 

Alexander Haag commented on CMIS-716:
-------------------------------------

Maybe it's not an extension or change, but more a clarification for queries.
How does CMIS handle multiple object type searches?

In specification is described (pages 70/71):
2697 • FROM [Virtual Table Names]: This clause identifies which Virtual Table(s) the query will run 
2698 against.
...
2730 <from clause> ::= FROM <table reference>
2731 <table reference> ::= <table name> [ [ AS ] <correlation name> ]
2732 | <joined table> 
Is the plural "Virtual Table(s) " mentioned to be only for join-operation?

Simple example to explain the problem: One parent object type "insurance", which has many subtypes "health insurance", "car insurance"  and so on.
Requirement for our client was to shows only "health" and "pension" insurance objects, columns (properties) are general (from parent type)!
Should the client then send two search to get the information?
SELECT * FROM health insurance
SELECT * FROM pension insurance

Regarding BNF following is not allowed:

SELECT * FROM heath insurance, pension insurance

SELECT * FROM health insurance
UNION
SELECT * FROM pension insurance


> Query for v1.1
> --------------
>
>                 Key: CMIS-716
>                 URL: http://tools.oasis-open.org/issues/browse/CMIS-716
>             Project: OASIS Content Management Interoperability Services (CMIS) TC
>          Issue Type: Improvement
>          Components: Domain Model
>    Affects Versions: V1.1
>            Reporter: David Choy
>
> Per discussion at the 21 March 2011 TC meeting, this item is created as a forum to collect input on any aspect of the query capability that may need change/extension for v1.1. Depending on the input, the TC will determine the next step.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira