Joining cmis:folder and cmis:document

To all concerned,

One of the challenges we've been facing with utilizing CMIS DiscoveryService is forming a query that returns the folder path(s) of a document in the SELECT clause. There are plenty of ways of using the folder in the WHERE clause to specify a place to search (i.e. IN_FOLDER(), etc...)

in DQL one would simply join dm_document to dm_folder where dm_folder.r_object_id = ANY dm_document.i_folder_id, but CMIS is restricted on joining to repeating attributes AND there is not a nice way to get a handle on i_folder_id for a cmis:document.

Any thoughts on the matter would be greatly appreciated.

Nate

Find more posts tagged with

Comments

abc123

CMIS Query is not equivalent to DQL and the 1st release version doesn't have any extensions on Documentum specific query.

- William

ndegroff

Thanks William for your reply. In the past few months as we work through the pains and pitfalls of integrating CMIS into our infrastructure that the generic nature of CMIS queries leaves a great deal of power. CMIS provides ability to query documents by folder in the WHERE clause using functions like IN_FOLDER(), but not able to glean information about the folder itself in a select clause.

I think i've succumbed to that reality and hope that in the CMIS 2.0 release, more support on getting folder information in one query across multiple documents could be supported.