Hi, this request is for our self-hosted Squidex solution with MongoDB in Atlas.
We have a schema A with references to schema B, C and D. The B,C,D schemas are lookup tables and some are localized. They mainly contain a single text string.
Schema A will only contain GUIDS as references to the other schemas, and the B,C,D VALUES are not added to the schema A search index field.
How can we search within schema A and return entities matching lookup values from the related schemas?
Right now we’re considering adding a tag field to schema A like e.g. “searchindex” and re-index by a microservice every night. This service will get all data from the B,C,D schemas and add the values from these in the tag field.
Do any of you know a better way to support searching related schemas?
*We have to use the rest apis and can’t use GraphQL queries.