目的

To retrieve all issues from database where issue link (eg: relates to) is created after a specific date. 

ソリューション

1. Login to JIRA database

2. 次の 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