JQL difference between UpdateDate and Createdate

Question

I am trying to add a query to my dashboard that shows the time taken between creating a JIRA ticket and Updating (closing) it. The SQL brain in me wants to just use a minus function but in JQL I just can't work this out. Any ideas?

For example:

CreatedDate = 10/Oct/21

UpdatedDate = 15/Oct/21

Days Elapsed (or whatever I call it) = 5 days

thanks

steve

Steve Harrison_oi409v · Answer

Ok a change of tact because I really don't see why I should not be able to do this in JIRA without ScriptRunner.

How about adding a custom field that returns the difference in days between two dates. Sorry I not familiar with JIRA but surely I can achieve this by creating a custom column and rule. I just can't fin where to create a rule.

Rule should be UpdatedDate - CreatedDate  = x days based on the JIRA status.

Any thoughts?

thanks

Steve Harrison_oi409v · Answer

This hasn't helped.  I have added ScriptRunner to my JIRA instance but it looks like I need to enable to. When click it then just takes a long time trying to do something then returns an error and tells me to look at the logs. Which logs? I have no idea where they are? This is extremely frustrating.

Suvradip Paul · Answer

I Think you are referring for Audit logs, please check this  - https://docs.adaptavist.com/sr4jc/latest/best-practices/audit-logs.

Please check this for Execution History - https://docs.adaptavist.com/sr4jc/latest/best-practices/execution-history.

Please check this for most recent logs for script executions - https://docs.adaptavist.com/sr4jc/latest/best-practices/script-logs.

Let me know if that helps.