I would like to join the output from two different filters and display the aggregated res

Question

* I would like to join the output from two different filters and display the aggregated result. I have fields like key|summary|assignee|Epic link|poject WBS code

* All of the fields come from project abc except field XYZ code
* XYZ code comes from other project PQR
* I need to aggregate both the in one result
*

Please suggest JQL for same

Regards,
RP

Raghu Pothu · Answer

Thanks, jack, I need Filter-3 in below e.g for which aggregated result of both Filter -1 and Filter-2 in Filter-3 fields which I need is

Issue KeySummaryStatusEpic LinkAssigneeSMS Code

Issue Key, summary, status, Epic link, and assignee comes from Filter -1 and SMS code comes from Filter-2

In both filters common filed is Epic link in filter -1 and Issue key in filter-2

Filter -1     Issue KeySummaryStatusEpic LinkAssignee SCMG-14Test IssueSELECTED FOR DEVELOPMENTISD-14RAM VANGA SCMG-13Test IssueOPENISD-18Rajneesh SCMG-19Test IssueDONEISD-23Mangesh       Filter-2     Issue KeySummaryStatus AssigneeSMS CodeISD-14Field configuarationOpen RAM VANGA0.00254ISD-18Linked IssuesDone Rajneesh0.0042561ISD-23MajorityWIP Mangesh0.1456879      Filter-3     Issue KeySummaryStatusEpic LinkAssigneeSMS CodeSCMG-14Test IssueSELECTED FOR DEVELOPMENTISD-14RAM VANGA0.00254SCMG-13Test IssueOPENISD-18Rajneesh0.0042561SCMG-19Test IssueDONEISD-23Mangesh0.1456879

Regards

RP

Jack Brickey · Answer

Do you need this to be dynamic or can you simply create a new filter to accomplish? Please provide the syntax of the two filters if you need assistance.