...raceability audit, so it just doesn't happen A JQL Approach That Actually Works If your team has been disciplined about linking Jira Epics to Jira Align Features (via the "Align Feature" field o...
...amed "PROJ'. It fails with a notice of JQL deprecation. #############ANSIBLE CODE####################### --- - name: Get all task metadata for project PROJ h...
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 s...
I noticed a discrepancy in result counts when using the CHANGED TO operator with multiple statuses. These two queries should be logically equivalent but return different numbers of results (65 vs ...
...lindness" or manual Excel workarounds, this guide is for you. We’ll dive into the technical JQL "power-ups" you need for proactive monitoring and explore how to bridge the gap between engineering v...
...elebrate Artemis II and the slow, stubborn human march toward Mars, we're publishing something we've been working on: The Ultimate JQL Cheat Sheet. Why a JQL Cheat Sheet? If you've spent any t...
...etting SEC-1 'is related to' FIX-1a, FIX-2a, and FIX-3a. In the jira automation, I set a smart variable successfully at the start such that {{secticket}} is set to 'SEC-1' by using a For JQL. H...
...f the 622 on a dashboard. The creation of a dashboard isn't the problem, it's the JQL query to do something like "exclude duplicate summary" as the summary will be exactly the same. I...
We are moving a JSM request type from one project to another. However, we are finding that a lot of users built their dashboard JQL with the request type name and project, like Get H...
Brothers and Sisters I am creating 1. JSU JQL Precondtion which retreives all child stories of EPIC which are not resolved 2. Action Update Any issue field if precondition = YES A. Test EPIC w...
...he year 2025. Jql does not support to pull the history data for custom fields. Is there any way to get this data using script runner? Any recommendations would be helpful. Thank you
JQL doesn't seem to be formatting things properly for JPD items like Project Start and Project Target. Example result: {"start":"2026-01-01","end":"2026-01-31"} for Project start.&n...
Right now if you create a Roadmap with multiple spaces and an advanced filter it works but if you leave the Roadmap and go back to it all of the previously added spaces are gone. This is a P0 l...
...hose methods inevitably fall out of sync. The solution isn't more manual entry; it’s better logic. By using Jira Query Language (JQL), you can curate a single source of truth that serves different a...
...eed answered for an escalation to be allowed and then when submitted tigers automation on the back end to alert the team your escalating to. What i am looking for, is a JQL or search o...
I have to use JQL for a search that connects to a slack integration, and I explicitly want to exclude where the name of the work item is "TEST". However, summary only seems to search for !~, which m...
...n open Bug, but native JQL often hits a wall. While it is brilliant for slicing data by fields, it struggles to filter based on the status of a linked item. Usually, this leaves you with two bad o...
Hello, Am trying to find a JQL statement which will help me find tickets reassigned back to a resolver group. In this case Service desk. So essentially I was to find tickets which was a...
Hey, I've been trying to send an api JQL query to JIRA. When I use a regular token, everything works wonderful. When I use a scoped token, Im able to authenticate, but I'm n...
I have set some custom definition of dones and I need a JQL where I can get all the items that have a particular DoD set to Not Applicable only or false. I'm using "Definition of Done" = i...
I'm having an issue in JQL where I'd like my filtered results to be sorted by Sprint. Some issues got carried over from previous sprints and have completed sprints on them. Sorting by Sprint ASC s...
Hello Community, I am trying to setup a kanban board with 4 swimlanes, sorted based on a jql lisitng jiras per fixVersion: - fixVersion 1 - fixVersion 2 &n...
In a previous article, I showed some screenshots from my Jira Code, Snippet, and Example Library. I use Confluence to store my frequently used JQL queries, automation rule smart values, and other r...
Hi everyone, I'm trying to create a smart formula for a Jira Structure column and hope you can help. My Goal: I want to display the status of a Test from within the context of a specific Test...
We all love JQL (Jira Query Language). It is the heartbeat of Jira, allowing us to find exactly what we need, when we need it. But often, bridging the gap between complex search logic and automatic a...
Copied to clipboard