IN_FOLDER not working

[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).

[plean]

Thanks for this information. I will search in this direction in the next days. I will inform about any changes ...