Automating Queries In The Enhanced Jira Query Tool

UPDATE: I have since incorporated this feature into the EJQT. You can find the details here.

I have had a number of requests to allow the EJQT to automatically execute the selected query on a daily basis to make it more like a reporting tool. That is really the role of the LAD and LSAD tools which both have the automatic execution and I would prefer not to reinvent the wheel.

With that said there is a relatively easy way that you can add in the automatic execution yourself. Google Apps scripts uses what they call Triggers to allow scripts to handle various types of events. One of the event sources is time. Based on a schedule you can tell the Trigger to execute a function in the script. This makes it relatively simple to automate the execution of the query on just about whatever schedule you want.

Here are the 6 simple steps to implement the automation:

1)Select Script Editor from the Tools menu

2)In Script Editor click on the clock icon in the tool bar(it will say current project’s triggers when you hover over it)