Seach using DB

[ranjeetsi]

Hi alfresco community,

I am using Alfresco contnet Services 6.2.2 .

Would like to use DB to search contnet& properties and not solr6 .Can you please let me know what settings i can do to test it. 

Appreciate responses on it.

regards,

Ranjeet

p.s -  We don't have Full text search requirement

[abhinavmishra14]

AFAIK, you can only make use of TMDQ in this case. Also not every query would be supported. 

Refer the documentation here:

https://docs.alfresco.com/search-services/latest/using/ 

https://docs.alfresco.com/search-services/latest/config/transactional/ 

https://hub.alfresco.com/t5/alfresco-content-services-blog/transactional-metadata-query-tmdq/ba-p/28... 

You would have to set the following property as:

solr.query.cmis.queryConsistency=TRANSACTIONAL

same for fts if needed. 

Also consider performance scenarios before taking this approach to production. 

[ranjeetsi]

 Hi @abhinavmishra14 ,

Thanks for your reply - Actually i have already tried that but after making the changes the search doesn't work.

Not able to get search results post the changes.

regards,

Ranjeet