If you 're following an agile methodology for your Jira project, it is likely that you will have many Stories linked to a single Epic. com There are three ways to create epics in Jira Software: the Timeline, Backlog, and Global Create issue button. There are no parent-child relationships at all. action: lookup issues on JQL where "epic link" = { {triggerIssue. Epic Name: It is a short identifier for the epic. This alias can be used with the JQL relative date functions and also the numeric comparison operators. However, Epics have. Jennifer Kurtz Oct 07, 2020. Like • Alisha Taubner likes this. Click on an epic. I'm looking to use a JQL query for an issue matrix custom field on a custom issue type called an Initiative. Hello Atlassian Community, My name is Bryan Lim and I'm a Product Manager working on Jira Software. Description: Searches issues within epics that match the given subquery. Video and interactive training to get you up and running with ScriptRunner for Jira Cloud. When you create an epic, you'll need to enter the following details: Epic name - A short identifier for your epic. Click on “+ Add issue type”. chrome. and not issuefunction in epicsOf("statusCategory != Done and labels not in (ABC) or labels is Empty") I believe that will work. To manage your Jira epics on the board, click the 3 dots in the top right corner of your screen and select “Board settings” then “Columns”, where you can enable or disable the “Epics” panel. Community Leader. Additionally you can further refine your query by specifying a link type. Find all Storys to an Epic by using a subquery on Epic Link. In Add Parameters To Function, select ON_CREATE in the Stage field and click Add. Users can plan work in Jira with the help of the Jira backlog tab. getChangeItemsForField (issue, "Fix Version"). 127. JIRA Agile users can query on epic links, eg find all Epics that have unresolved stories: issueFunction in epicsOf ("resolution = unresolved") You would just need to add a bit to the query to constrain it to only the Epics that are marked as Done. Once you’ve changed the epic level name, head over to the Issue types settings screen, and update the name of the Epic issue type to reflect your new level name. A JQL query is a set of words and operators that define how JIRA will narrow your search. With JIRA alone, I don't think this is possible to do in a single JQL query. type= Epic and issueFunction not in epicsOf("type in (task,bug)") Generate a consolidated Jira epic progress report. Tarun Sapra. Using this app you can also query other issues relations, check:To manage the scrum development process of a big community website, we decided to move to JIRA/Greenhopper/Bonfire. User Stories are requirements, and Jira is not a requirement tool. How to use ScriptRunner JQL Functions There are two ways to use ScriptRunner JQL functions: All Jira issues that have an ABC epic associated: issueFunction in issuesInEpics("project = ABC") and again, same as above: issueFunction in epicsOf("issueFunction in issuesInEpics(\"project = ABC\")") Now, some variation. To create a new epic, click on the ‘Create Epic’ or the ‘+’ sign from the epic panel. There are following steps involved to create an epic from the Epics Panel Link on the dashboard. Then, add the column "Epic Link" > Click in Export > Select "Export Excel CSV (Current fields)" If you want to export all fields from your issues, including the Epic link, Click in Export > Select "Export Excel CSV (All fields)". The start and end dates of Epics are less certain in general than the dates for sprints. Click Edit for the workflow associated with your project. Here is my queries so far: project = t5064 AND issuekey in portfolioChildIssuesOf (T5064-164) ORDER BY cf [10158] ASC. a) I tried mapping my issue id column in the csv to issue id in jira and then putting the Epic's issue id in the epic link column of the stories belong to that epic. Create a parent issue. Over time this ticket has become a "catch all" for anything related to Epics and Stories in Jira Work Management. example: issuekey = EEEP-963 OR issuekey in childIssuesOf (EEEP-963) OR issuekey = EEEP-992 OR issuekey in childIssuesOf (EEEP-992) AND issuetype in ("Portfolio Epic", Capability, Epic. gl - peterIf you use Jira cloud, click on the Search icon on the left, and navigate to the advanced search screen to search for the EPICs. Of course this assumes you have a custom field ‘team ownership’. In Azure DevOps (my previous experience before Jira), we had buttons to expand. e. It’ll also give people an immediate sense of any trouble or challenge. Add a new epic. During this time Jira Work Management has seen plenty of updates, some of which address the requests and comments in this ticket. parent}} where the parent is the epic of the task. There is the Epic Report that's a default report, but it won't give you a % Complete based on the number of issues completed within that Epic. This would return all the issues of type epic in project x. On the General tab near the bottom select "Use Ranking". Regards. It looks like you have ScriptRunner or similar based on your use of issueFunction. A Jira epic progress report is often used interchangeably with status report. Thanks! Related Topics Atlassian Public company Business Business, Economics, and Finance comments sorted by Best Top New Controversial Q&A Add a Comment. I included the board that "owns" the Sprints as a 2nd Issue Source. Use graph view to see a progress bar of finished vs total stories, to link to a report, or to add issues on the fly. One other 'issue. Our team's projects are by Epic that rollup into initiatives, etc. bodzek December 7, 2017, 11:11am 1. Click on “Epic” and “Add”. The problem is when using this query on a board users who have manage sprint permissions in the projects are unable to create a sprint. ) But you can test Deep Clone for Jira for free for a minimum of 30 days. Using i. I have NOT found a way to make the criteria dynamic, for example to screen all epics that are NOT associated with all of the currently applied quick filters on the JIRA board. You can change the order of the issues by selecting the epic and dragging/dropping the sub items in the right panel. Product = Project For your project, create a project in JIRA. You can read more about Deep Clone pricing on our Marketplace page. A structure can contain issues, folders, and other items. Learn How to Show Epic On Boards in Jira on this "Jira How-to" Series by Jexo. 7. Here's some information to get you started: There are two types of automation: Global: In the Free version, you get 100 executions per product, per month. Examples Description: Searches for epics that belong to issues that match the given subquery. Examples: issue in epicsOfChildrenInQuery("'Team Name'='My great team'") and status='To Do' finds my team’s epics that are still in progress issue in epicsOfChildrenInQuery("assignee=currentUser() AND updated>-1d") finds epics of my. Credit: Atlassian. Let's first align a few common aspects of a sub-task: Are small. 2. It seems this is because Jira doesn't know what projects. Here are your options: Epic that have Features which then have sub-tasks. find all stories for open epics in a project. 1. Differences between ScriptRunner for Jira Server and Jira Cloud. Research - "Application Packaging Discovery - XYZ". Kind regards, Martin JIRA Software Feedback Policy: Our product teams collect and evaluate feedback from a number of different sources. Use the following parameters to define the epic's design: Hypothesis is an educated guess about the total design needs of the epic. issuefunction in issuesinEpic ("Project = XYZ and fixVersion = 'Aug 2021') ScriptRunner 's JQL functions will definitely help. This is a restriction, I want to use the story key to get the Epic key, what you've suggested is the other way round. E. ) Jira’s Epics provide a powerful solution for managing complex software projects, and understanding how to use them can make all the difference. Epics are just big user stories that usually span multiple sprints. e. Answer accepted. These would be the steps: 1 - Create the following JQL filter: 2 - Navigate to your dashboard and click to create a Filter Results gadget, adding the filter you created. I have tried issueFunction in epicsOf as well as issueFunction in subtasksOf. Once you enter a name click the Turn it On button. Deep Clone for Jira is a paid Marketplace app. But using multiple tools can be messy. Epic), any other stories within that Epic, and the original issue's sub. In this article,. The issuesInEpics () function basically makes sure that the result of whatever you specify as the subquery will only return issues linked to open Epics. epic link}} branch: on epic parent. Over the past year, we’ve been providing updates around renaming epics in your company-managed projects. runner. e. EPICS PANEL should sort alphabetically. Share. 7 Is it possible to search JIRA for a list of subtasks whose parents are found in a different query? 1 JIRA JQL - Find all subtasks that are in X status, where the parent is in X. issuetype = Epic and issueFunction not in hasLinkType ("Epic-Story Link") the above JQL will give you all epics in the system which don't have a child story. Based on the customer needs, the task is added or removed from the epic as necessary. I always ask myself if I use Jira Epics the right way. Jul 02, 2020. If you navigate the backlog, you will see the ‘Epics’ panel on the left-hand side of the backlog. my company is set up in multiple teams and each team has its own project in Jira (project A, B, C). under that epic in Jira that I can then use to create a board. I was able to drap and drop on the ROADMAP screen, and the changes seem to be carried over to the BOARD. 2. A backlog is a prioritized list of work for the development team that is derived from the roadmap and its requirements. Above is the JQL I'm using with the added JQL from ScriptRunner. Eshan Salpadoru Dec 10, 2017. Open your Work page, and click on “Create” under your last issue. JQL Booster Pack (if you are on Server / DataCenter) you can type the following: 1) A bunch of Epics. here is how I did it. David Almeida Feb 17, 2020. issue in childrenOfEpicsInQuery ("fixVersion='21. Add a new epic. Task. Reply. . ’. To the best of my knowledge, you'll need extra tooling for this. Learn more about using Jira automation to modify issues and automate your issue workflow. In the configuration of the gadget specify the Saved Filter you made. (This is a finite list; the search will yield only 1 or 2 other Jira projects. OR issueFunction in epicsOf("project = <project> AND Teamlet = <team name>")Answer accepted. You can also select Create in the top navigation bar, then change the issue type to Epic. Jira Software でエピックを作成する方法には、ロードマップ上での作成、バックログでの作成、およびグローバルの課題作成ボタンによる作成の 3 つがあります。. action: lookup issues on JQL where "epic link" = { {triggerIssue. Epics reside in a separate projects (projects X,Y) and the user stories of the epic reside in each team's respective project. Credit: Atlassian. We can expand or collapse an epic by clicking the little icon to the left of the purple lightning (top left in the screenshot). Sounds simple like running finding all stories in epics but cannot figure it out. It obviously will require some scripting, and there's always a certain risk of inconsistencies, if a rule, for some reason, isn't executed or delayed. In a usual process, this parent link must be. fixVersion in ('version') AND issueFunction in linkedIssuesOf ("issuetype = Epic") fixVersion in ('version') AND issueFunction in linkedIssuesOfRecursive ("issuetype = Epic") As you're on Jira Server, the correct answer is to get an app that provides JQL extensions you're looking for. Task. This is what I was looking for. We are using the 7. In a Software Team Managed project, the Summary of the parent Epic of an issue will automatically display in a card thus: In a Business/Work Management Team Managed. edited Jul 1, 2016 at 14:23. Note that in large Jira instances, you will hit performance issues by simply using the type in the inner query. issueFunction in epicsOf () is too complex for Scrum board. In the epic panel, select + Create epic. Jira’s Epic Features. 3 JIRA query to check if a parent issue has specific sub-tasks. Example: issueFunction in epicsOf(“project=IDP AND issuetype=Incident”) To get the three levels of hierarchy in JQL, use the ScriptRunner app with the function “issueFunction in linkedIssuesOf. The old navigation will be removed from Jira Align in version 10. Deep Clone for Jira is a paid Marketplace app. It's not possible to do this without an plugin. You can expand an epic’s details by selecting the chevron () next to an epic’s name, then selecting View details. Click on it to show all the epics created in your project. Epics are the collection of issues that need working on. Learn how to create a Jira automation rule that keeps epics and stories in sync with their parent issues. There is no limit on the hierarchy depth, and you can bring together all types of issues from different projects. Using i. UserMessageUtil. 3. The Jira Sprint Health gadget summarizes the essential metrics in a sprint. You should have only one product backlog, which will include the. 2 answers. To begin creating an Epic, click the "Create" button. Jun 08, 2020. Step 2: To fill the Project Name, Issue type as Epic, Epic Name, and Summary for Epic. Using Jira as the central source of truth for your DevOps practices, unlock the extensibility of an open, diverse toolchain while keeping the ease and coordination of an all-in-one. Now the Kanban board of project A shows all epics of project X, even if that epic. If you want to have an Epic for your project and its children here you go : parentEpic = KEY-1. Update an epic's details. Since issues in epics can be from multiple projects and the issues contained in the epic might have different workflows and statuses, an epic status. 0. Epics in Jira refer to large. Select issue type as ‘Epic. Instead you have to use a new interface called ScriptRunner Enhanced Search to create the filters that use those functions. Epic) if "KEY-123" is a task level (e. Initiatives are meant to associate several Epics under their scope, with a link called "Parent Link". Story Points. you can create new issue types that equate to level 2 or 3 (story/task or sub-task). Jan 27, 2020. issueFunction in issuesInEpics ("fixVersion = 'Aug 2021'")ScriptRunner for Jira Cloud's out-of-the-box JQL functions are available to all users but can only be used on the Enhanced Search screen under Apps > Enhanced Search. type= Epic and issueFunction not in epicsOf("type in (task,bug)")All Epic Progress Report. Modify Parent Issue fields like Assignee, Components, Fix versions, Due date, and Epic Name. ScriptRunner's scripted JQL functions are a life-saver to Jira admins performing many advanced search queries. 13 version of Jira. g. In the epic panel, select + Create epic. Epics are linked to Initiatives using issue linking - not the parent hierarchy (i. You can select your filter for Epics (ie issuetype = Epic AND fixVersion = yourRelease) and Agile Docs will bring up all Epics AND child issues of each Epic. ID summary Epic Name Epic Link. Epics burn down, components don’t. Also, boards are not connected to projects, so you can create how many you want and set different filters. 1. I would like to create a JIRA query to list all Epics under Initiative, which will allow me to create a Two dimensional Dashboard gadget with all listed Epics under that Initiative, and its' statuses. project = A and type = Story, then export all stories (including at least the "Epic Link" field) Then in excel remove duplicate of the column "Epic Link" then copy all remaining value and run a JQL such. Create Epic 1. Real time edit option for Issue summary, status, time estimates, story points and assignee on the tree on the Epic Hierarchy. 1. b) I tried using Epic name as the link vs the idIn development, Jiras Epics are used as a rubber band to keep a feature together if it stretches over multiple iterations. Otherwise, register and sign in. Hugo Jul 15, 2020. “Create” icon. epicsOf() Searches for epics that belong to issues that match the given subquery See also: issuesInEpics() Note: Since you need to enclose the provided subquery using doble quotes , you must to escape any doble quotes using in the subquery by preceding a backslash after the double quotes, alternatively you can use a single quote in some cases. Below are just some examples of how you can use ScriptRunner JQL functions: Use epicsOf to query on epic links, such as finding all epics that have unresolved stories. type = Epic and issue NOT IN epicsOf ('"Epic Link" IS NOT EMPTY') Using this app you can also query other. If you've already registered, sign in. issues in Epic does not work. Ask a question Get answers to your question from experts in the community. In Jira, Epics, Stories, and Tasks are fundamental components used to manage projects and streamline workflows. Click Create rule. See also: issuesInEpics () Note: Since you need to enclose the provided subquery using doble quotes, you must to escape any doble quotes using in the subquery by preceding a backslash after the double quotes, alternatively you can use a single quote in some cases. You have a filter to get your features and you would like to get Epics in those features? So if you add "AND issuetype = Epic" to your filter or if you try to write "Issuetype = Epic AND features in (features' list)" it doesn't work ? Yes, it doesn't work. scriptrunner. Bill Sheboy. Epics Map offers multiple ways to view your epics and their progress. In the epic panel, select + Create epic. Features. Changes you make to your epic level will be reflected throughout all company. . This means choosing between Atlassian's initiative-epic-story approach versus the SAFe purist epic-feature-story. issueType = Bug and issuefunction issuesInEpics (<filter>) I know that if you replace <filter> with the JQL that you used to select your Epics, and put that JQL in quotes, then the above should work. Open the epic panel by using the toggle in the epic filter dropdown. I will answer there also. In this article, we’ll discuss 10 Jira epic best practices that will help you get the most out of your Jira epics. Using i. View. Try this project =(keys of stories/sub tasks project) AND “Epic Link” in (XXX-1234). Method 2: Creating an Epic from the Epics panel. With standard JQL, you can only get a list of. Have your voice heard!Introduction. sum}} Of note: this works for a company-managed (classic) project. For example, all issues created with a component of 'database' could be assigned to Jill Smith. Select a project or projects to limit those. 0 - 7. Using query below, I can get of list of epics to be excluded. The Design tab is used to capture UX/UI design information for the epic. Good find!Answer accepted. We will start with four industry-specific examples of initiatives – epics – stories triad. edit issue fields: setting the story points to { {lookupIssues. I am trying to create a query that returns all issues (task/story/bug. Confluence Whiteboard - Import from Jira - Show Epic Link on Card. Like. Our Screenful Metrics for Jira app allows you to aggregate data from multiple boards and show progress on the epic level: You can also track various metrics per epic out-of-the-box, and use them in filtering and grouping data. I know this is old. you can create new issue types that equate to level 2 or 3 (story/task or sub-task). Get Involved. The direct page you linked provides descriptive information but not directive information. Jira hierarchy - the ability to add hierarchy levels above epic. David Cole Aug 15, 2020. I would like to find all epics that have "Issues in Epic" from a specific Project. With the "EpicOf" jql function provided by scriptrunner, you can do the following: project in (AAA, BBB, CCC) AND (type in (Story, Task, Bug) OR issuefunction in epicsOf ("project in (AAA, BBB, CCC) and type in (Story, Task, Bug)")) It's best practice to include a project filter in the sub-query to limit performance impact. You can also create an Epic from the Epics panel shown in “Backlog”. 0, please see the server release notes for further details. The Kanban template allows us to see issues under their parent epic. 1 parent MyEpic. I want a progress report (% Complete) based upon the number of issues. Task. issue IN epicsOf ("status = 'In Progress' AND reporter = currentUser ()") Searches for epics that belong to in progress issues reportered by me. AGnieszka GRodzka Oct 29, 2021. Whereas Summary is just the normal JIRA field. Portfolio for Jira enables two things relevant to your issue; the ability to create custom hierarchies, such as. below is the example of JQL Search Extensions for Jira & reports. It's just, we prioritize and assign work based on Epic - not on user story. @Karthik Balasubramanian. Insert a name, select at least one tag type and click on the Add smart filter button. Trying to build a JQL to find EPICs that have component = “EPIC Schedule” AND a Label=”Afloat” that are missing certain “linked” Stories (basically Issues in Epic) that have the following criteria: "summary !~ 'Submit COP'" (missing a story with “Submit COP” not is the Summary) There are currently:. You can see each Epic progress in the backlog "Backlog' section, but that doesn't show the completed/in progress/to do numbers. epicsOf() hasSubtasks() issuesInEpics() linkedIssuesOf() parentsOf() portfolioChildOf() portfolioParentOf() subtasksOf() Regards. Using JIRA Server, not admin on it though. Configuring columns. edit issue fields: setting the story points to { {lookupIssues. Finally, click on Export, to extract the table into a variety of formats, including CSV. You can also select Create in the top navigation bar, then change the issue type to Epic. All you have to do it to have a filter that returns the issues to be grouped and to configure the gadget to use this filter. I am an Admin on all projects. There are 3rd party add-ons that can help you to achieve that. The parameter "features in" doesn't seem to be. made a swimlane for each epic: "Epic Link" = <epic's issueid> OR parentEpic = <epic's issueid>. JIRA Agile users can query on epic links, eg find all Epics that have unresolved stories: issueFunction in epicsOf ("resolution = unresolved") You would just need to add a bit to the query to constrain it to only the Epics that are marked as Done. issue IN epicsOf ("status = 'In Progress' AND reporter = currentUser ()") Searches for epics that belong to in progress issues reportered by me. There are the following steps that are involved to create an epic from the new issue tab i. The I saw an error: An epic cannot have another epic linked to it. But I found a solution without the need of any additional Jira add-ons. Open the epic panel by using the toggle in the epic filter dropdown. Marketplace Partner. Hi there, I'm trying to create a report that will show % status by Epic, similar to the blue progress bars we see in the Epics panel in our backlog (so I know this is already being calculated somewhere!). An epic cannot have another epic linked to it using the Epic Link field, however two Epics can be linked using standard link features (i. We would like to search for all childissues of a list of epics that are belonging to an specific fix version. Here is my queries so far: project = t5064 AND issuekey in portfolioChildIssuesOf (T5064-164) ORDER BY cf [10158] ASC. . Once you’ve logged in to your Jira account, navigate to the project in question and click the global Create button in the top toolbar. Then you could have a quick filter based on that field. Using above query as a subquery, i could retrieve all stories involved in Epics. A Jira epic status report is a document that takes an ongoing epic into account. In Jira Cloud most of the ScriptRunner JQL functions cannot be used directly in the Advanced Search/View All Issues screen. 1#76002-sha1:21e6670) About JIRA; Report a problem; Atlassian. (Update 2022-01-27: Deep Clone for Jira is free for instances with up to 10 users. I then use a 'Link Issue' action in order to link the issues. Stories and Tasks belonging to the same epic, are sometimes linked or co-dependent. To manage your epics from the backlog: Go to the Backlog of your Scrum project. See also: issuesInEpics () Note: Since you need to enclose the provided. : use issueFunction instead of issue if you have Script Runner for Jira. For a given JQL subquery it finds the epics of the resulting issues. Go to Filters->Advanced Issue Search. Or you have multiple Stories for one User Story. We have a large roadmap that acts as our strategic plan. Regards, Seba. It also does not provide a native method for you to get a list of Epics and their Child Issues based on using a filter to get the Epics. Each project is a table. 2. A unique issue identification number is created when initial credentials such as epic title, summary, etc. ステップ 1: Jira Software で新しいエピックを作成する. issueFunction in issuesInEpics ("project. Click on the issue types avatar, and click on “Manage Types”. Script Runner. Select Link. Understand platform and feature differences. So I thought this would work: project = PROJ1 AND "Epic Link" = EPIC-123 AND (issuetype = Story OR issuetype = Sub-task) ORDER BY priority DESC, updated DESC. More screenshots available on the Tour page . So to create an child issue in a project other than the Epic's project, you'll have to hit the Create button, choose the desired project and link it to the Epic using the Epic Link field. The most important items are shown at the top of the backlog so the team knows what to deliver first. This part of your filter. You can now see a new dropdown box that allows users to sort issues under epic issues (company managed projects) and child issues (team managed projects). There are third party apps that would enable you to get a list of child issues based on a filter for retrieving the list of Epics. 2. Out of the box, the epic reporting available to you in Jira consists of some basic insights in the backlog and the epic itself, and if you’re using a Scrum board, two board reports: the Epic Report and the Epic Burndown. E. Garrett McCreery. If you navigate the backlog, you will see the ‘Epics’ panel on the left-hand side of the backlog. g. You can read more about Deep Clone pricing on our Marketplace page. Select Add Workflow > Add Existing and then choose your new workflow. This pulls all the Epics and Stories we are. Task. Here is how you can create an Epic issue in Jira: Create a new issue. Epics and stories prioritization in JIRA. Give the needed epic name and the title of the summary. I would like the Epic to reflect. Note that the Jira issues macro has a cache, so if you are testing this you need to click the refresh icon on the Jira issues macro. You can get a Jira epic report in Jira Software or you can export a Jira epic report to Excel for further analysis. For the issues matching the query "Epic Status" = "Done" and statusCategory in ("To Do"), we can bulk update Epic Status to To Do and similarly for statusCategory in ("In Progress") to Epic Status = In Progress, so that Epics. Step 2: To fill the Project Name, Issue type as Epic, Epic Name, and Summary for Epic. So your Feature could be at level 2. >(type=EPIC AND issueFunction in epicsOf(the query above)) Note that apparently issueFunction and epicsOf are features of the ScriptRunner add in. When I use Epic Link on Yaxis, it does not list the Epics, but just one row with overal count of Epics under. epicsOf. Epics often encompass multiple teams, on multiple projects, and can even be tracked on multiple boards. +++Feature A1-1. Publish your new Workflow. Like. In the issue detail view, select the link icon then select Link Confluence page. Export the results. 2. If you use Jira, then use components to bucket work by category. JQL support for Epic Hierarchy screen. if you have Scriptrunner on the instance, you could use their JQL function . Using i. But this only returns the stories. The answer below assumes you are using Scrum. The Epic Name and link does not work in the query. It is widely used by software development teams to plan, track, and manage their projects, as well as to collaborate and communicate with team members and stakeholders. 4. x. Click an Epic's chevron ( >) in the panel to view and edit more details. Hi, I have a project with Epic under it Stories, Tasks and Subtasks (hierarchized). In the configuration of the gadget modify the Columns To. – Ian Kenney. There is a bug or feature. Epics in Jira are used for. Perhaps the above query from Daniel does not match your assumption one hundred percent. OKR levels - is the ability to set and track Objectives on. (Note that I also removed sub-task from the inner query, because sub-tasks cannot have an Epic parent link). I would like to find all epics with a version >= 5, but which have a specific story linked to them. This works if you want to do a one. in the active sprint view, when I create swimlane from epics: issue simply disappears and IS NOT visible at all even. On the next screen, select Start Here to connect Asana and Jira. saltish1 • 2 yr. This gadget displays the progression in the completion of a particular group of epics by different estimation statistics. 1) Query for issues linked to an Epic reporter by a given user.