Transition on Custom date field expiration

[JIRA ServiceAccount]

Hi there,

We require users to get manager approval for remote access. With this in mind I have created a new request type with approvals.

In the new request users are required to provide the following info:

• A reason for the remote access
• Their approver
• From Date (Custom Field)
• To Date (Custom Field)

Once they log the request the approver gets a notification and they can approve via the self service portal. Help desk agents see the ticket in a new queue in an 'Awaiting approval" state. Once the approver approves the request the status changes from "Awaiting approval" to "Approved - On hold" and the resolution is set to "Paused". At this point a service desk agent will put the user in the relevant remote access group in AD and the user can access remotely.

The user keeps remote access for a length of time based on the From and To dates they provided.

After the To date has come to pass I would like the ticket to automatically transition to a new status "Approval - Expired" and be moved to a different queue so the service desk agent can pick it up, remove the user from the remote access AD group and finally close the ticket.

i thought maybe I could use SLA`s, Service desk Automation or a post function via JMWE but so far I can`t work it out :-(

The ability to do this would make managing these remote access requests so much more simpler, currently we have to continually monitor the remote access queue to see which ones have expired, any help or advise wold be gratefully  appreciated.

Thanks,

John 

[Nir Haimov · Accepted solution]

Hi,

If you have "Automation for Jira" (they also have free version "lite")

You can use jql condition, and than you say:

if "To Date" >= startOfDay()

transition issue to status "Approval - Expired"

Install the free version and try it out.

[Nir Haimov]

Hi @JIRA ServiceAccount

Did you manage to do what you wanted?

[JIRA ServiceAccount]

Hey Nir,

Apologies for the late response, Christmas holidays and all that.

I created an automation rule as suggested and my initial testing shows it works.

It took a bit of trial and error as I wasn't sure what the trigger would be, I have attached an image of the rule for others who may find this useful.

Thanks for your assistance.

Regards,

John

[Ann R]

Hi @Nir Haimov 

I have a similar issue. I want my issues to expire in 24 hours since the status has changed to Approved. I have set the rule as below, but it looks like it doesn't work. Any issues with the JQL i've setup? 

issuetype in ("AAAAA") AND status = "Approved" AND status CHANGED TO "Approval Expired" BEFORE startofDay(-1)