How to calculate the duration the card in the status

[Leandro Pimentel Cerqueira]

I need to make a JQL, to change de color of card, when the estimate time is more than the duration the task (card) in the Kaban column.

I used the cloud JIRA.

[Julia Denys [SaaSJet]]

Hi @Leandro Pimentel Cerqueira 

With SLA Time and Report you can create a report that will show you when the estimated time is more than the duration of the task. Also, it'll be marked in different colors and you can see this data right after opening the application.

You can set SLA timer value and statuses when the countdown should be turned on/off according to your configurations. In addition, you can generate SLA reports by using filters and later export this data as XLSX or CSV file.

Hope, this add-on will help you to handle SLAs in Jira Cloud.

[Earl McCutcheon]

Hi Leonardo,

There is no an ability within Jira natively to compare the values in two fields EXE: field1 > field2" this is because the JQL language does not have the ability to do a nested query which we are tracking as a feature request here:

• https://jira.atlassian.com/browse/JRASERVER-21936
• https://jira.atlassian.com/browse/JRACLOUD-21936

Something that can be done to get a time based status change JQL query you could use something like the following with the CHANGED operator with BEFORE or AFTER optional predicates, this will give you a list of all issues where the status was modified today that can be added to the card color filters

status changed before endofday() and status changed AFTER startofday()

and then for a gradient to show previous days use a modifier like endofday(-1d)...(-2d)...etc for the gradient scale.

However, the method above still cannot compare two fields together, and looking at the requirements here something I believe would work for you is to look at ScriptRunner which has a scripted JQL function which could help as long as your custom fields are date, date/time or numeric fields, using the expression feature in the tool as described at the following link and this function can compare two fields:

• https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_expression

You can then use the Expressions with another script-runner function of scripted fields, Described here, to create a custom field to record the time the issue entered the defined status so you can compare the estimate to the status time via the expression.

Regards,
Earl