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

Vandana Khurana April 23, 2012

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

1 answer

1 accepted

0 votes
Answer accepted
Renjith Pillai
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 23, 2012

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 April 24, 2012

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 24, 2012

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events