You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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,