Querying based on node language

[biff45452]

I need to be able to query based on the nodes language. Something like:

SELECT D.*, L.* FROM cmis:document JOIN <language> as L ON D.cmis:objectId = L.cmis:objectId WHERE L.<language> = 'en'‍

Any help would be greatly appreciated.

[afaust]

Hello,

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…

Regards
Axel