Skip to main content

Using items_by_column_values to get items by people column

  • May 30, 2020
  • 4 replies
  • 3992 views
K

Hi there,

I am trying to get items by timeline column, however using the query below I do not get anything back. I have tried multiple things including with the column value I got back from the items (ids[xxxxx]) query. What am I missing?

query {
  items_by_column_values (
    board_id: 499053030, 
    column_id: "timeline", 
    column_value: "{\\"to\\":\\"2020-11-06\\",\\"from\\":\\"2020-11-02\\"}"
  ) {
    id
    name
  }
}
This topic has been closed for replies.

4 replies

K
  • kennethharder
  • Author
  • New Participant
  • June 11, 2020

I got a reply from support saying that the items_by_column_values does not support the people column yet.

basdebruin
  • basdebruin
  • Community Expert
  • June 11, 2020

Hi @kennethharder, Kenneth

Hmmm… don’t know if that answer from support is really true. Before monday apps were released I build automation in Integromat and one of them is certainly setting a people column 🙂 . See screenshot as the output from a step in Integromat where I set the people column (owners).

image

At this moment I did not do yet change a people column from an app or API, but when Integromat can do this, we should be able to do the same through the API. Hope this helps you with the next step.

dipro
Forum|alt.badge.img
  • dipro
  • Leader
  • June 11, 2020

Hey Bas and Kenneth!

I believe Kenneth’s original post was asking if you can filter items on a board based on the value in a People column, which is not possible at the moment.

However, you can definitely update a people column 🙂 Here’s the relevant documentation: Updating a people column

🔮 Dipro

    H
    Forum|alt.badge.img
    • Helen
    • monday.com Team Member
    • July 27, 2021

    To update, we have limited support for filtering by Person column values using items_by_column_values(). Check out our new API documentation here.

    Terms & ConditionsCookie settingsAccessibility statement