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
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):
Using the "exact" modifier also does not work:
0 results are returned, but no errors are thrown.
The FTS query should return the same results regardless of the search system.
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.