How to get a report of issues where a custom field has been updated

[Vandana Khurana]

Hi,

I need a report of all the issues where a custom field has been updated in the last week. what is the easiest way to do it?

Warm Regards,

Vandana

[Renjith Pillai · Accepted solution]

AFAIK, may not be directly possible with JQL. With an SQL query you could get this, and put this in a Confluence page.

This link may help you to write the query.

http://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA

[Vandana Khurana]

Thanks Renjith, unfortunately I or my team do not have access to the hsqldb.

I am thinking of creating another custom date field to store the last-updated-date for the main field on which I want to run the report (lets call it 'A'). Is there any way to default this date field to today's date everytime A is updated? Appreciate your help!

[Renjith Pillai]

A workflow post condition using Jamie's script runner to update it may be an option.

https://plugins.atlassian.com/plugins/com.onresolve.jira.groovy.groovyrunner