Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-16625

Improve support of transactional metadata queries

    Details

    • ACT Numbers:

      00688006

      Description

      Improve support of queries in the node browser, specifically db-afts, for the sys:node-dbid. Currently, the sys:node-dbid property cannot be found when searching against the database ("No Index"). However, it is found using the alfresco-fts query against the Solr index.

      [Steps that show the current behaviour]

      1. Open the node browser and navigate to an existing piece of content, documentA. Note the value of sys:node-dbid, which in this case is 18455.
      2. In the node browser search, run an alfresco-fts query for

      @sys:node-dbid:"18455"

      This should return documentA.

      3. Open the Admin Console > Search Service, and change the search service to No Index.
      4. Return to the node browser and run the following query as alfresco-fts (or db-afts, the query is converted to db-afts with No Index):

      sys:node-dbid:"18455"

      Using the "exact" modifier also does not work:

      =sys:node-dbid:"18455"

      0 results are returned, but no errors are thrown.

      [Desired behaviour]
      The FTS query should return the same results regardless of the search system.

      [Business case]
      Solr is eventually consistent, but documents need to be available to users immediately after upload. Files are programmatically added to a list of available documents, but the metadata can't be edited because it's still not indexed by Solr. The solution is to use the transactional metadata queries instead of relying on the Solr index, but the sys:node-dbid property can't be searched for in this way.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                searchAndDiscovery Search and Discovery
                Reporter:
                dray Dwayne Ray
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 10 minutes
                  10m