Skip to main content

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

  • January 17, 2025
  • 1 reply
  • 10 views
emmanuelkatto23

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

1 reply

basdebruin
  • basdebruin
  • Community Expert
  • January 17, 2025

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
      }
    }
  }
}
    Terms & ConditionsCookie settingsAccessibility statement