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
In Progress 3
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 ?
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :). In the spirit of this month's august-challenge, we're sourcing stories of Jira Service Desk activation fro...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG