Emmanuel Katto : Searching Items by Partial String in Query: Need Help

Hello Everyone,

I’m Emmanuel Katto, trying to perform a search query that allows me to find items where the name contains a specific string (e.g., “name contains abc”) rather than an exact match (“name equals abc”).

I’ve been using the following query:

query {
items_by_column_values (board_id: 162164, column_id: “name”, column_value: “abc”) {
id
name
column_values {
id
title
value
}
}
}

However, this only works for exact matches. Is there a way to modify this query to use a contains/like operator for partial string matching?

Any suggestions or insights would be greatly appreciated!

Thanks in advance!
Regards
Emmanuel Katto

Something like:

{
  boards(ids: 123456789) {
    items_page(
      limit: 50
      query_params: {rules: {column_id: "text", compare_value: "search value", operator: contains_text}}
    ) {
      cursor
      items {
        id
        name
      }
    }
  }
}
1 Like