{"id":9851,"date":"2015-10-19T06:58:00","date_gmt":"2015-10-19T06:58:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2015\/10\/19\/new-fields-bring-kanban-goodness-to-queries-and-more\/"},"modified":"2022-08-02T01:13:22","modified_gmt":"2022-08-02T09:13:22","slug":"new-fields-bring-kanban-goodness-to-queries-and-more","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/new-fields-bring-kanban-goodness-to-queries-and-more\/","title":{"rendered":"New fields bring Kanban goodness to queries, and more"},"content":{"rendered":"

\n In VSO, the Kanban board is your control room. Like traditional switchboards and status indicators, the board empowers teams with mission critical information: which work items are in progress, where the bottlenecks are, who the work is assigned to, and so on. There\u2019s a certain calm to knowing all of this… and we get it. As consumers of our own product, we demand a data-centric experience too. Here\u2019s what we did to turn the dial.\n<\/p>\n

On September 18th<\/sup>, we announced the creation of three new system fields:<\/p>\n

    \n
  1. Board Column: current Kanban board column<\/li>\n
  2. Board Column Done: False (Doing) or True (Done) when work items are in a split column<\/li>\n
  3. Board Lane: current Kanban board swimlane<\/li>\n<\/ol>\n

    These fields capture valuable data from the board and light up various work item experiences across VSO.<\/p>\n

    \"board\"<\/p>\n

    Where can I use these fields?<\/h3>\n

    \u00a0<\/p>\n

    Queries<\/h5>\n

    This one came to us directly from our UserVoice community \u2013 the ask was for the ability to report on Kanban from the query editor. Now, you may add any or all of these fields to the query editor<\/a> for better results on board metrics. Board fields are also available in column options, so viewing a list of data quickly is a breeze. If Excel is your tool of choice, you can export as usual; board fields are available in Excel as read-only text.<\/p>\n

    \"queries1\"<\/p>\n

    Charts<\/h5>\n

    Here we\u2019ve configured a chart<\/a> with the new \u201cGroup by\u201d option \u201cBoard Column,\u201d which gave us a pie chart of our work items color coded for customized columns. On the Kanban team, we pin our chart to the team dashboard for a simple health check of our work items.<\/p>\n

    \"charts\"<\/p>\n

    Alerts<\/h5>\n

    In agile teams, things move fast. We update our work items, complete code reviews, resolve bugs, and make great features. In order to keep momentum, we want real-time updates and that\u2019s why we use VSO Alerts<\/a>. By adding a board field to the filter, you can set an alert like \u201cnotify me when a specific story has been picked up and is now under development\u201d. Alerts can be set for a single user, specific team members, or the entire team.<\/p>\n

    \"alerts\"<\/p>\n

    As you can see, Kanban fields add a ton of value to how teams view data and manage their work. We want to hear how your teams are using Kanban fields. Leave us a comment below, or reach out to us on Twitter with #vsonline<\/span><\/strong> to let us know what you think!<\/p>\n","protected":false},"excerpt":{"rendered":"

    In VSO, the Kanban board is your control room. Like traditional switchboards and status indicators, the board empowers teams with mission critical information: which work items are in progress, where the bottlenecks are, who the work is assigned to, and so on. There\u2019s a certain calm to knowing all of this… and we get it. […]<\/p>\n","protected":false},"author":180,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[227,253,1],"tags":[],"class_list":["post-9851","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-agile","category-azure-devops-server","category-devops"],"acf":[],"blog_post_summary":"

    In VSO, the Kanban board is your control room. Like traditional switchboards and status indicators, the board empowers teams with mission critical information: which work items are in progress, where the bottlenecks are, who the work is assigned to, and so on. There\u2019s a certain calm to knowing all of this… and we get it. […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/9851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/180"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=9851"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/9851\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=9851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=9851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=9851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}