AnsweredAssumed Answered

IN_FOLDER not working

Question asked by plean on Mar 23, 2018
Latest reply on Mar 23, 2018 by plean



I did try the query, I don't get any result:


select d.* from cmis:document as d
where  IN_TREE (d, '8af4943a-44c5-43f4-8049-b193392ca0c4')
ORDER BY d.cmis:lastModificationDate desc


but when I change IN_TREE with IN_FOLDER, it works fine:


select d.* from cmis:document as d
where  IN_FOLDER (d, '8af4943a-44c5-43f4-8049-b193392ca0c4')
ORDER BY d.cmis:lastModificationDate desc


As far as I could find IN_TREE and IN_FOLDER are supposed to work the same way, except IN_TREE also contains sub-directories.


Any help would be highly appreciated





I did test with CMIS Workbench and Alfresco5.2.

Alfresco Share v5.2.f (r137983-b22, Aikau, Spring Surf 5.2.f, Spring WebScripts 6.15, Freemarker 2.3.20-alfresco-patched, Rhino 1.7R4-alfresco-patched, Yui 2.9.0-alfresco-20141223) Alfresco Community v5.2.0 (re21f2be5-b22) schema 10057