#community-help

Connecting and Filtering Collections by Country

TLDR Saurabh wanted to connect two collections and filter them. Kishore Nallan mentioned that joins are not supported yet, suggesting two separate queries.

Powered by Struct AI
May 09, 2023 (7 months ago)
Saurabh
Photo of md5-57be9cd26696982f7dd2392eff28df99
Saurabh
09:48 AM
Hi Team,
how can we connect two collection's and write filters. ?
e.g: product: name, customer_id, date.
user: customer_id, country,
want to fetch products buyed by user..country wise..
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
10:20 AM
You mean like join?
Saurabh
Photo of md5-57be9cd26696982f7dd2392eff28df99
Saurabh
10:27 AM
yess
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
10:29 AM
We don't support joins yet but we are working on it. For now you will have to make 2 queries to 2 different collections.