topic Querying based on node language in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/querying-based-on-node-language/m-p/249626#M202756 <HTML><HEAD></HEAD><BODY><SPAN>I need to be able to query based on the nodes language. Something like:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>SELECT D.*, L.* FROM cmis:document JOIN &lt;language&gt; as L ON D.cmis:objectId = L.cmis:objectId WHERE L.&lt;language&gt; = 'en'<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Any help would be greatly appreciated.</SPAN></BODY></HTML> Tue, 27 Mar 2012 16:55:51 GMT biff45452 2012-03-27T16:55:51Z Querying based on node language https://connect.hyland.com/t5/alfresco-archive/querying-based-on-node-language/m-p/249626#M202756 I need to be able to query based on the nodes language. Something like<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />ELECT D.*, L.* FROM cmis:document JOIN &lt;language&gt; as L ON D.cmis<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId = L.cmis<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId WHERE L.&lt;language&gt; = 'en'‍Any help would be greatly appreciated. Tue, 27 Mar 2012 16:55:51 GMT https://connect.hyland.com/t5/alfresco-archive/querying-based-on-node-language/m-p/249626#M202756 biff45452 2012-03-27T16:55:51Z Re: Querying based on node language https://connect.hyland.com/t5/alfresco-archive/querying-based-on-node-language/m-p/249627#M202757 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>for something like this to work you need to enhance the metadata of your node to actually carry language information. There already is an Alfresco aspect for this, but a) aspects are not yet CMIS standard and supported in compliant CMIS SQL and b) I think the aspect has been deprecated in the latest version(s) of Alfresco. What I'd suggest is to define your own base document type which includes a simple language property (maybe even with a nice LIST constraint) and to use that type in your JOIN. I am hard pressed to find a different approach at the moment…</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Axel</SPAN></BODY></HTML> Mon, 09 Apr 2012 15:36:32 GMT https://connect.hyland.com/t5/alfresco-archive/querying-based-on-node-language/m-p/249627#M202757 afaust 2012-04-09T15:36:32Z