DB Query using fts-alfresco and PATH?

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.

sarah_jordison

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 simple things, like new documents.

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

Here is my code:

   …
   getAll : function(department)
   {
      var query, def;
      
                //Look within a folder and search for specific documents with aspect completed
      query = 'PATH:"//app:company_home/app:dictionary/cm:SomeCo/'+department+'/*" AND TYPE:"cm:content" AND ASPECT:"someco:completed"';
      
      //Define Query params
           def = 
      { 
         query: query,
         store: "workspace://SpacesStore", 
         language: "fts-alfresco", 
         sort: [{  column: "@{http://www.alfresco.org/model/content/1.0}name",  ascending: true } ] 
      };

      //Resultset!
      return search.query(def);
   }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

And I have also added this to alfresco-global.properties

solr.query.cmis.queryConsistency=TRANSACTIONAL_IF_POSSIBLE
solr.query.fts.queryConsistency=TRANSACTIONAL_IF_POSSIBLE
 
### Optional patch that adds required indexes to the DB ###
system.metadata-query-indexes.ignored=false
‍‍‍‍‍‍‍

afaust

Hello,

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.

Regards
Axel