There seems to be some difference about what is returned when doing a direct query on a collection and what is returned when using queryReferenced. For example:
There are two tables involved: Members and MemberDecals. These are my own collections, not to be confused with any Wix collections (like Events, Blog, etc.).
This shows the same item being retrieved via direct query from MemberDecals (using .eq for the decalNumber value) and then the results of using queryReferenced from Members to return an array of all the referenced items. Note that the _id, _owner, _createdDate, and _updatedDate are identical, so we know that both methods are returning the same item.
What is confusing is that the item returned using queryReferenced also brings back two additional fields: “member” and “memberId”. “memberId” is the main field of the Members collection, while “member” does not appear in either table. The value returned for “memberId” is the _id of the referring item, and the value for “member” is the main field value in the Members collection.
It seems inconsistent that retrieving the same item two different ways should have different results. Anyone have an explanation, or is this something Corvid team needs to address?