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.
Powered by Struct AI
3
12mo
Dec 14, 2022 (12 months ago)
Kian
Kian
10:48 AMHi 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
Is there a way for me to search for title of those
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?Kishore Nallan
Kishore Nallan
11:14 AMThis 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
Kian
11:49 AMexactly, Thank you Kishore
Typesense
Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI
Indexed 3011 threads (79% resolved)
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.
5
34mo
Solved
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.
5
14mo
Solved
Multi-Collection Relevance Query in Typesense
Alexander inquired about querying three collections at once in Typesense. Kishore Nallan suggested federated search for the issue.
3
31mo
Solved