2 Comments
User's avatar
Iwo Hryniewicz's avatar

Hi Benji! Thanks for the article! I would be grateful for a more detailed description of the custom script approach. I currently used custom field and power automate to calculate work item age - inspired by Nick Brown's article on Medium.

Expand full comment
Benjamin Huser-Berta's avatar

Hi Iwo

I think Nick's approach is quite similar. Instead of Power Automate, I created a Python script (https://github.com/LetPeopleWork/AzureDevOpsFlowScripts/blob/main/CalculateWorkItemAge.py ) that you can run, and it will update the work item age (you can specify any field where you want it "stored"). As you want to run this every day, I've also shared a potential pipeline you could use in Azure DevOps Pipelines to trigger the script once per day (https://github.com/LetPeopleWork/AzureDevOpsFlowScripts/blob/main/AzurePipeline.yaml ).

The result is more or less the same as with Nick's Power Automate approach --> each item has a dedicated field where you can see the age of the item. Based on this you could create styling rules.

Does this help or were you interested in anything else/more specific? ;-)

Expand full comment