Colors of the start/endpoints are mixed up... the color that is rendered first, is used in all arrows

Hey Edward,

it would be great, if you could introduce WIP limits similar to ones offered on the original boards. Maybe it would even be possible to have seperate WIP limits for each swimlane.
And now the killer feature: Maybe the WIP limit could be enforced in a way that if the wip limit of a column is reached, it is not allowed to drag an item to it.

Best Bernhard

Is it possible to add something (like drag/drop) to add dependecies (and remove them)

Hi,

Currently with a two-level query all the parent level tasks are showing as collapsible:

It would be good to have such tasks just on the board in the correct column based on their states like:

Thanks!

At the moment the columns are solely based on the field System.State.
In some cases it could be handy that you can use an other field.

It should be based on a text picklistfield (for safety reasons, do not use other system fields) like custom fields.
The check on a state change should be skipped.

Note: Not all workitem types will have this (custom) field... so this has to be checked first.

It would be nice if we could see Team or Area on the work item card - we mostly use queries with option "query across projects" so this is very important for us.

When enabled the 'AS OF' date that is selected will be added to the query statement, so the actual state of that moment is displayed within the board (be aware: this will not work well together with all of the macros like @today).

Cannot save board view as bookmark in the browser.

What's related to that issue - we are also not able to share link to the board page.

For example, following link:
https://XYZ/_queries/realdolmen.EdTro-AzureDevOps-Extensions-QueryBasedBoards-Public.EdTro-AzureDevOps-Extensions-QueryBasedBoards.BoardTab/8a280e4a-c09c-41b6-bfee-b89e9d2f083a/
will open "Results" tab in the query instead of "Show as board" view.

Like as mentioned in the question of Daniel Stevenson:

e.g. Task State = New, Bug State = Active
Show both in a Column called New

There is one thing, I stumbled over while setting up things with qbb. I know it's not directly related to qbb, it0s rather a thing how queries work in Azure DevOps. But maybe you know a better way round this thats why I dre to post this question here too.

My use case is:

• I have different projects set up
• epics and features are maintained in a global planning project
• stories life in the product projects
• the final setup will be quite huge that’s why this separation has been introduced we will have to ensure the system is maintainable (permissions etc.)
• association from the planning project to others works with area paths which are set up in the planning project and represent the structure of all projects
• some features need support from other projects so I setup one parent-child-linked story in the other project
• I want now a single hop query which shows me all features and the child stories
• the rules should be:
  • show all the features I have associated to my project plus all the stories connected to them, this includes stories which are in other projects and teams
  • show also all my stories, including those which I’m doing for other features in other projects

For more visual people an example diagram below. In queries which are saved as shared queries in all 3 projects there should be this result:

• Project "Product 1" sees both product features and its stories as one is the own feature and the other contains a story which is linked to the own project / team
• Project "Product 2" has the same vice versa
• The Project Platform sees also both of these product features as it has a story of each plus it has a third feature which is not in the queries of the products as it only contains Platform stuff

I want to see that because the dependencies are important and each project team should see, where they have dependencies to other products and where they have to deliver or are waiting for things.

(example of the query one below "give me all stories belonging to my features")

The only way I found so far is to have two separate queries which apply the two mentioned rules and combine them. A UNION (without duplicates, so no UNION ALL) would do the trick in one go. Here are my current two test queries.

/** give me all stories belonging to my features **/
SELECT
    [System.Id],
    [System.WorkItemType],
    [System.Title],
    [System.AssignedTo],
    [System.State],
    [System.Tags]
