Get all items per user of all boards

I can’t find the GraphQL query to get get all items per per user of all board combined.

I want to get a list of all item for user X, it could be that these items are on more than one board.
It is necessary for us to create a dashboard with all items per user for a day and one for the next day and so on.

Hey Jeffrey,

Welcome to the Developer’s Community! :+1:

You can use the “get_items_by_column_value” operation to get all the items assigned to a particular user. This only can query the items on a specific board (not all items on your entire account).

That said, we’ve been talking internally about adding a Search API in the future, to get items matching specific conditions on the account-level. I will pass your vote for this kind of functionality over to the team!

Cheers,
Dipro

5 Likes

Hello @dipro please add my vote too!

3 Likes

Will do! :raised_hands:

@dipro any update on this feature? Just joined the Monday community for the same question as above :smile:

Hey Dion!

At the moment this isn’t possible, but thanks for the upvote here! I’ve passed the feedback along to the team :slight_smile:

Welcome to the community btw!

Please send entire query for ‘get_items_by_column_value’

Hi @abhi,

That query varies a bit depending on which column you are trying to get information from. For example, on the email column it would be something like this:

{
  items_by_column_values(board_id: XXX, column_id: "email", column_value: "test@test.com") {
    id
  }
}

Would you be able to start a new thread and share some details on what you’re trying to achieve?

-Daniel

Hi @dipro ,

Following up on this request? I just started using the Monday API - I’m trying to do simple search to find a particular item which has column title == “Phone Number” and column value == “1234567890”… The problem is that we have 12 boards, so it seems like I either have to…

  • Make 12 requests to items_by_column_values, one per board (not ideal)

or

  • Query all items on every board, and all colums, then loop through everything (not ideal)

Am I missing something? I assume this is a common pattern… just looking for the same kind of functionality we get through the Monday UI…

Thanks