Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Advice on range of options for customizing Jira Status tracking with custom fields and JQL

Craig Storms March 20, 2018

I know this is a popular topic and there are MANY posts and plug-ins which support improved Jira Status tracking. My question is less about what plug-ins might be available and more about how to approach the customization work to truly define a highly customized Workflow with supporting Status tracking and JQL integration.

Like many other folks I'd like to capture time in each Status, or what may be more practical, time in a partial workflow for example:

Dev Time in "In Progress" + "Review Ready"

QA Time in "QA Ready" + QA In Progress"

I'm thinking about custom fields "Time in QA" and "Time in Dev" as well as related custom fields "Number of time in QA" and "Number of times in Dev" to help track when QA finds issues and sends work back to development. So each of these custom fields would increment based on transitions in the workflow. Total time would increment perhaps using a "Last Status Time" capture when Transitioning into Dev or QA, so that when the issue transitions out the total time spent can be calculated and added to the Time fields. 

I'd like to do this without plug-ins if possible. Of if plug-ins are the right choice, I'd like to be able to customize these fields and do queries and data mine these statistics using JQL. 

I'm happy to learn new development tools and do Jira dev work if that's the smart thing to do ... yes there are a lot of good plug-ins but I really want full control over how this works and how the custom fields can support JQL queries. 

Thanks for reading ... advice appreciated. So much info out there I'm mostly looking for general direction and how to best approach this problem. If I can solve this Jira will be a rock star of a tool very happy with everything except the status tracking ... which I know can be solved. 

1 answer

0 votes
Craig Storms March 22, 2018

No answers to my post but a dozen or so view so sharing my progress.

I am currently investigating ways to use the Status change Post-Function to set new custom fields. I found the following link helpful:

https://jsutil.atlassian.net/wiki/spaces/JSUTIL/pages/786628/JIRA+Suite+Utilities+Workflow+Post-Functions#JIRASuiteUtilitiesWorkflowPost-Functions-UpdateIssueCustomFieldPost-Function

Making some good progress and now have successfully captured the date-time at which key transitions are occurring in our workflow. Still not quite what I am looking for but getting closer. Created a new Question to clarify Date and Date-Time usage with the Post-Function:

https://community.atlassian.com/t5/Jira-questions/Can-the-Post-Function-assign-Date-or-Date-Time-offsets-using/qaq-p/756394#M245457

Suggest an answer

Log in or Sign up to answer