We have this document structure in mongo
masterProduct_id: String category: String variants: [ variantGroup_id: String priority: Number accessories: [ masterProduct_id: String variantGroup_id: String ] ]
I need to query accessories for 1 product variant to be shown on page.
Relations between accessories are on variants level, so identified by masterProduct_id and variantGroup_id pair.
Result should be represented by array of categories and in every category top 3 variants based on "priority".
Currently we are syncing it to ES using transporter, so no nested indexes created by default.
I am trying to reach my goal step by step and studying documentation atm.