How to list issues where issue link is created after a specific date

Still need help?

The Atlassian Community is here for you.

Ask the community

Purpose

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

Solution

  1. Login to JIRA database
  2. 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';

    (info) Modify the date time accordingly


Last modified on Aug 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.