Skip to main content

Get specific row by item_id column with items_page_by_column_values

  • March 12, 2024
  • 5 replies
  • 326 views

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

5 replies

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • March 12, 2024

Hi there @LiorTabachnik,

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


  • Author
  • New Participant
  • March 12, 2024

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


  • Participating Frequently
  • March 12, 2024

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.


  • Author
  • New Participant
  • March 13, 2024

So simple and beauty 🙂

Thanks


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • March 13, 2024

Thank you @anon29275264 for the help here!!!