This project has moved. For the latest updates, please go here.

Kanban Board Report error

Mar 6, 2012 at 5:37 PM

Hello,

I was playing around with the Kanban Process Template for Dev11, and I found an error in the Kanban Board Report. I've changed the Title of the 'Review' process step a few times. The Global List Synchronizer did his work correctly, but if you look at the Kanban Board Report, you see that it show all previous names also as columns, like:

http://www.alexandervanwynsberghe.be/vsalm/error.PNG

I did a little research in the RDL, and found this query:

http://www.alexandervanwynsberghe.be/vsalm/query.PNG

It shows the 'Review' process step 3 times, instead of the last title I have defined. After analyzing the query I found the mistake that in the last 'where' clause, there is a comparison on:

a.System_Title=DimWorkItem.System_Title

Because every title is (mostly) different, this will not work. You have to check this by using the System_ID:

 a.System_Id=DimWorkItem.System_Id

Resulting in

http://www.alexandervanwynsberghe.be/vsalm/solution.png

and

http://www.alexandervanwynsberghe.be/vsalm/solution2.png

and

http://www.alexandervanwynsberghe.be/vsalm/solution3.png

Issue solved :-)

PS: if you need any help with feature development on this project? I definitely want to help you guys :-) Really exited about this project!

Alexander

Developer
Mar 6, 2012 at 7:11 PM
Hi Alexander,

Thanks for reporting this - and I really appreciate your analysis of the problem.

I've copied Willy-Peter for guidance on how you can contribute to the project.

Thanks again,
Adam

On 6 Mar 2012, at 18:37, "vanwynsberghea" <notifications@codeplex.com> wrote:

From: vanwynsberghea

Hello,

I was playing around with the Kanban Process Template for Dev11, and I found an error in the Kanban Board Report. I've changed the Title of the 'Review' process step a few times. The Global List Synchronizer did his work correctly, but if you look at the Kanban Board Report, you see that it show all previous names also as columns, like:

http://www.alexandervanwynsberghe.be/vsalm/error.PNG

I did a little research in the RDL, and found this query:

http://www.alexandervanwynsberghe.be/vsalm/query.PNG

It shows the 'Review' process step 3 times, instead of the last title I have defined. After analyzing the query I found the mistake that in the last 'where' clause, there is a comparison on:

a.System_Title=DimWorkItem.System_Title

Because every title is (mostly) different, this will not work. You have to check this by using the System_ID:

 a.System_Id=DimWorkItem.System_Id

Resulting in

http://www.alexandervanwynsberghe.be/vsalm/solution.png

and

http://www.alexandervanwynsberghe.be/vsalm/solution2.png

and

http://www.alexandervanwynsberghe.be/vsalm/solution3.png

Issue solved :-)

PS: if you need any help with feature development on this project? I definitely want to help you guys :-) Really exited about this project!

Alexander

Coordinator
Mar 6, 2012 at 7:18 PM

Alexander, please ping me on http://blogs.msdn.com/b/willy-peter_schaub/contact.aspx to discuss your contribution question.

Willy-Peter Schaub

From: adamgilmore [email removed]
Sent: Tuesday, March 06, 2012 12:11 PM
To: Willy-Peter Schaub
Subject: Re: Kanban Board Report error [vsarkanbanguide:347538]

From: adamgilmore

Hi Alexander,

Thanks for reporting this - and I really appreciate your analysis of the problem.

I've copied Willy-Peter for guidance on how you can contribute to the project.

Thanks again,

Adam

On 6 Mar 2012, at 18:37, "vanwynsberghea" <notifications@codeplex.com> wrote:

From: vanwynsberghea

Hello,

I was playing around with the Kanban Process Template for Dev11, and I found an error in the Kanban Board Report. I've changed the Title of the 'Review' process step a few times. The Global List Synchronizer did his work correctly, but if you look at the Kanban Board Report, you see that it show all previous names also as columns, like:

http://www.alexandervanwynsberghe.be/vsalm/error.PNG

I did a little research in the RDL, and found this query:

http://www.alexandervanwynsberghe.be/vsalm/query.PNG

It shows the 'Review' process step 3 times, instead of the last title I have defined. After analyzing the query I found the mistake that in the last 'where' clause, there is a comparison on:

a.System_Title=DimWorkItem.System_Title

Because every title is (mostly) different, this will not work. You have to check this by using the System_ID:

 a.System_Id=DimWorkItem.System_Id

Resulting in

http://www.alexandervanwynsberghe.be/vsalm/solution.png

and

http://www.alexandervanwynsberghe.be/vsalm/solution2.png

and

http://www.alexandervanwynsberghe.be/vsalm/solution3.png

Issue solved :-)

PS: if you need any help with feature development on this project? I definitely want to help you guys :-) Really exited about this project!

Alexander

Mar 7, 2012 at 6:43 PM

Hi Willy-Peter,

I pinged you using the contact form :-)

Thanks!

Alexander