How to clearly link incidents to their parent change

[Cameron Imming]

We have a regulatory requirement to report on any incident created by a change record.  Is there documentation on how this is done?

Ideally, would like to be able to report:
Change Record, Change Date, Incident Record, Incident Report Date

Thank you

[Mark Higgins]

Hi Cameron,

May need a few more details, and if I'm about to explain what you already know, then I apologise.

You can link tickets, using the Link option, and then the JQL can show your the columns of the linked issue, but not the details of the linked issue.

You would need (I believe) to extract both sets of data and then merge the spreadsheets, using something like Vlookup.

In short JQL does not do what you want out of the box.

Mark