Search by item name support in new "items_page_by_column_values" function

monday Apps & Developers
,
1

Hi there,
A question for what is a supported search parameter in the new “items_page_by_column_values” function

I am currently trying to replicate a functionality I had in 2023-07 API:

  items_by_column_values(
    board_id: BOARD_ID
    column_id: "name"
    column_value: "SERIAL NUMBER"
  ) {
    id
    name
    column_values {
      title
      text
    }
  }

With this query I could find get all the columns for a given an item name (serial number) on a board. Additionally the complexity value was 5000, so it returned fairly quickly. It also gave the text values for mirror columns I had on that board which linked to other serialized items which I needed.

However, when I try to do this same thing with the new “items_page_by_column_values” function I tried:

{
  items_page_by_column_values(
    limit: 1
    board_id: BOARD_ID
    columns: [{column_id: "name", column_values: ["SERIAL NUMBER"]}]
  ) {
    items {
      id
      name
    }
  }

And got a “Column of type “Name” is not yet supported for this query” error. And when I tried “text” instead of “name” I got a “no columns found error”

Am I messing up the syntax or is the functionality im looking for not going to work any more? Do I instead need to start querying the entire items page and then filter down to my specific item by a “compare_value” rule? That is considerably slower than my 2023-07 query and the complexity has been around 15000 to get the same information

1 Like
2

Hey @Adam.B – good catch!

I’ll take this with the team to see if we can support it. Will follow up on this thread with a solution next week.

We’re aiming for the new query to completely replace the old one, so we want to support this – just a question of if the new mondayDB infrastructure will allow it!

Thanks a lot for raising this with us.

EDIT: for those who are curious, here’s how to achieve this with the items_page object!

query {
  boards (ids:123456) {
    items_page (query_params: {rules: [{compare_value: "SERIAL NUMBER", column_id: "name", operator: any_of}]}) {
      items {
        id
        name
      }
    }
  }
}
2 Likes