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.
May 09, 2023 (7 months ago)
Saurabh
09:48 AMhow 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
10:20 AMSaurabh
10:27 AMKishore Nallan
10:29 AM
Typesense
Indexed 3015 threads (79% resolved)
Similar Threads
Querying One-to-Many Relationships in Collections
Aizem asks how to query one collection item to multiple items in another collection. Kishore Nallan confirms the requested feature is under development.
Query on Filtering Documents between Two Collections
Daniel asked about filtering documents across two collections. Kishore Nallan clarified that feature is currently not available but directed the user to a specific open feature request.
Querying and Joining Across Collections
Dan asked about querying/joining across collections and limits for filter_by. Kishore Nallan clarified it's not possible to join collections and no upper limit exists for filter_by, but advised using the POST multi_search endpoint.