Collection Query Problem

Ask the community
,
3

Hi,

references fields hold ids of referenced items. The id of an item is always the _id field (it is not the same as the primary field! Primary field is used only for displaying the item in UI).

The query also depends, on whether you use single or multi reference. As I see, you use multi, you can query:

wixData.query('TVSeasons')
  .hasSome('tv-shows-2', tvShow._id)
  .find()

This will find all TVSeasons that are a part of the given show. If you have shows you can get tvShow by doing $w(‘#dataset1’).getCurrentItem().

If say, you modelled using a single references (tv-shows-2 was a singular reference to TVShows collection), you would use equals:

wixData.query('TVSeasons')
  .eq('tv-shows-2', tvShow._id)
  .find()

I hope this helps. Let me know!