#community-help

Querying Documents from Two Collections in Typesense

TLDR Kian asked if it's possible to bind search results from two collections in Typesense. Kishore Nallan explained that this feature is currently not available but is being considered.

12mo

Join the chat

Dec 14, 2022 (12 months ago)

Photo of md5-9dbff87b399a957ba84b7d995b4dd9de

Kian

10:48 AM

Hi All,

Is there a way to bind the search result/documents of one collection in Typesense to other documents in a different collection? example can be --->

Let’s say I have two collections one for PO-boxes and the other for packages --> every package exist in one box and package documents contain the id of the po-box document which they belonged to.

Is there a way for me to search for title of those packages and then at the same time in return get the associates po-box documents back with one single query?

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

11:14 AM

This is like a join in the SQL world. We do have an open feature request for this but don't have a way to do it at the moment.

Kian

11:49 AM

exactly, Thank you Kishore

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3011 threads (79% resolved)

Join Our Community

Similar Threads

Using Typesense to Search Specific Document IDs

Tshepo inquired about performing specific document ID searches in Typesense. Jason advised using the `filter_by=id:=[1,2,3,etc]` function or directly querying Typesense.

34mo

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.

14mo

Multi-Collection Relevance Query in Typesense

Alexander inquired about querying three collections at once in Typesense. Kishore Nallan suggested federated search for the issue.

31mo