Hi, Yes, cmis:rm_clientMgtRetention is a secondary type (it is one that is defined in the spec).
My understanding is that cmis:objectId should be available for all secondary types, even without joins. Form 2.1.14.1.1: In addition, the virtual table for a secondary object type has one more virtual column for the cmis:objectId property defined by each object’s primary type. If a secondary object type does not define any property, then its virtual table will have cmis:objectId as the only column, identifying the objects to which the secondary type has been applied. Michael On Wed, Jul 24, 2013 at 2:42 PM, Huebel, Jens <j.hue...@sap.com> wrote: > Hi Michael, > > I assume that cmis:rm_clientMgtRetention is a secondary type, correct? > > In this case you cannot query for cmis:objectId because this is a property > of a primary type (e.g cmis:document). > > You have to use a join if you want to combine properties of primary and > secondary types > > Best regards > > Jens > > > On 24.07.13 13:46, "Michael Brackx" <michael.javaone+c...@gmail.com> > wrote: > > >Hi, > > > >There is a problem with the special virtual column cmis:objectId for > >secondary object types. > >Example query: "SELECT cmis:objectId FROM cmis:rm_clientMgtRetention" > >Error: Walking of statement failed with RecognitionException error: > > cmis:objectId is not a property query name in any of the types in from > >... > >Using version 0.9.0. > > > >QueryObject.resolveTypeForColumnReference() does not have special handling > >for object id. > >There is special handling in validateColumnReferenceAndResolveType(), but > >before you get there you hit a > >normal TypeValidator.typeContainsPropertyWithQueryName(). > > > >Michael > >
