I’m using SugarCrm with ElasticSearch as one of my backend systems. One of our entities have 3 N:N relations with other entities. I perform my search via standard Sugar API, and if I understand correctly there is no way to search via API to include fields in related entities.
Because search via Sugar API is rather slow I was wondering if I could use Elastic to search/fetch my entities with related entities. When I explored Elastic (all relevant entities are configured to sync) I only found main entities with no trace of relationships.
My question is rather simple, is there a way to utilize Elastic to fetch entire entity (with related records) and to perform complex searches that include nested properties?