Can't search an item name through items_page_by_column_values query

[apsimos (Zeitnot)]

Hi,

I want to search my board by item names using items_page_by_column_values Grapql query. When I run the following query it returns empty result even though the item is on the board as active.

  items_page_by_column_values(board_id:12345678, columns:[{column_id: "name", column_values: ["Task"]}]){
    items{
      id
    }
  }

Here is my board view:

As you see there are items including “Task” keyword but the api does not mange to find them.

How can I retrieve my items searching by the item name leveraging the API?

Thanks.

[basdebruin]

hi @apsimos

As far as I know the matches needs to be exact. What happens when your search for “Task 1”? Will that find your item?

[apsimos (Zeitnot)]

Hi @basdebruin,

Thanks for your reply. You are correct. It does exact match. But this is weird since I would like to filter my items with partial search.

Is there a way to do it, should I download all items and doing the search manually?

Best,

[basdebruin]

I would use this query to get all items that contains “Task” in their name

query {
        boards (ids: [12345678]) {
          items_page (limit:100, query_params: {rules: [{column_id: "name", compare_value: ["Task"], operator: contains_text}]}) {
            cursor
            items {
              id
              name
            }
          }
        }
      }

[apsimos (Zeitnot)]

Hi @basdebruin ,

That is working like a charm. Thank you very much.

Best

[Matias.Monday (Matias)]

Thank you @basdebruin for the help here!