JQL query to show Epics that had time logged on issues linked to it?

[krwgn]

Dear Community,

Hope you are all good today. I am looking for a way to quickly filter the inactive projects (Epics) - defined as a project that had no time logged in the preceding 2 weeks. I have tried using the "updated" option, but that will only show me the updates (time logs, comments, etc.) on the Epic level, while most project work in our set-up is done at the Task level, which is ignored by this argument. I am wondering if there is a way to show Epics that didn't have any action registered on both the Epic and the linked tasks.

[Hannes Obweger - JXL for Jira]

Hi @krwgn

if I understand you correctly, you'd like to filter for epics where no time was logged to either the epic itself or any of the child issues of the epic.

This is actually quite tricky, as it would require some kind of "join" or "subquery" (in database terms), which isn't available in plain Jira.

The only out-of-the-box thing I can think of is to create an Automation rule that would find the latest update date across an epic and all its children, and write the latest update date into a custom field on the epic. You could then filter by this custom field.

Alternatively, you could export your data and do some kind of post processing, or look into one of the many apps from the Atlassian Marketplace that extend JQL. Scriptrunner is very popular; I myself have used JQL Search Extensions a couple of times and it works great.

Hope this helps,

Hannes