Seach using DB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2021 12:07 PM
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
- Labels:
-
Alfresco Content Services
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2021 12:29 AM
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.
(ACSCE, AWS SAA, Azure Admin)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2021 09:48 AM
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
