JQL for custom report

[Christine Robert]

Hello,

I am attempting to construct a JQL in order to create a custom velocity report that will exclude a specific epic. If anyone has any recommendations, I would greatly appreciate it.

Thank you,

Christine

[Mirek · Accepted solution]

Hi @Christine Robert 

Not quite sure do you want to only exclude specific Epic or also issues that belong to that Epic, but overall you might try to use "epic link"

Find issues that do not belong to epic "ABC", where "ABC has the issue key XYZ-31
"epic link" != XYZ-31 or "epic link" != ABC

[Christine Robert]

Hi @Mirek 

Thank you for the fast response. This is a weird request from an upper member of our team who allows issues to be added once we have started a sprint & records  them under an "Unplanned WorK" epic.

Now they are requesting reports that exclude issues recorded under this epic.

I'll give this a shot. Thanks for the assistance

[Bill Sheboy]

Hi @Christine Robert 

Adding to what @Mirek suggests, if you also have work items which are not assigned to epics, you may add another clause:

"Epic Link" != ABC-123 OR "Epic Link" IS EMPTY

Best regards,

Bill