FROM workitemLinks
WHERE
    (
        [Source].[System.WorkItemType] = 'Feature'
        AND [Source].[System.AreaPath] UNDER 'PI-Planning\Plattform'
    )
    AND (
        [System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward'
    )
    AND (
        [Target].[System.WorkItemType] <> ''
    )
ORDER BY [System.Id]
MODE (MayContain)

/** give me all features belonging to my stories **/

SELECT
    [System.Id],
    [System.WorkItemType],
    [System.Title],
    [System.AssignedTo],
    [System.State],
    [System.Tags]
FROM workitemLinks
WHERE
    (
        [Source].[System.WorkItemType] = 'Feature'
    )
    AND (
        [System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward'
    )
    AND (
        [Target].[System.WorkItemType] <> ''
        AND [Target].[System.AreaPath] = 'Plattform'
    )
ORDER BY [System.Id]
MODE (MustContain)

As I know that this doesn't belong to qbb natively, I also opened a feature request at Microsoft but until someone replies there, we get old and grey ...

WIQL: allow UNION of queries

Update: I also posted a stackoverflow question, maybe I get some infos there: https://stackoverflow.com/questions/66203920/get-all-my-features-stories-from-all-and-all-my-stories-connected-to-other-fea

I hope this is useful also for others using Azure DevOps and Query Based Boards.

Hello!
So the situation is that while we work with shared querys on our Azure DevOps everything works fine and there are no problems. But if one creates a private query and selects to show it as board, then the query based board shows for others only the "Whoops... Something went wrong while loading the configuration page.". For the one who created the private query it still works fine.
If then another person creates also a private query and selects to show it as board, then the query based board extension doesn't work for anyone anymore.
Could this bes somehow fixed?

We have a project that is just for doing an extensive platform review. As such, we have:

• renamed a couple of columns (which show up with the State instead of Column name)
• Made slight changes to the order of the columns. (but shows up in original order.)

It would be really nice to be able to get Show as Board to display like our board.

The board columns are actually based on de System.State field, which is not how it works in Azure DevOps. Board columns are very useful to follow de developpement progress (for example : Analysis, Approval pending, Development, Revision, QA, etc.)

I know every project has to have the same configuration of Board columns for it to work. But would it be possible to have a look at that feature ? It would really help our dev teams follow the development progress of many projects at once.

Thank you !

We are working on premises on a Azure DevOps Server 2020 (Version Dev18.M170.6) with the xml process template. I installed the version 0.20326.3 of Query Based Boards yesterday. Unfortunately I always get the
"No Data - Please review the query. Please note that only 'flat' and 'one-hop' queries are implemented."
error message, even for very simple queries.

An example Query I used:
Wiql: select [System.Id], [System.Title] from WorkItems where [System.TeamProject] = @project and [System.WorkItemType] = 'Feature' and [System.State] <> 'Done' and [System.State] <> 'Removed'

Is this a known issue or can you give me any hint how I can investigate what the root cause might be?

Aspects that might have influence:
We defined quite some custom fields and also some custom states.
I am currently working over a VPN connection. But also colleagues working directly on their machines have that issue.

We have in our company added few custom states to the work items, but it looks like that appropriate columns for this states are not displayed even if there are some work items which should be displayed.

Also we have query where we display work items according to the rules:

and work items from the second group (based on the changed date and changed by fields) are also not displayed on the board.

See the question:

Hi,
The "Parent has children" feature was certainly useful for me when filtering tasks. I have customized the configuration to always display the filtering options. I don't understand if it is possible to let the option "Yes" be default though. If so, can you provide me with an example?
Kind regards
Janni
By Janni Kajbrink

It would be great if we could configure extension to show tags on the work item cards :)

Hi,
can you share source code of the extension? We would be able to fork it then and make some additional improvements/bug fixes.

We would really appreciate this.

Hi,

While it is true it is possible to use the fields to configure the parent it will only display as non-clickable item number.

I would like this to work as a link with the proper item name like on the built-in board:

Thanks!

Hi!
I think it's better to discuss here, rather then at VS Marketplace.
As I published as VSM I tried to add custom field from another extension (our own development):

{ "fields":[ { "name":"Logrocon.PerformerIT", "title":"Developer" } ] }

it has same type as AssignedTo. And it crashed the board:

But when I add string field from same extension:

{ "fields":[ { "name":"Logrocon.CustomerContact.1C", "title":"Contact" } ] }

everything goes normal:

Hi @edtro,
Thanks for implementing this excellent extension. I've got swimlanes and columns working, but the Doing/Done column doesn't work for me. If I use the api to query one of our Work Items I can see the Done Column is set as:

"System.BoardColumn":"In Progress","System.BoardColumnDone":true

So I implemented the column as:

{
"name":"In Progress",
"title":"In Progress/Active",
"width": 2,
"doingDone":{
"field":"System.BoardColumnDone",
"doingTitle":"Working on it...",
"doingDefaultValue":false,
"doneTitle":"Finished!",
"doneValue":true
}
},

Which does show the new sub-columns but doesn't show any of the cards in the done column (just in doing). Is there something I'm doing wrong?

Many thanks
Clive

Hi,

Currently if you filter a board with a two level query to a certain user it will display all the first level categories no matter the user does not have it assigned:

It would be good to show only the relevant categories. It would only make sense to display them if the user is having subtasks in the Story / Feature. This would enable intra-story collaboration by seeing only the relevant work item categories and subtasks on the board when filtering.

This is somewhat connected to my other ticket:
#33

Thanks!

Some of the columns have an arrow that allow them to be collapsed.
I thought it was the "isBacklog" parameter in the column definition to set that, but it's something else (or it is and it isn't properly working).
So: it's some hidden configuration, it's a bug or it's something else?

Please could you implement dynamic sizing of column widths to allow more than 1 card to show horizontally in columns when the users window size allows this?

This would be really useful for us when we do a Kanban style standup (we have lots of cards in each team column)

Current situation
I'm using swimmlane definitions like shown in the example at the bottom. This works quite nice. Workitems which have these area paths set can be moved through the swimlanes. It's clear that it is not possible to change the area path via drag n drop, which is also a good behavior to not accidently change the area path.

I have area paths with deeper areas for example Platform\Team1 Platform\Team2 etc. On the board I need to create a swimmlane for every exact area path. Otherwise the Items are not shown or not movable on the board.

Desired behavor
On the overall board I only want to see a swimmlane Platform. It should contain workitems which are on any area path beneath that parent area path. I also want to move these items in the swimmlane. That the area path will never be changed on the workitem is a goos behavor and shpuld stay as it is.

Example

   "swimlanes":{
      "field":"System.AreaPath",
      "defaultValue":"Planning",
      "values":[
         {
            "value":"Planning",
            "title":"Planning"
         },
         {
            "value":"Platform",
            "title":"Platform"
         }
      ]
   },

I'm trying to import configuration for my queries, but the configuration does not get imported. For the global config on the other hand, I can see the imported config.
Also, when I choose "Show all queries" in the extensions configuration tab, the queries do not appear.

Hello,

it would by very useful, if it would be possilbe to setup a Query based board custom tab on the Sprints hub (similarly to the Backlog/Board hub). Thank you.

this page refers to a team project settings hub. I googled for this and did not find anything for Azure DevOps. Where would one locate this hub? Is there a different name for it?

First of all thank you for this awesome plugin, easily one of the best plugins available for Azure DevOps.

I have a question, or rather feature request: is there a way of having the sprints / iterations as columns (iteration path either top-level only = iteration or lowest level = sprint)?

Let me know if I'm unclear here or if I can help implementing this.

PS: the new Plans V2.0 of Azure DevOps which is in preview has a similar feature but is way less flexible and nice looking as the query based boards do. Thus, I would always prefer to use qbb.

in some situations while using the legacy XML process definitions, the drag/drop does not work in Edge... while the same is working without any problems in Chrome.

The inheritance process definitions work without any problems in Edge.

As reported on the marketpace, by Janni Kajbrink:

Hi, I really like the feature to filter the task board for different values. But when I have selected a filter and then open for example a User Story and then closes it, the selected filter is cleared. To reproduce

1. Select a user in the Assigned To filter
2. Open a user story
3. Close the user story
4. The filter is cleared and there is no longer any user selected in the "Assigned to" filter Is this expected?

Hi,

We installed this (amazing, by the way) plug in a few days ago. I'm seeing strange issue where some users are seeing the above button but others are not. They are both in the same organization and project. Identical permissions and licensing.

I've asked those that cannot see this button to restart/refresh/clear cache. Both Chrome and Edge.

Any guidance very much appreciated :)

Shai

Not sure if I got this wrong. I have this json config for my board as shown at the bottom. My question: why am I not able to drag n drop in one of the doing / done columns? In the picture below I try to drop teh item in teh analysis doing column and this didn't work.

{
   "settings":{
      "showFilter":true,
      "showArrows":true,
      "showProject":true,
      "showStoryPoints":false,
      "showTags":true
   },
   
   "swimlanes":{
      "field":"System.AreaPath",
      "defaultValue":"Planning",
      "values":[
         {
            "value":"Planning",
            "title":"Planning"
         },
         {
            "value":"Planning\\Platform",
            "title":"Platform"
         },
         {
            "value":"Planning\\Produkt1",
            "title":"Produkt1"
         },
         {
            "value":"Planning\\Produkt2",
            "title":"Produkt2"
         },
         {
            "value":"Planning\\Produkt3",
            "title":"Produkt3"
         }
      ]
   },
      "columns":[
      {
         "name":"Backlog",
         "title":"Backlog",
         "isBacklog":true
      },
      {
         "name":"Analysis",
         "title":"Analysis",
         "doingDone":{
            "field":"System.BoardColumnDone",
            "doingTitle":"Doing",
            "doingDefaultValue":false,
            "doneTitle":"Ready",
            "doneValue":true
         }
      },
      {
         "name":"Implementation",
         "title":"Implementation",
         "doingDone":{
            "field":"System.BoardColumnDone",
            "doingTitle":"Doing",
            "doingDefaultValue":false,
            "doneTitle":"Ready",
            "doneValue":true
         }
      },
      {
         "name":"Verification",
         "title":"Verification",
         "doingDone":{
            "field":"System.BoardColumnDone",
            "doingTitle":"Doing",
            "doingDefaultValue":false,
            "doneTitle":"Ready",
            "doneValue":true
         }
      },
      {
         "name":"Done",
         "title":"Done",
         "isBacklog":true
      }
   ]
}

