Skip to main content

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: o{column_id: "name", column_values: v"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

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

      }

    }

  }

}

Reply


Terms & ConditionsCookie settings