topic Query over Relations in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/query-over-relations/m-p/250413#M203543 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm looking for a solution for the following problem:</SPAN><BR /><SPAN>I've designed a simple content model, containing several custom document types and, for some own workflow implementation, a 'workflowcontrol' type. The intitial idea was, the relate a 'workflowcontrol' to each document, since I won't have to change the document meta itself then - for example, if status changes or the responsible editor person is replaced. In addition 'user' and 'team' types (for simplicity all derived from cm:content) have been implemented and are assigned (as relations) to each 'workflowcontrol' object.</SPAN><BR /><BR /><SPAN>[Editor] &lt;1 —- n&gt; [workflowcontrol] &lt;1 —- 1&gt; [document]</SPAN><BR /><BR /><SPAN>Now my problem: I'm using the opencmis api to build a client application, and, for example, I need to count all documents related to an editor object. Since I cannot (or at least think, I can't) join over these relations in queries, I have implemented a very, very slow (but finally working) mechanism, that first gets the 'editor' object and then get it's source(or target) 'workflowcontrol's, counting over the iterator. Of course it becomes even slower, if I want to get the 'documents' with a certain status (i.e. 'new'), which is stored in the 'workflowcontrol'. In this case, for each 'workflowcontrol' retrieved I would have to get relation target documents as well.</SPAN><BR /><SPAN>Since I'm not sure, if we use alfresco as the final repository (that why we use cmis <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /> ), we decided not to use aspects and so this (propably best) way of implementing this kind of logic is not an option. Are there any ideas, how to implement this logic with little more performance?</SPAN><BR /><SPAN>One possibility would be using weaker links (maybe a string field containing object id's instead of each relation), but maybe there are better ways.</SPAN><BR /><BR /><SPAN>thank you in advance</SPAN><BR /><BR /><SPAN>Sebastian</SPAN></BODY></HTML> Thu, 12 Jan 2012 10:53:25 GMT schaefse 2012-01-12T10:53:25Z Query over Relations https://connect.hyland.com/t5/alfresco-archive/query-over-relations/m-p/250413#M203543 Hi,I'm looking for a solution for the following problem:I've designed a simple content model, containing several custom document types and, for some own workflow implementation, a 'workflowcontrol' type. The intitial idea was, the relate a 'workflowcontrol' to each document, since I won't have to ch Thu, 12 Jan 2012 10:53:25 GMT https://connect.hyland.com/t5/alfresco-archive/query-over-relations/m-p/250413#M203543 schaefse 2012-01-12T10:53:25Z Re: Query over Relations https://connect.hyland.com/t5/alfresco-archive/query-over-relations/m-p/250414#M203544 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco Query Language </SPAN><STRONG>does not support querys</STRONG><SPAN> on </SPAN><STRONG>cmis:relations</STRONG><SPAN> objects (for now).</SPAN><BR /><BR /><SPAN>You can use </SPAN><STRONG>getObjectRelationships </STRONG><SPAN>function on</SPAN><EM> CMIS RelationShip Service</EM><SPAN>.</SPAN></BODY></HTML> Sat, 21 Jan 2012 20:49:59 GMT https://connect.hyland.com/t5/alfresco-archive/query-over-relations/m-p/250414#M203544 pedronaranjo 2012-01-21T20:49:59Z