JQL difference between UpdateDate and Createdate

[Steve Harrison]

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 

[Suvradip Paul]

Hi @Steve Harrison ,

Thanks for posting ad welcome to the community.

I think you need Scriptrunner dateCompare - https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html.

Please check and let know your feedback.

[Steve Harrison]

Thanks I have installed scriptrunner and applied the trail license but it fails to enable. Telling me to refer to the logs but I don't know where the logs are generated

[Suvradip Paul]

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.

[Steve Harrison]

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.

[Steve Harrison]

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