Full Text Index over a view
My organization has a few use cases where we have a service 'join' various docs and write them into a 'consolidated doc' in elastic search to support various nested query requirements. It would be great if we could use FTS on a mongo/atlas view as we could then eliminate the need for our data joining service and its associated latency and consistency issues.
Also fyi - it appears this is 'possible' in the current Atlas portal/UI and via the API. You can define a full text index on a view - but it disappears after a minute or two.
4
votes
Tim Frietas
shared this idea
See a variety of tutorials on how to achieve this here: https://www.mongodb.com/docs/atlas/atlas-search/tutorial/cross-collection-tutorials/