#community-help

SQL-like JOINs in Multi-search: Query Solution

TLDR Ayush asked if SQL-like JOINs can be implemented during a multi-search. Jason noted a separate JOINs feature is in beta but the conversation didn't resolve to a definite solution.

Powered by Struct AI
Sep 04, 2023 (3 weeks ago)
Ayush
Photo of md5-b599fe398728a1867404c6c8ef6e98de
Ayush
08:48 AM
Hei there , is there a way to an SQL like JOINs during multi search ?
Jason
Photo of md5-8813087cccc512313602b6d9f9ece19f
Jason
06:17 PM
Not during multi-search, but there is a separate JOINs feature that is in beta: https://gist.github.com/kishorenc/037314619c3104970ae703b25aff2f51
Ayush
Photo of md5-b599fe398728a1867404c6c8ef6e98de
Ayush
06:36 PM
Oh that's cool , I'm not sure if it would fit with our use case.

Could you help me figure out a better solution for this?

To frame it better we have two collections videos and transcripts , transcripts have many to one relation with videos ( with a videoId param ).

We're trying to perform one single search to get transcript docs and the linked video docs to those transcript docs .

Could that be done in one multi search ?
Jason
Photo of md5-8813087cccc512313602b6d9f9ece19f
Jason
07:33 PM
Could you describe the UI you're looking to build? That would help understand the use-case better
07:34
Jason
07:34 PM
For eg, do you want to show videos and transcripts in a single ranked list? Or are you looking to show videos in one section of the search results, and transcript results in another section?
Sep 05, 2023 (3 weeks ago)
Ayush
Photo of md5-b599fe398728a1867404c6c8ef6e98de
Ayush
05:18 AM
We're trying to built a QnA system , so these documents would be searched and then formatted as for a prompt

"""VIDEO

Title : {{video_name}}
Description: {{video_description}}
More_info:{{video_tags}}
Relevant Plots : {{ Transcript Plots }}
""""
05:59
Ayush
05:59 AM
Btw any timeline when would this Beta JOIN be out ?