What are your biggest JQL frustrations — and how do you solve them?
Hello Group :)
In today's discussion -> JQL
Every Jira power user hits the same walls sooner or later.
Native JQL can't tell you how long an issue has been sitting in a specific status, doesn't support regex on summary fields, and has no way to dynamically query children of a parent based on criteria — only hardcoded keys. Aggregate comparisons like "show issues above the project average story points" are simply out of scope.
Examples:
I need: "all In Progress issues for more than 5 days"
Using updated is not the same — an issue can sit in a status for weeks with zero updates.
How do you handle this? We ended up with ARGON's timeInStatus:
issue > timeInStatus("project = DEV", "In Progress", "5d")
Is there a native way to query child issues based on parent criteria — not a hardcoded key?
I need: "all tasks under any open Epic"
"Epic Link" = XYZ-123 only works when I already know the parent. ARGON solves it:
issue in childrenOf("issuetype = Epic AND status = Open")
Curious how your Teams work around these — automation rules, exports, custom apps? Happy to share what works for us if useful.
Have a good start of the week.
Bartek from Orbiscend OU (Argon app provider)