The Data Types documentation for for wix-data states the following
Field Type - Reference/Multiple Items Reference
Notes - An item ID or multiple items IDs from the referenced collection.
I expect to get an array of IDs when I use query() function for multiple reference field type as stated in the documentation but I am not getting it, is it how this API behaves or I have lost my mind?
Before writing this post, I have already read more than 10 posts about this topic and here is what I understand -
include() function doesn't work with multiple reference field and totally ignores the field from the result but I don't need the full objects, I only need the Array of IDs
queryReference() returns referenced objects - so you need to iterate over your whole collection to get references which sounds pretty expensive.
Thanks in advance for any help.