Get specific row by item_id column with items_page_by_column_values

monday Apps & Developers
, ,
1

I changed the request according to the changes of your new version ( 2023-10 )

I previously searched by “item_id” column and now I get an error

This is one-to-one function of a certain row, what is the best practice way to find that row now?

I was able to create a copy of the column and convert it to text and thus find, but I feel that this is not the best solution

Thanks in advance

2

Hi there @LiorTabachnik,

What query are you using and what error are you seeing?

3

f"“”
{{
items_page_by_column_values(
board_id: {CONTACTS_BORAD_ID},
columns: {{
column_id: “item_id”,
column_values: [“{column_value}”]
}}
) {{
items {{
id
name
column_values {{
id
value
}}
}}
}}
}}
“”"

the error is something with “pulse-id” that cant be filtered

4

This query doesn’t need items page by column values, or anything special

{
  items (ids: ["123123123123"]) {
   id
   name
   column_values {
     id
     value
   }
 }
}

The item ID column just shows you the intrinsic item ID of the item in the GUI. Its the same ID you use to directly access the item in the query above.

1 Like
5

So simple and beauty :slight_smile:

Thanks

6

Thank you @anon29275264 for the help here!!!