JOIN QUERY

albertochana — Wed, 15 Dec 2010 15:50:12 GMT

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>

Re: JOIN QUERY

albertochana — Fri, 17 Dec 2010 13:17:32 GMT

The question about the JOIN is not solved, but now i can get the relationships with this source:

OperationContext operationContext = new OperationContextImpl();
operationContext.setIncludeRelationships(IncludeRelationships.BOTH);

But i cant execute a JOIN QUERY because the id is a relationship and not a property, isnt it possible to do this by a query similar like this:

select * from pw:record R JOIN pw:state E ON R.child_association_to_state=S.cmisbjectId

Any idea?

Thanks

topic JOIN QUERY in Alfresco Archive

JOIN QUERY

Re: JOIN QUERY