topic IN_FOLDER not working in Alfresco Forum

IN_FOLDER not working

plean — Fri, 23 Mar 2018 08:38:23 GMT

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 descbut when I change IN_TREE with IN_FOLDER, it works fine:select d.* from cmis:document as d where IN_FOLDER (d, '8a

Re: IN_FOLDER not working

afaust — Fri, 23 Mar 2018 11:25:42 GMT

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

Re: IN_FOLDER not working

plean — Fri, 23 Mar 2018 14:16:23 GMT

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