Using Alfresco Community - 5.0.0 version.
Tried below properties in alfresco-global.properties file:
queryConsistency=EVENTUAL then all queries are going to Solr.
queryConsistency=TRANSACTIONAL then all queries are going to DB.
And Default mode executes all queries from DB first then Solr in case of failure from DB.
Q1: Is there any mode by which I can query Solr first and if there are no results from Solr then query DB in one transaction?
Q2: Can we execute some queries from Solr and some from DB from JAVA side?