#community-help

Query on Filtering Documents between Two Collections

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

Powered by Struct AI
5
11mo
Solved
Join the chat
Oct 07, 2022 (11 months ago)
Daniel
Photo of md5-e2351af23a1bb70795da09fa3b369b10
Daniel
10:34 AM
hiyo! Is there a way to construct a search or filter for Documents in Collection 1, which meet certain conditions involving Collection 2?

I've attached a simple example to demonstrate what I mean.
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
12:42 PM
👋 We don't have a way to "join" collections that way.
Daniel
Photo of md5-e2351af23a1bb70795da09fa3b369b10
Daniel
01:09 PM
Ha, Join was the word I was looking for 😛, thanks Kishore Nallan. I just spotted that you let another person know there was an open feature request for joins. The closest I could find in Enhancements was Federated Search Then Aggregate Data. Is that the right one to add my vote to, or is there another somewhere I'm not seeing?
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
01:19 PM
This one is what we are using to track: https://github.com/typesense/typesense/issues/229
Daniel
Photo of md5-e2351af23a1bb70795da09fa3b369b10
Daniel
01:24 PM
udman ❤️