JQL Question

[Eric Roetenberg]

Hello 

Help!!

I need to have a JQL that:

that only shows userstory if:
project category != SAFe
Epic link != Empty
The Epic above has as Reporter X

I have this now but it does not work
category = SAFe AND "Epic Link" != EMPTY AND reporter = 62178db2802e760075497858

How do I get the reporter from the parent epic into the JQL?

[Mark Segall · Accepted solution]

Hi @Eric Roetenberg 

If your goal is to return a batch of stories, bugs, tasks, etc. whose Epic Reporter is x, you're not going to be able to do so natively.  Without 3rd party apps, your best bet is to create a custom user field to capture the epic reporter on the child issues. Then create an automation like this:

• TRIGGER: Field Value Changed (Epic Link)
• ACTION: Edit Issue (Your Custom Epic Reporter Field)

From here you could then use this query (note - use IS NOT EMPTY rather than != EMPTY)

Category != SAFe AND "Epic Link" IS NOT EMPTY AND <Custom Epic Reporter Field> = 62178db2802e760075497858

[Bill Sheboy]

Hi @Eric Roetenberg 

Yes, and...to Mark's answer...How often do you need to perform such a query?

• Need one time: search for the epics with that reporter, grab their issue keys, and use that directly in a search.  For example:

Category != SAFe AND "Epic Link" IN (firstEpicKey, secondEpicKey)

• Need often and have money to spend: investigate JQL or reporting marketplace addons, as Mark noted
• Need often and cannot purchase addons: investigate the custom field solution approach Mark noted

Kind regards,
Bill