这是indexloc提供的服务,不要输入任何密码
Skip to content

Query handling and filtering of array fields - (where: {name: {_any: "admin"}}) #2155

@bendog

Description

@bendog

The Scenario.
We have names stored in varchar[] arrays in the table, this is to help with multi-language deployments and was designed some time ago, hence not jsonb.

group_table {
  id
  name
}

will return

[
  {
    "id": 1,
    "name": [
      "admin",
      "admin_but_other_langage"
    ]
  },
  ...etc...
]

The Desired behaviour.
it would be useful to be able to define which array entry you wish to return

group_table {
  id
  name[0]
}

it would also be very helpful to be able to filter on these

group_table (where: {name: {_any: "admin"}} {
  id
  name
}

or

group_table (where: {name[0]: {_eq: "admin"}} {
  id
  name
}

thanks for all the great work.

Metadata

Metadata

Assignees

Labels

a/api/graphqlc/serverRelated to serverc/v3-engineV3 Metadata and Enginek/enhancementNew feature or improve an existing features/triagedThis has been reviewed by Hasurav3

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions