I am using this table in JIRA oracle database, (wwjira.OS_CURRENTSTEP) to get the number of tickets in a certain date (for a specific status).
Example: 10 open tickets on 30-oct-2017.
my problem is : how to know the mapping between status_id and step_id for a certain workflow from the database?
for the time being , i know that workflow 1 has this mapping
Status Step Id
=== ======
Open 1
In Progress 3
Closed 6
but this i could know by experience from opening JIRA tickets themselves and checking from db. but i could not find out what is the Step_id for other statuses in the workflow (like Review , Resolved, Dev test,.....).
do we have a database table that can give me this mapping ?
Thanks