Error in items_page_by_column_values

[binaya]

I wanted to perform a search using the Items page by column values query using the “2023-10” API version. I want to get the sub-item details—that has an Item-ID column type—by using the value in that field.

Using items_page_by_column_values with column_id and column_values gave me an error: Error Code: UnsupportedItemsByColumnValueQuery

Error Message: Column of type pulse-id is not yet supported for this query

Error Data: {“column_id”:“item_id”,“column_type”:“pulse-id”}

Looking at the docs I found that searching for items_page_by_column_values, item-ID column is not supported. Are there any ways that I can get the column details by performing a search with the “item-Id” column type?

Given is a screenshot of the column where I want to find the details of the sub-item.

[codyfrisch (Cody)]

Can you elaborate on why you need to search the item ID column? What does it gain vs. just querying items for the item IDs?

You have to have the IDs so why not just do:

{
  items(ids: [123123, 542543, 1234425, 5245234]) {
    id
    column_values {
      id
      type
      text
      value
    }
  }
}

[binaya]

Suppose we have another board (say, Board-B) that has a number column where we can use the value from the Item ID column (say, Board-A—as in the above screenshot). In this number column of Board-B, we change the value of the number column to be one of the Item-ID from the above screenshot (say, 181928717) to get the details of all the columns of a particular sub-item of Board-A and copy certain column values in Board-B from Board-A.

Hopefully this makes sense

[codyfrisch (Cody)]

No it doesn’t make sense.

You should just use the value from board B in the query I showed (as one of the IDs). No reason to search board A for the item ID using items_page_by_column_value.

The item ID column is just a view on the board to see the item’s ID - its not a different ID that you need to search that column for. Just get the item using the ID that you’re putting in board B.

{
  items(ids: [#####]) {
    id
    column_values {
      id
      type
      text
      value
    }
  }
}

[binaya]

Wow, Thanks @codyfrisch. This was straight-forward.

[Matias.Monday (Matias)]

Thank you @codyfrisch !!