Date comparision of linked issues

Andreas H_ar6cc6

Hi community, 

I try to find a query how to compare the resolved date of linked issues. 

Base issue is a problem record, which has linked spikes with "analyzed by" and stories linked "implemented by". 

I try to find problem records where the resolved date of the analysis spike is later than the resolved date of the implemetation story. 


Thanks in advance for supporting me. 

Mirek

Hi @Andreas H 

Not sure if you would be able to make a simple query (by JQL)..

Maybe using Automation for Jira could give you satisfying results (https://community.atlassian.com/t5/Jira-Software-articles/Comparing-issue-fields-just-got-easier-in-Automation-for-Jira/ba-p/1369461)

There might be probably other ways (or plugins) like Script Runner

I personally would resolve this by using REST API and some coding (grabbing an issue, getting all linked with it then comparing dates and finally create a report.. ) but it should be definitively possible.