ratsstack
Reputation: 1021
Query for status change on particular day
How do I write a query which will allow me to me view all the work items changed to a particular state on a particular day?
Example, we have a status field which developers change from "In Progress" to "Retest Ready".
I'd like a query which will return me all the work items which changed from "In Progress" to "Retest Ready" on a given day.
Upvotes: 2
Views: 56
Answers (0)
Related Questions
- Query when daily data changes in SQL [in Redshift]
- To get Status Changing Data
- SQL query to find the changes in status throughout the day
- Oracle Query to track the changes for table with context particular day
- SQL Show Dates Per Status
- Obtaining database information depending on what day it is SQLite Android
- Compare database time with current time
- What's the proper SQL query to find a 'status change' before given date?
- SQL Server query for changing status according to date
- fetch records based on today's date