I have a similar issue with task boards, json example and screen below. I cannot move the work item plus teh done (I call it ready) column ist not shown.

{
   "settings":{
      "showFilter":true,
      "showArrows":true,
      "showProject":true,
      "showStoryPoints":false,
      "showTags":true
   },
   
   "columns":[
      {
         "name":"Backlog",
         "title":"Backlog",
         "isBacklog":true
      },
      {
         "name":"Analysis",
         "title":"Analysis",
         "doingDone":{
            "field":"System.BoardColumnDone",
            "doingTitle":"Doing",
            "doingDefaultValue":false,
            "doneTitle":"Ready",
            "doneValue":true
         }
      },
      {
         "name":"Implementation",
         "title":"Implementation",
         "doingDone":{
            "field":"System.BoardColumnDone",
            "doingTitle":"Doing",
            "doingDefaultValue":false,
            "doneTitle":"Ready",
            "doneValue":true
         }
      },
      {
         "name":"Verification",
         "title":"Verification",
         "doingDone":{
            "field":"System.BoardColumnDone",
            "doingTitle":"Doing",
            "doingDefaultValue":false,
            "doneTitle":"Ready",
            "doneValue":true
         }
      },
      {
         "name":"Done",
         "title":"Done",
         "isBacklog":true
      }
   ]
}

With some zoom levels the "Arrow control" to collapse the most right column is overlaid by the options button. The Screenshot below is taken with a zoom level of 100%. I tested it with Edge 87.0.664.75 and Vivaldi 3.5.2115.87 (based on Chromium 87.0.4280.142).
When the filters are activated it is no problem, because the Options button is then shown on a separate row with the filters. Maybe it would be better to always show the options button on a separate row.

Quick tipp

If you are stumbeling over the same issue, see the workaround solution here: #47 (comment)

Original request

I've created a couple of shared queris in a project and none of them is showing up in the project settings to allow configuration. I guess there is something screwed up but I don't know exactly where to start. I've a couple of projects where I've done similar setups and it's working quite well.

Special in the affected project: it has been renamed.

Other inputs or hints: in the development console of the brwoser I get a 404 when I want to open the settings:

GET https://server/collection/_apis/ExtensionManagement/InstalledExtensions/realdolmen/EdTro-AzureDevOps-Extensions-QueryBasedBoards-Public/Data/Scopes/Default/Current/Collections/querybasedboards-import/Documents 404 (Not Found)

When I run a query and click the "show as board" button there is a super quick error message I'm not able to capture. In the developer console I see a bunch of errors:

ms.vss-web.platform-…jTC5yBclkr.min.js:1 POST https://server/collection/_apis/ExtensionManagement/InstalledEx…copes/Default/Current/Collections/querybasedboards-configuration/Documents 400 (Bad Request)

Could not create configuration for query: ee5fca6e-219e-4811-a071-4bedefa767da

GET https://server/collection/_apis/GraphProfile/MemberAvatars/win.Uy0xLTUtMjEtMzMwMDg0MjA5Mi04MTkxODE4MjUtMjEzMzgyNzUzOC0zMzg1MQ 401 (Unauthorized)

(I guess the last one is not relevant, only to be complete)

What I also can say: I can add the global config but it is not repected in the queries.

Please let me know how I can help to investigate further.

EDIT
Just found out a very important thing I guess: I had a collection backup restored as test environment before we renamed the affected project. And before we renamed the project the queries have worked propperly. So I assume that this is linked to renaming projects.

I really like this extension and its functionality of visualizing dependencies and searching across projects. Do you think it will be (maybe already is) a possibility to create a backlog from the query?

I would like to use "Add a rollup column" for a backlog based on the query created from items from multiple projects.

When the title contains long strings without spaces the wrapping of the text seems not to work properly for the board cards. As can be seen on the screenshots the text exceeds the boarders of the card.