How to identify the table name of the folder (from folder view in Alfresco) to join with cmis:document

Question

How to write the query joins using CMIS Query language. Given below is the query from the existing code. The folder in the repository is "Client" whereas in the code, the table name for this folder is clientDocument:info. And it joins on cmis:objectId. Appreciate your help in clarifying my question

Example :

SELECT
  d.*, g.* 
  FROM
  cmis:document d JOIN clientDocument:info g
  ON
  d.cmis:objectId=g.cmis:objectId

Answer 1

If I understood you correctly:

• aspects "act" like tables
• properties "act" like columns

So if you have a custom aspect containing a property, you're "selecting from or joining" with an aspect (table), and using a property (column) in a where clause.