IN_FOLDER not working

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

afaust

Are you running a setup with a working SOLR index server? The difference between both queries is that IN_FOLDER can be executed against the database, and thus would work even if SOLR is not available / working correctly. Any query with IN_TREE always has to be executed on the SOLR index server and will fail if that is not available or return no results if the documents in question have not been properly indexed (yet).