IN_FOLDER not working

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Active Member II

IN_FOLDER not working

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 Smiley Happy

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
2 Replies
Highlighted
Master

Re: IN_FOLDER not working

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

Highlighted
Active Member II

Re: IN_FOLDER not working

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