chemistry-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Florent Guillaume (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CMIS-1012) OpenCMIS query parser does not allow selecting secondary properties in simple queries
Date Tue, 14 Feb 2017 13:53:42 GMT

    [ 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)

Mime
View raw message