#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.

Powered by Struct AI
Dec 14, 2022 (12 months ago)
Kian
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?
Kishore Nallan
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
Photo of md5-9dbff87b399a957ba84b7d995b4dd9de
Kian
11:49 AM
exactly, Thank you Kishore