Fetch items assigned to a user, also get items assigned multiple users that user is included

monday Apps & Developers Feature Requests - API and Apps Framework
1

Im trying to find a way to get all tasks associated to a user, that includes other tasks that contains other users. Heres my query, but i only get task that is only assigned to a user.

{
    items_by_column_values (board_id: 123456, column_id: "person", column_value: "John Doe") {
        id
        name
        column_values(ids: ["person"]){title id type text}

    }
}

This query only get items that is assigned only to user John Doe. I want to get all items where John Doe is included as person.

Like the result below:

{
  "data": {
    "items_by_column_values": [
      {
        "id": "12121",
        "name": "Setup Flutter",
        "column_values": [
          {
            "title": "Person",
            "id": "person",
            "type": "multiple-person",
            "text": "John Doe"
          }
        ]
      },
      {
        "id": "12121",
        "name": "Create Login Page SSO",
        "column_values": [
          {
            "title": "Person",
            "id": "person",
            "type": "multiple-person",
            "text": "[Heisenberg, John Doe]"
          }
        ]
      }
    ]
  },
  "account_id": 1234
}
2

hi @enrique.corpus4

Welcome to the community! See also: Items by column values

On that page it shows this limitation.

image
image915×704 72.4 KB

I guess the only solution is to get all items and in your code loop through all column values to get the items assigned to a person where the person is assigned together with other persons.

3

Thank you. Glad to know its limitation. Cheers