How to list issues where issue link is created after a specific date
Purpose
To retrieve all issues from database where issue link (eg: relates to) is created after a specific date.
Solution
- Login to JIRA database
Run the following SQL:
select cg.issueid from changegroup cg, changeitem ci where cg.id = ci.groupid and ci.field = 'Link' and ci.newstring like '%relates to%' and cg.created > '2018-07-10 11:00:00.000+08';
Modify the date time accordingly
Last modified on Aug 2, 2018
Powered by Confluence and Scroll Viewport.