#community-help

Querying One-to-Many Relationships in Collections

TLDR Aizem asks how to query one collection item to multiple items in another collection. Kishore Nallan confirms the requested feature is under development.

Powered by Struct AI
Mar 21, 2023 (9 months ago)
Aizem
Photo of md5-1d0769df2be5255ba0752ce6553f8a28
Aizem
03:15 AM
Hi Everyone!
How can we query one collection item to multiple items from another collection? basically one too many relationships between the two collections
Example: I have a categories collection called 'test' and 'product' collection the product collection has 25 product that has a field of categories with the data of 'test' we want to able to query the categories collection with the product collection that has categories field with data of 'test'
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
03:20 AM
This is like a join in SQL world right? We're working on this feature but not available yet.