Saxon Jensen
02/26/2026, 7:51 AM{
"name": "people",
"enable_nested_fields": true,
"fields": [
{
"name": "name",
"type": "string",
"facet": false,
"optional": false
},
{
"name": "locations.isPrimary",
"type": "bool[]",
"facet": false,
"optional": true
},
{
"name": "locations.profileId",
"optional": true,
"type": "string[]",
"reference": "profiles.id",
"async_reference": true
},
}
And a profiles collection:
{"name": "profiles", "fields": [{"name": "tags", "type": "string[]"}]
I would like to write a query to fetch people with a primary location profile that is active. Something like this:
filter_by: locations.{isPrimary:=true && $profiles(tags:=ACTIVE)}
This query doesn't seem to work (it just hangs). Is using a join on an object array like this possible?Fanis Tharropoulos
02/26/2026, 9:23 AMSaxon Jensen
02/26/2026, 2:07 PMFanis Tharropoulos
03/05/2026, 11:32 AMSaxon Jensen
03/11/2026, 6:14 AMFanis Tharropoulos
03/16/2026, 2:31 PM