Pulling all items in View

monday Apps & Developers
, ,
1

I have a board with several views.
I have one view that has filters to show the items that I want.
I’m trying to figure out how to make the query so that it will return all the items in that view.

The following query will return the names of all the view, and it will return all the items on the board, though the people who set up the board aren’t programmers, and apparently don’t know how to name fields, and so I’m honestly not sure how to pull the exact fields that I want yet.

{ 
  query:  boards(ids: 111111111111) { 
    name 
    views {  
      id 
      name
    }
    items_page { 
      items { 
        name  
        column_values { 
          id 
          text 
        } 
      } 
    }
  } 
}
2

You have to also go and get the id & name for each column and then match that up.

Update the query to get columns too:

{ 
  query:  boards(ids: 111111111111) { 
    name 
    columns {
      id
      title
    }
    views {  
      id 
      name
type
    }
    items_page { 
      items { 
        name  
        column_values { 
          id 
          text 
        } 
      } 
    }
  } 
}

then match the id in the columns with the id in column_values.

It’s slightly annoying, but really the only way to get something human readable.

Aside 1: The views object is a little misleading as it does not contain all the views. It seems like an undocumented feature, so I can’t really explain whats going on there. I’ve also added type to the views :wink:

Aside 2: You should probably just think of the column id as a randomly assigned string rather than something with meaning.