How to list issues where issue link is created after a specific date
To retrieve all issues from database where issue link (eg: relates to) is created after a specific date.
- 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