view all milestones inside a work effort

[christopher thorndike]

I'm trying to show all the milestones linked to a particular work effort (EDGW-1192). This is in an effort to export the results as a csv file since I'm unable to export as csv if I click on the work effort itself which is kind of frustrating. I have other options like XML, Word, Printable but not csv from this view however when searching aka using jql csv is an option among other ways to export results.

"Key" = 'EDGW-1192' brings back the work effort and if I click on the key in the result it brings me to the work effort page which is of not much help. There has to be a way of writing in jql, show me all the milestones linked to this work effort. I tried searching for a field like linked issue or the equivalent of a foreign key but only thing that came up is "Linked major incidents" 

[Kit Friend]

@christopher thorndike  are you definitely using Jira Server not a newer version like DC/Cloud? Using the timeline or Advanced Roadmaps (plan) view is a good way to do this visibly. 

"Milestones" isn't really a concept in Jira but you can query what issues/tickets are connected to other tickets in a variety of ways. 

You can browse the options in https://support.atlassian.com/jira-software-cloud/docs/jql-functions/

Depending what issuetype your item EDGW-1192 is some to try would be:

linkedissue = EDGW-1192

linkedIssues(EDGW-1192)

parentEpic = EDGW-1192

[christopher thorndike]

Thank you for the info. I'm using Jira v9.6.0 I reached out to a SME and they already had created a filter for this.

project = "EDG Book of Work" AND issueFunction in linkedIssuesOf("key = EDGW-1192") AND (resolution is EMPTY OR resolution = Done)