[
https://issues.apache.org/jira/browse/CMIS-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15865793#comment-15865793
]
Florent Guillaume commented on CMIS-1012:
-----------------------------------------
I believe that this is on purpose, and that the way to do it according to the
spec is to JOIN on the secondary type to be able to use its properties.
> OpenCMIS query parser does not allow selecting secondary properties in simple
> queries
> -------------------------------------------------------------------------------------
>
> Key: CMIS-1012
> URL: https://issues.apache.org/jira/browse/CMIS-1012
> Project: Chemistry
> Issue Type: Bug
> Components: opencmis-server
> Affects Versions: OpenCMIS 1.0.0
> Reporter: Jens Hübel
> Priority: Minor
>
> The query parser in OpenCMIS allows only to select properties which are part
> of a type that is mentioned in a FROM or JOIN statement. It is not possible
> to retrieve properties from secondary types when doing a simple query on a
> primary type (unless you use SELECT *).
> Example:
> SELECT cmis:name, cmis:objectId, mySecondaryProperty FROM cmis:document WHERE
> cmis:createdBy = 'joe'
> fails to parse with
> mySecondaryProperty is not a property query name in any of the types in from
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
