#community-help

Querying and Joining Across Collections

TLDR Dan asked about querying/joining across collections and limits for filter_by. Kishore Nallan clarified it's not possible to join collections and no upper limit exists for filter_by, but advised using the POST multi_search endpoint.

Powered by Struct AI

1

4
13mo
Solved
Join the chat
Sep 06, 2022 (13 months ago)
Dan
Photo of md5-f8f7b04dda4a09dec991cdc07f4d9c64
Dan
11:25 AM
Is it possible to query / join across collections?
11:26
Dan
11:26 AM
and - somewhat related - is there an upper limit for passing discrete values to filter by?
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
11:28 AM
No way to join collections, but there's an open feature request for that.

No upper limit for filter_by. Just make sure you are using the POST multi_search end-point because the GET search end-point limits length of query string to 2K characters.

1

Dan
Photo of md5-f8f7b04dda4a09dec991cdc07f4d9c64
Dan
11:28 AM
understood, thank you