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

Join the chat

Sep 04, 2023 (3 weeks ago)

Photo of md5-b599fe398728a1867404c6c8ef6e98de

Ayush

08:48 AM

Hei there , is there a way to an SQL like JOINs during multi search ?

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

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

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

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 ?

Typesense

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

Indexed 2764 threads (79% resolved)

Join Our Community Manage subscription

Similar Threads

Limiting Returned Array Size and Using Joins in Document Search

James asked how to limit the returned array size in a document search. Jason suggested breaking the document into multiple records. After discussing join options and providing his collections data, James decided to duplicate the parent information in each child. Harpreet confirmed this approach.

Implementing OR Query in Typesense for Multiple-Word Search

Md.Riad was seeking assistance on implementing an OR query in Typesense for multiple word search. Jason clarified that Typesense already provides this feature by default and suggested to adjust the `drop_tokens_threshold` to obtain more varied results.

Understanding Search Result Object Fields

David had queries regarding various search object fields, such as `out_of`, `found` and `found_docs`. Kishore Nallan provided explanations for each field.