You could get this from LookBack API, but it may not be straight forward enough and would requite Custom HTML Code. What is the need to know the date of the change? Are you interested in color changes aside from just the change to Green? If not, why not just use the Ready flag? An item in the initial ScheduleState (Defined for example), with the Ready Flag set would indicate that the work has met the DoR and is Ready to be included in an Iteration. If the Flag is not set, then, well, it isn't Ready.
Those fields can easily be filtered on in a Custom List (or any applicable page really), and saved views can be created to show Ready/not Ready.
DisplayColor is also filterable, so if you need to track different colors you can certainly so that. It's just that the date of the change isn't available.
An option, if knowing when the change occurs is important (for User Stories, won't work for Portfolio Items) would be to set a Notification Rule with the Condition Color changed-to Green. The My Notifications app should show the date of the change. If you wanted, email notifications could be enabled in your user profile and you'd know exactly when the change occurred, but you may get a lot of notifications, and they would be individual, not a consolidated report. Adding other conditions could perhaps reduct the number of notifications.
Original Message:
Sent: Aug 30, 2023 01:04 PM
From: Vanessa White
Subject: Tracking Color Changes
Is there a way to pull a report that shows when a user story or feature changes color? We use the display color and turn it green to show when a story or feature has been refined and meets the definition of ready. I'm trying to determine the date of when each item has been turned green. I saw a post from years ago that says to use the Custom HTML app but I would need the coding in order to do so.
Thank you!