Hello everyone. I am wondering if the following is...
# community-help
s
Hello everyone. I am wondering if the following is possible: I have a collection of people like so:
Copy code
{
  "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?
f
Hey Saxon, Could you share a reproducible example for this like the one here so we can debug?
s
Hey Fanis, Here's a reproduction. Hopefully the usage of podman instead of docker isn't a problem.
f
Hey Saxon, We're looking into this. There isn't a way currently to do what you're describing, so the request hangs because of this. We've been discussing on how to address this and will update you when we have a resolution.
s
Thank you so much! I look forward to hearing back 🙂
f
Hey Saxon, forgot to update you, but we got a change merged for v31.0. I'll ping you when we have an RC build with it!
❤️ 1