Filtering for text matches

The below query stopped working for text fields. It was working before the latest API version upgrade. I am using the API version: 2023-10

query {
boards (ids:xxxxxxx) {
items_page (
query_params: {
rules: [
{
column_id: “custom_text_field”,
compare_value: [“541”],
operator: contains_text
},
]
},

) {
  items {
    name
    id
    group {
      id
    }
    column_values {
      id
      text
      type
    }
  }
}

}
}

Hello there @priyabhadra,

You can find the displayed value of each column in a different way, depending on the column type as explained here.

For example, if you wanted to get the display value of a connect boards column, you would use a query like this one:

{
  boards(ids: 1234567890) {
    items_page(limit: 10) {
      items {
        name
        id
        group {
          id
        }
        column_values {
          id
          type
          ... on BoardRelationValue {
            display_value
          }
        }
      }
    }
  }
}

I hope that helps!

Cheers,
Matias

Thank you for the response. I tried but it is not working. I am trying to filter data from a custom text column called defect but it is not working. I am using the below query. The same query is working for other columns like person but not for text fields.

It was working before, it stopped working post the API version upgrade.

query {
boards (ids:12345678) {
items_page (
query_params: {
rules: [
{
column_id: “defect8”,
compare_value: [“541”],
operator: contains_text
},
]
},

) {
  items {
    name
    id
    group {
      id
    }
    column_values {
      id
      text
      type
    }
  }
}

}
}

Hello again @priyabhadra,

That is odd. I just tested this exact same query with information from one of my boards and it works well.

Would you be able to please submit this form so our team can take a look into this?

Please include your query with the board ID, your account ID (or name) and your user’s ID or email address.

Looking forward to hearing from you via the form!

Cheers,
Matias

1 Like