Hi Mike, do you have a tutorial on how to determine the number of bugs logged while a User Story is in the resolved state?
@HARSHDIMRI4 ай бұрын
Thank you very helpful, I have a question. I want click on Chart and view what all tickets behind that chart for broder view. How can link my queries to chart?
@mazharkhatri7795 ай бұрын
Hi there, thanks for making outstanding videos, can you please make video about bug severity and priority in Azure Devops
@ramsign36 ай бұрын
Hi, I am trying to write a query which will return all tickets with recent comments on tickets
@nasreenkayesh7 ай бұрын
Is there a way I can create and chart in dashboard for the same data of project progress
@MirKoGS7 ай бұрын
Hello! Great video! How can i make mu querie to catch only the range of user stories from the last 7 daye, not older? and then to present it as a chart?
@calogerobrutto87438 ай бұрын
1. It's not checklist, its favorite management why do you rename ? 2. no you cannot "favorite" different sprint of a project but only the sprint main page. This even visible in your video.
@4spenc1awz8 ай бұрын
Very helpful. Thank you
@karentechnologies39909 ай бұрын
Thank you for this helpful tutorial
@commonman47989 ай бұрын
I want to add new Filed Item into the Filed Dropdown
@ivanu839 ай бұрын
Hi @malpert1000, thanks for the video. Is it possible to do more complex queries like Condition 1 AND Condition 2 AND (Condition 3 OR Condition 4) ?? Thank you!
@ivanu839 ай бұрын
It is not very friendly, but I found the way to do it: Condition 1 AND Condition 2 AND Condition 3 OR Condition 1 AND Condition 2 AND Condition 4 Is there an easier way to do it?
@kingwrightdev10 ай бұрын
Is there any way to do this in the backlog view?
@adessorecords10 ай бұрын
Thanks for this, really helpful and helped me get what I needed!
@19ang9010 ай бұрын
Could you show how to extract an entire Epic with select Features?
@amyalbers525 Жыл бұрын
Is there a way to query on a tag by using a wildcard?
@teekaiwi4125 Жыл бұрын
OMG! I spent hours trying to figure out how to set this up and was able to do it in a matter of minutes with your help! Thank you so much!
@inform2dil Жыл бұрын
If I email the report it doesn't show up the % completion by work items. how can we ensure the % completion of work items is also visible if we email to any one say mgmt.
@kemiakindele9320 Жыл бұрын
Hello Mike, thanks for the videos...how do I please query user stories and story points assigned per sprint?
@malpert1000 Жыл бұрын
Hi. Here is the simplest query. Each one is a query line . *Work item type = user story * state = any * iteration path =@current
@malpert1000 Жыл бұрын
Then click on the wrench 🔧 icon Column Options, then select story points on one of the drop downs. Once selected, a column should appear that shows story points
@ManishSatav Жыл бұрын
Excellent tutorial for absolute beginners!!
@WillSada Жыл бұрын
Thanks for video Mike. Do you know how to do a query update to replace a date value with another?
@malpert1000 Жыл бұрын
Hi Will, to my knowledge, that doesn't exist with the UI functionality of AzDo. But it doesn't mean that there is not some backend way to do it. 😉
@aarondavis1167 Жыл бұрын
Can’t see the top right of what you’re clicking.
@malpert1000 Жыл бұрын
To the right of the search field there is an icon that looks like a checklist. Select that and move through the tabs that pop up. The right most tab should be favorites
@RaviShankarJsr Жыл бұрын
This is cool, thanks for sharing the information.
@emmanuelajijo3332 Жыл бұрын
I can’t believe I’m seeing this 2yrs late, but for a first Video this is amazing
@muhammadn82 Жыл бұрын
Thanks man. It did not give me exactly what i want but it gave me the idea and i done the ticket list by month, week etc. I appreciate your effort.
@MarcoAurelioAndrade-zv1ls Жыл бұрын
Hello! I have a board where I linked task between them, like predecessor. I create a query that shows the relation between them, but I'd like to include the parent in the query, because now it is showing only the tasks. Do you know how to do it ?
@cocofortin2 жыл бұрын
Hi there! I wanted to know if there is any option where I can use an existing query in a new query, For ex: I created one generic query, I want to use that in other queries.
@malpert10002 жыл бұрын
Hi. Yes there is. I bring up the query that I need to start with, then I make modifications for the new query. Run the query to make sure it works, finally click the 'Save as' button that is right next to the "Save" button. Now rename the new query. I do suggest to first locate the "save as' button first before you try it. Also it does not hurt to practice this technique on some basic queries that are easy to recreate first. Hope this helps 🙏
@cocofortin2 жыл бұрын
@@malpert1000Apologies, Let me explain it right. For ex: I created a query that fetches all work items for Sprint 45. The Query will be: Field* Operator Value Iteration Path = Sprint 45 Let's give this a name "Sprint_Query" Now, Let's say I am creating 20 completely new queries from scratch, and I want to use above already created query in these 20 new queries (basically import query parameters by searching existing query name). Reason of doing is below. Now, If I want to see results of Sprint 44, I won't have to go to those 20 queries to change the parameter, rather I will only change my query "Sprint_Query" and it will reflect in all other queries automatically. Hope this explains.
@malpert10002 жыл бұрын
@@cocofortin I understand. As far as I know, the query ui doesn't offer the ability to make a call to a different query and use that first half of the query in a new query. That would be cool if it did. I know in the test area you have a concept of creating shared steps, but I have not seen this in the query area of devops
@saunaknandi1814 Жыл бұрын
@@malpert1000 For which company you are working?
@azuredevopsbyrajeshkumarm2 жыл бұрын
for deep insights in azure devops kzbin.info/door/IHRqMTGXSdVw0CCYyFH1Hg
@azuredevopsbyrajeshkumarm2 жыл бұрын
for deep insights in azure devops kzbin.info/door/IHRqMTGXSdVw0CCYyFH1Hg
@gustavoboese2 жыл бұрын
Hey Virtual PM I have a problem here as I can't get all tasks is under an Epic in my actual Iteration Path Is it possible as I have Epics -> Releases -> Features -> User Stories -> Tasks?
@malpert10002 жыл бұрын
Hi Gustavo. You can manually add any work item as a child to a parent but this goes against the way MS developed Azure to work. So it will not track correctly in the sprint view. Is releases a work item you created manually?
@iDoTechOK2 жыл бұрын
Great work. Thanks! Wondering how we affect the percentage of each task then once we add the columns, should there be task percentage in each task now?
@malpert10002 жыл бұрын
Thanks Ben. As far as I know out of the box, the only thing that could effect it would be 'Effort Hours' in the task. But I don't think it works like that. I think the system simply calculates on new,active and closed to come up with the percentages
@malpert10002 жыл бұрын
You can always add additional fields to any work item, but that field will always be a manual process to keep those fields up to date. We have added a lot of custom fields and they are more a headache then a solution.
@KPatel9122 жыл бұрын
How do we see work item = all, state = active and from specific iteration and specific team area?
@shyamdangi22 жыл бұрын
Mike : How to add definition of done at a single place so as to reflect it to all the PBI or tickets in my project? I don't want to add DoD to each and every PBI or ticket one by one
@malpert10002 жыл бұрын
Great question. Setting definitions of done can be done on the kanban board View. Once you're on the kanban board View click the gear icon and then go to settings and columns. In that view you can map the different states to the different columns in the kanban board
@shyamdangi22 жыл бұрын
Very helpful. I searched a lot how to set it on different sites but couldn't find. Your video is very descriptive and helpful. Thanks for that 🙂
@lindajohnson69832 жыл бұрын
Hi Mich, do you do mentoring?
@malpert10002 жыл бұрын
Not at this time.. but I am always available to help or answer questions
@lindajohnson69832 жыл бұрын
Okay cool. Thanks . Do you know how I can query when things move from one state to another like testing, bugs or any work item type on azure Devops?
@lindajohnson69832 жыл бұрын
I’m looking for a mentor that I can ask questions one in a while. I have experience in what I’m doing . Sometimes I just need confirmation with someone who’s a pro at it .
@lindajohnson69832 жыл бұрын
Please I really need your help. Thanks
@malpert10002 жыл бұрын
@@lindajohnson6983 There are a couple ways to do this. 1) Go to Boards> Work Items>Select 'Recently updated' from the drop down> Select 'Open in Queries'. This will give you a start to a query that you can re-name a modify. Under the 'Editor' tab you will see what the query is querying.. in this case it is on Field 'ID' in @recentProject Activity. You can continue to modify the query as you need. :)
@kichuhere12 жыл бұрын
Is there a way to save this or do i have to create a rollup each time i want to display this? Also any way i can reflect this in a dashboard. I tried out different options but i get a message stating that hierarchial queries are not supported (when i try to add this to a widget)
@malpert10002 жыл бұрын
Hi Krishna.. No I have unfortunately not found a way to display the percentages in a widget on the dashboard. One thing you can try is to hide the none needed columns in the backlog view and take a screenshot of it. Or you can use the 'Delivery Plans' option under boards. 1.) Create a project that will show Epics or Features or Both 2.) click on 'settings' 3.) click on 'Fields' 4.) Check 'show child rollup data'. This will show the percentage complete under each Epic and or Feature. You will need to still take a screenshot, but you will also have a timeline as well. hope this helps 😁
@kichuhere12 жыл бұрын
@@malpert1000 Thanks for responding back quickly. I appreciate you putting together this video. I will give this a shot. Happy New Year!!!
@adamlimmer96832 жыл бұрын
Have you managed to build your Risk Register in ADO and how do you find the risk rating functionality and also reporting?
@malpert10002 жыл бұрын
Hi Adam.. short answer is yes. Azure Devops comes with out of the box project process templets that allow for issue tracking. Agile(ISSUE), Scrum(IMPEDIMENT), CMMI(RISKS) all have an item that could be used like a risk, but CMMI template actually has the risk item. If your team is already using a template that has one of these items, for another purpose, you and your team could agree on using specific tags to ID risks in that particular work item category. I always suggest to try to use out of the box functionality before you start to add or make custom changes. 😁 Link to MS Template documentation: docs.microsoft.com/en-us/azure/devops/boards/work-items/guidance/choose-process?view=azure-devops&tabs=basic-process
@malpert10002 жыл бұрын
Now that being said... not to go right ahead and start modify Azure DevOps with special work items.. there is that ability. To do this you will need to do the following: 1.)have access level of 'visual studio enterprise subscription' 2) Be in the 'Project Collection Administrators' or higher for the organization 3) At the root level of all the projects click 'Organization settings' 4.) click 'Process' 5.) select a process, click the (...) and select 'Create inherited Process' Note: this new sub-process will now allow you to add and remove new work items. 6.) Click and open the new sub-process you created 7.) you should be dropped into a 'Work item types' screen. 8.) click 'New work item type' and build your new work item. Note 1: to use this new work item, all your projects will need to use this new sub-process as a template, so that you will see the new work item. Note 2: Work with all of your management to identify the new fields for the work item before you start creating . Note 3: Put the risk on the Feature or ''User Story' level of the backlog. Note 4: Come up with a naming convention for your new fields, something that is easy and makes sense. You need to do this because you will later need to be able to query on the fields to build your risk register. I hope this helps 😁
@jennymendez3942 жыл бұрын
@@malpert1000 Hola cómo hago para que un work item nuevo se pueda identificar en este menú desplegable? de backlog donde se puede ver la estructura de Epic, feature, PBI y lograr ver ese nuevo work item?
@malpert10002 жыл бұрын
Hi @@jennymendez394. Can you ask or respond in English. Sorry my Spanish is rusty
@jennymendez3942 жыл бұрын
@@malpert1000 jajaj my English is bad but I going to trying explain. I created a new WI but in the backlog I don't found the new WI, I only see epics, features and PBI. Sorry if I wrong in my gramatic
@anikkhan50142 жыл бұрын
Suppose it's 20th Dec, 2021. But I need some data between Dec 5 to Dec 10. Then what would it be? How do I find that?
@malpert10002 жыл бұрын
Hi Anik. I would first use the iteration path to query on. Iteration path equal or greater than Dec 1 ,next line, iteration path less than Dec 15 for example. If you don't use iterations.. then use the completion date to query on using greater than and less than operators. Hope this helps 🙏
@sameerkhan-ff8xg2 жыл бұрын
Hi, How u added the percentage completion column in dasboard.
@malpert10002 жыл бұрын
Hi Sameer. There are a couple of ways. One way is to add a custom field in the work item type that has percentages. This percentage field will need be updated manually. Or another option is to add a 'Add a rollup column' to the backlog. In this option the system will give you percentage complete that is calculated by the system. Steps to turn this on are Go to Backlog> select Column Options> select 'Add a rollup column'> select 'From quick list'> then Progress by all Work Items> click OK. This will then give you a column called Progress by all Work Items and that column will have system generate percentages. I would always suggest to go with what Azure offers and not customizing Azure with special fields. :) I hope this helps
@sameerkhan-ff8xg2 жыл бұрын
@@malpert1000 thank you so much . One more qs i have if you could help .I am using power bi to show all the test case data .i have one oodata query( query1 )which gives me test case id test plan id test suite id Another odata query i have( query2)which gives me testrun id. I donot find any common filed to link query 1 with query 2 .Can u suggest me how can i do that . I need to show if i have test case1 which was run 10 times so for that particular test case 10 different run ids are created i wanted to show this in my power bi report that test case 1 ran 10 times .
@malpert10002 жыл бұрын
Hi @@sameerkhan-ff8xg unfortunately I do not have experience on Power BI integration. This page talks about fields that you can query on. see Other Fields. I hope this might help. dev.azure.com/LamarCISDInfoServ/LamarIS/_queries/query-edit/abc6cec2-253d-4249-95fd-22e50bec352b/
@malpert10002 жыл бұрын
@@sameerkhan-ff8xg here is another site that might help. docs.microsoft.com/en-us/rest/api/azure/devops/test/Results/Get?view=azure-devops-rest-5.0&viewFallbackFrom=vsts-rest-5.0
@sameerkhan-ff8xg2 жыл бұрын
@@malpert1000 thank u so very much ..
@VishwaVlogskk3 жыл бұрын
Mike, you video image reside at upside corner :) you should change the position of your self video image.
@aarondavis1167 Жыл бұрын
Right!!!! 😂 smh I’m like what is behind there 👀.
@VishwaVlogskk3 жыл бұрын
Great Work.
@zainsheart3 жыл бұрын
when I add the new query, it doesn't appear the "charts" item next to the "editor". Can you tell why it doesn't appear?
@poonammetkar51813 жыл бұрын
Could you please a make video on how to add a columns in query for parent and child. Ex. I want a report with columns Title(parent : user story) User Story ID Title(child : task) Child ID Need to show columns with parent & related child task
@wolfjacobi11413 жыл бұрын
Thanks for this video, great introduction. I am trying to make a tree query on a specific level in the middle. In this example that would be to query User Stories and see the parent Features and child Tasks but nothing else, e. g. the parent Epic or Tasks would be directly assigned on other hierarchy levels. How does this work? Thanks in advance for your help.
@narangaman63 жыл бұрын
Hey Mate Here's my problem statement, just wondering if you could help : I want to be able to see which sprints a story has been part of (after being dragged from one sprint to the other because of not being achieved/closed) . Since Azure devops doesn't let me have a view of the sprint report and retains this bit of history in the work item unlike Jira, the only way I could think of was querying by history and searching for stories which have a "changed iteration path" in the history and then use it to prepare a dashboard. But I am unable to do that. Can you help? Cheers !
@malpert10002 жыл бұрын
Hey Aman.. I currently I do not have an idea on how to show this cause I have not tried it. I will look into this and hopefully I will have an answer if you are interested
@malpert10002 жыл бұрын
Aman .. I was looking and it looks like Azure only support these field names when using the 'History' field: Changed By, Change Date, Closed Date, Created Date, History, Resolved Date, Rev, Start Change Date, Test Suite Audit, Watermark. Non of these will give us the Changes Iteration Path that is in the History. I think this is because we are suppose to close all user stories at the end of a sprint or start new ones that are related. See docs.microsoft.com/en-us/azure/devops/boards/queries/history-and-auditing?view=azure-devops&tabs=browser
@5530alex2 жыл бұрын
@@malpert1000 I've had the same problem to track stories that are not complete in a prior sprint. I tag them with the sprint # they have been worked. By doing this I know how many sprints it actually takes to complete a user story and (or) bug without having to dig through the history of iteration path changes. A simple query by the tag can tell me what sprints the user story or bug has been worked on.
@luchogz82 жыл бұрын
@@malpert1000 Hey all. And if you create a tag for each sprint and then tag the US with the tags corresponding to the sprint where it has been? Would that be an option?
@amandamilko64193 жыл бұрын
Can I filter a query to only display parented user stories, omitting any not linked to an epic?
@anoopma37333 жыл бұрын
I am trying to extract Test case execution details of every Static Test Suite but unable to would you be able to help me out
@XtineMark3 жыл бұрын
Hi there - in my day job (not Xtine Mark singer songwriter persona I use on KZbin) I'm a project manager at a customer application development firm. Question - In Azure Dev Ops, how do I set up a query to track bugs opened over time (regardless of state)? Essentially, I want a count of the # of bugs opened each day, mapped over time. Looking to see how we're doing on the "bug bell curve" for a project I'm managing. Many thanks!
@XtineMark3 жыл бұрын
Best I can come up with is setting up shared query with Work Item Type = Bug, "state" = New. Although, I believe this will not show new bugs that went from new to and were changed to any other state in the same day (so it's masking a lot of bug open activity that really did happen).
@sxyval4u9 жыл бұрын
Thank you for this video. Was very helpful with my comparative methods course in social justice. Are two topics we are on are social media and social movements and to see how they tie together and the different forms and structure of it was insightful. Thank you again for sharing!