Automation: Change status of ticket when date in "Date Time Picker" field has come

[Carolin Jonietz]

Hello all, 

I need help with a global automation in the Jira Service Management.

We have configured a customized field of the type "Date Time Picker" where we fill in dates of appointments with our customers. Until the day of the appointment has come, the status of the ticket is "Blocked". I want to configure an automation that changes this status back to "Open" when the date that's set within the customized field has come. Can this be achieved somehow? 

Thank you in advance! 

Carolin

[Dirk Ronsmans · Accepted solution]

Hey @Carolin Jonietz ,

Since there is no "constant monitoring" of a date field (except in an SLA) you might be best of using the "Scheduled trigger".

This trigger you can run once a day (or more often if you need to), that will then ask for a JQL query to find which issues to run your automations on.

I would think something like

'Datetimepickerfield" <= startOfDay() AND Status = "Blocked"

'Datetimepickerfield' <= now() And Status = "Blocked

or something like that.. and then as your action have it do the transition to Open.

This is a rough outline that I think should work :)