Hi All, Hope the day is going on well for you.
This question has been asked before, but I couldn't find answer to my specific request. I have many to many relationship and the mapping table has additional columns. Whats the best way I can model this into solr entity? For example: a user has many recordings and a recording belongs to many users. But each user-recording has additional feature like type, number etc. I'd like to fetch recordings for the user. If the user adds/ updates/ deletes a recording then that should be reflected in the search. I have 2 options: 1) to create user entity, recording entity and user_recording entity - this is good but it's like treating solr like rdbms which i mostly avoid.. 2) user entity containing all the recordings information and each recording containing user information - this has impact on index size but the fetch and manipulation will be faster. Any guidance will be good.. Thanks, Sandeep