AnsweredAssumed Answered

IN_FOLDER not working

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

Hello,

 

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

 

André

 

---

I did test with CMIS Workbench and Alfresco5.2.

Alfresco Share v5.2.f (r137983-b22, Aikau 1.0.101.10, 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

Outcomes