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.
Sep 04, 2023 (3 weeks ago)
Ayush
08:48 AMJason
06:17 PMAyush
06:36 PMCould 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 PMJason
07:34 PMSep 05, 2023 (3 weeks ago)
Ayush
05:18 AM"""VIDEO
Title : {{video_name}}
Description: {{video_description}}
More_info:{{video_tags}}
Relevant Plots : {{ Transcript Plots }}
""""
Ayush
05:59 AMTypesense
Indexed 2764 threads (79% resolved)
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.