Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.
×I was creating a quick JQL filter to find all the Issues in the Sprint that wasn't with a status of Cancelled so I could export the list. The results however brought up 1 extra issue that is of t...
I have a sprint board in Jira, and I'm trying to achieve the following behavior: The Active Sprints tab should display the tasks from the active sprint. You also need to display tasks in ...
Code worked. =) Hi Guys, I am really new to Jira and the management of it, slowly learning. Am a little bit stuck now, hoping someone can help me out. =) Goal: Code that cal...
JQL CONTAINS ~ operator doesn't work with 'Parent' fields. Use case: JQL advanced search eg. finding tasks with a certain condition under Epics containing particular name of the s...
Hey community, I am looking for a way to create a JQL filter which would return back a list of issues from an active Jira sprint with a column for the remaining days in the sprint. To make this a...
Hi. I have a customfield, that includes a mullti select list with structured information. I try to find a query, that returns any items that start with a certain substring. Values in the list could...
...ggregates in the parent Story ticket. In my JQL I have been able to include subtasks so the Time Spent displays the time taken but only per subtask, I want to see in my dashboard the time in total for the S...
Hello, I have this structure many Stories |- 1 Subtask Summary A |_ 1 Subtask Summary B I am looking for a query to find all of those Stories that have Subtask A closed...
...ext sequences. This order worked: " before ' before \" for exaple this jql pseudo query: filterfunction1( " filterfunction2( ' filterfunction3( \" ... \") ') " ) I k...
Hello, I have a hierarchy "Change Request", then Epic, then Story. Now I want to list all Stories that are sorted in this hierarchy and e.g. check if the Change Request has a special attribute set....
Hi all, How i can find the field id name when i know the id ? It is not a custom id (10014 ) Thanks !
Hello, We've recently migrated from Data Center to Cloud, and I'm looking to recreate some queries that used Scriptrunner issueFunctions. I'd like to search for issues containing comments mad...
Hi expert! Please help! I would like to create a chart maybe using "Rich Filter Time Series Chart" or "Rich Filter Simple Gauge", just to show the ratio between BUG type and STORY type of Ji...
I would like to ask if it is possible to filter out the comment content. Is it possible to filter out and export the comment content, date commented, and commenter of a ticket? I wou...
Hi Team, I am trying to compare two date fields and see if they are more significant than "X" value. I am trying with these two JQLs, but not getting any results, but we have tickets. Are these jql...
Hi everyone, I'm trying to create a JQL query to list issues that have not had any changes in the "timespent" field in the last 7 days. The challenge is that the "timespent" field does not s...
Hi everyone, I'm trying to create a JQL query to list all Stories that are currently in the "In Progress" status, but only if they have no active subtasks. I want to exclude any Stories that have s...
I'm trying to identify issues where Story Points are either empty or have invalid values using the following JQL: ("Story Points" IS EMPTY OR "Story Points" NOT IN (1, 2, 3, 5, 8, 13)) T...
First, I have a branch that creates issues and tags them with a label. Second, I have a branch that operates on JQL where the filter is labels in (mylabel) AND created >=-1hr Two issues w...
So this is a bit of a weird one that I don't even think is possible but you never know someone has an idea! I'm looking for a way to have a dynamic JQL where I can get all the issues that were c...
Hi Atlassian community, I'm wanting to setup an Automation rule in Jira Service Desk to automatically transition to the status 'cancelled' (resolution = 'Rejected') when the status is change...
Greetings, I have tried to apply JIRA CLOUD the following JQL query and it is not working ( when the same solution worked in the On-premise version ) I have Adaptavist ScriptRunner for Jira C...
Hello everyone, Recently, I have tried many times to get a start date of newly created sprint and compare if the sprint is 2 week or 1 week, but it didn't work out even though I am receiving numbe...
I'd like to have a JQL filter that looks for all items whose status changed within a 2 week time frame starting with a specific date. I know I can enter two specific dates, but, since I need t...
Hi all, Does anyone know how can i with the use of JQL, find for example rather a ticket in Jira is linked to a Fresh desk ticket? Thanks!
Copied to clipboard