AnsweredAssumed Answered

JOIN QUERY

Question asked by albertochana on Dec 15, 2010
Latest reply on Dec 17, 2010 by albertochana
Hi, the problem is I have defined a type associated to other called "state". The association defined on model is:




<association name="pw:a_state">
  <title>R state</title>
  <source>
     <mandatory>false</mandatory>
     <many>true</many>
  </source>
  <target>
    <class>pw:state</class>
    <mandatory>false</mandatory>
    <many>true</many>
  </target>
</association>


How can I getting all types with its corresponding state by a join query or similar??

I have try the most easiest query select * from pw:my_type and it gets all properties in a QueryResult object, but the relationships object inside QueryResult is empty

Is it possible by a query? I cant execute a JOIN query on cmis:relationship because it is not queryable

Thanks

Outcomes