topic DB Query using fts-alfresco and PATH? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/db-query-using-fts-alfresco-and-path/m-p/286079#M239209 <HTML><HEAD></HEAD><BODY><SPAN>Hi Guys,</SPAN><BR /><BR /><SPAN>Does anyone know if it's possible to run a query inside a folder using fts-alfresco…and have it not wait for SOLR? Even if I create files, it takes a few minutes to pick it up and my end-users think something broke. I would like to have the query run at the transaction level and display simple things, like new documents.</SPAN><BR /><BR /><SPAN>In earlier version of Alfresco this would just work. I really don't want to have to create another folder for my completed documents and then use childByNamePath, because I hear that causes performance issues (plus its a sucky solution).</SPAN><BR /><BR /><SPAN>Here is my code:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp; …<BR />&nbsp;&nbsp; getAll : function(department)<BR />&nbsp;&nbsp;&nbsp;{<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var query, def;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //Look within a folder and search for specific documents with aspect completed<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;query = 'PATH:"//app:company_home/app:dictionary/cm:SomeCo/'+department+'/*" AND TYPE:"cm:content" AND ASPECT:"someco:completed"';<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Define Query params<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; def = <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{ <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;query: query,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;store: "workspace://SpacesStore", <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;language: "fts-alfresco", <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sort: [{&nbsp; column: "@{<A href="http://www.alfresco.org/model/content/1.0}name" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/content/1.0}name</A>",&nbsp; ascending: true } ] <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;};<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Resultset!<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return search.query(def);<BR />&nbsp;&nbsp;&nbsp;}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><BR /><SPAN>And I have also added this to alfresco-global.properties</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />solr.query.cmis.queryConsistency=TRANSACTIONAL_IF_POSSIBLE<BR />solr.query.fts.queryConsistency=TRANSACTIONAL_IF_POSSIBLE<BR /> <BR />### Optional patch that adds required indexes to the DB ###<BR />system.metadata-query-indexes.ignored=false<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Sat, 20 Feb 2016 07:50:35 GMT sarah_jordison 2016-02-20T07:50:35Z DB Query using fts-alfresco and PATH? https://connect.hyland.com/t5/alfresco-archive/db-query-using-fts-alfresco-and-path/m-p/286079#M239209 Hi Guys,Does anyone know if it's possible to run a query inside a folder using fts-alfresco…and have it not wait for SOLR? Even if I create files, it takes a few minutes to pick it up and my end-users think something broke. I would like to have the query run at the transaction level and display simp Sat, 20 Feb 2016 07:50:35 GMT https://connect.hyland.com/t5/alfresco-archive/db-query-using-fts-alfresco-and-path/m-p/286079#M239209 sarah_jordison 2016-02-20T07:50:35Z Re: DB Query using fts-alfresco and PATH? https://connect.hyland.com/t5/alfresco-archive/db-query-using-fts-alfresco-and-path/m-p/286080#M239210 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>you can't search for PATH using DB FTS. If you only want to look for children of a specific folder, you can use PARENT:"some://node/ref" as a query condition. You'd have to resolve the path to the node first but other than that, it is ideal for the use case you described.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Axel</SPAN></BODY></HTML> Mon, 22 Feb 2016 11:45:12 GMT https://connect.hyland.com/t5/alfresco-archive/db-query-using-fts-alfresco-and-path/m-p/286080#M239210 afaust 2016-02-22T11:45:12Z