Date comparision of linked issues

[Andreas Hauser]

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.