I have a Playlist collection and Audio collection. I want to fetch a document from Playlist collection using a specified playlist id. I also want to fetch all the Audio documents from Audio collection having the above said playlist id as one of its properties.The query result should have few properties of the Playlist collection and under another property name called “audioList” I want to have all audio docs with the specified playlist id . For example the result of the query should look like
PlaylistWithAudioList {
playlistId,
totalSongs,
totalDuration,
audioList
}
Here audioList is list of all audio docs having the specified playlistId from Audio Collection. I’m looking for query using join/nest operations.Thanks in advance.