How to query for specific epics within a sprint?

[Sherjil Baig]

We have a program with multiple workstreams working. Each workstream has it's own unique identifier (workstream code) in JIRA. The teams working on this program however are not workstream dedicated. 

Looking to see how I can query to see the epics that are in the given sprint for a specific workstream code.

Example:

Workstream A:

Epic 1, Epic 2, Epic 3, Epic 4

Workstream B: 

Epic 5, Epic 6, Epic 7, Epic 8

Other Project Workstream X:

Epic 9, Epic 10

I want to be able to see the below:

This shows that Team 1 is working on 2 Epics from Workstream A. and that Team 2 is working on one epic from each workstream

Team 1 Sprint:

Epic 2,   Epic 4, Epic 10

Team 2 Sprint:

Epic 8, Epic 1, Epic 5, Epic 9

[Florian Bonniec]

Hi @Sherjil Baig 

You cannot really do it with Jira vanilla.

You can do it with app such as Scriptrunner.

issueFunction in epicsof("sprint = 'Sprint X' and stream = 'XXXXXX'")

You can also just run the JQL on Sprint and Stream then display the Epic Link field or find a good gadget to visualize the results.

Regards