topic Re: Seach using DB in Alfresco Forum

Seach using DB

ranjeetsi — Sat, 20 Mar 2021 16:07:21 GMT

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 — Mon, 22 Mar 2021 04:29:38 GMT

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

Refer the documentation here:

solr.query.cmis.queryConsistency=TRANSACTIONAL

same for fts if needed.

Also consider performance scenarios before taking this approach to production.

ranjeetsi — Mon, 22 Mar 2021 13:48:36 GMT

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