Resta de tiempos

[daniel tobon]

Buen día comunidad de JIRA, Solicito su apoyo ya que tengo 2 campos de fecha que se restan entre si mediante una automatización, y depositan este resultado en el campo de otro issue pero no puedo hacer ser que la resta solo sea entre días y horas laborales tienen alguna sugerencia ?  

[Bill Sheboy · Accepted solution]

Hi @daniel tobon  -- Welcome to the Atlassian Community!

For a question like this, please consider posting an image of your rule.  That may provide context for the community to offer suggestions.  Thanks!

From what I understand, you want to measure the difference between two date fields.  I am unclear if you want the result in days, hours, or days and hours.  Would you please clarify?

When performing a date difference in automation, the resulting units can be selected: https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/

However, please note that your fields could be date or date/time types, and so that may be impacting your results.

Best regards,

Bill

[daniel tobon]

Hola @Bill Sheboy , agrego imágenes y el tiempo debe ser en Días pero solo hábiles digamos hacer una excepción   sábado y domingo

[Bill Sheboy]

Thanks for that information.  I believe business days is one of the possible values for units with date diff:

{{issue.created.diff(issue.updated).businessDays}}

Have you tried that one?  If you did, were there any errors in the audit log?

[daniel tobon]

@Bill Sheboy  a un no lo pruebo de esa manera, yo acabo de ingresar a la instancia y persona que le daba mantenimiento a si lo dejo estoy buscando la manera de mejorarlo 

[daniel tobon]

@Bill Sheboy  muchas gracias por la ayuda logre obtener los valores necesarios solo de días hábiles, si requiero actualizar este dato en Issues anteriores existe alguna mane de hacerlo de manera masiva ?   

son aproximadamente unos 560 Ticket´s 

[Bill Sheboy]

Greetings!

Given your calculation is in a rule, you cannot use the built-in bulk edit features of Jira to change the existing issues.

You could create a one-time-use automation rule, which checks for the custom field being empty with JQL, and then updates as needed.  JQL in automation rules can only return 100 issues at a time, so you may need to run the rule multiple times to achieve your result.

When done, you could disable or delete that rule.

[daniel tobon]

@Bill Sheboy  agradezco tu apoyo. muchas gracias.