mutharasu archunan
12/19/2025, 10:00 AMmulti_search, when using q="*", reference joins used in filter_by are not returned in the response even if explicitly requested via include_fields (e.g. *, $Ref_collection(*)).
The same query works in single search, and also works in multi_search when a non-wildcard or search query keyword is used.
Is join hydration intentionally skipped for wildcard queries in multi_search, or is there a way to force it / should this be documented? @Jason BoscoFanis Tharropoulos
12/19/2025, 12:50 PMmutharasu archunan
12/19/2025, 1:09 PMjobs (primary) and job_interactions (referenced). The jobs collection has a reference field pointing to job_interactions.
I am filtering jobs using a reference join: $job_interactions(id: *). In single search (/collections/jobs/documents/search), when I use q="*" and include_fields="*, $job_interactions(*)", the job_interactions object is returned correctly.
However, when I run the same logic in multi_search, the job_interactions object is not returned, even though the filter works and documents are returned. This happens with both q="*" and q=" ", even when the reference is explicitly requested via include_fields.
Is reference join hydration intentionally skipped in multi_search, or is there a supported way to force returning the joined objects?mutharasu archunan
12/19/2025, 1:09 PMjob_interactions as a referenced collection and is queried via $job_interactions(id: *) in filter_by
\mutharasu archunan
12/19/2025, 1:11 PMFanis Tharropoulos
12/19/2025, 1:14 PMmutharasu archunan
12/20/2025, 4:22 AMmutharasu archunan
12/20/2025, 11:14 AMmutharasu archunan
12/20/2025, 11:15 AMFanis Tharropoulos
12/22/2025, 11:29 AMmutharasu archunan
12/22/2025, 11:30 AMmutharasu archunan
12/22/2025, 11:30 AMFanis Tharropoulos
12/22/2025, 11:30 AMself-hostedWithout a reproducible example, it's hard for us to write an example ourselves. Could you provide us a bash script that reproduces the issue?