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 want to build up my teams dashboard. One of the returning questions is, how I can retrieve the Sprint goals in a specific year or period of time? I have created those kind of queries in the past, ...
In release page I have 2 data field: 1) Start Date 2) Release Date I want to filter ticket added to that fixversion after the "Start Date". Who can I do it with JQL filter? ...
...he alternatives - see list above) to the search bar. If I have an alert with the extra property foo:whatever and the alert title contain s whatever this title is, then the search query...
Hi Team We have a field labeled "Technical Product Owner" with a checkbox that can be marked as "Yes." However, when we try to filter the results, we get incorrect outcomes. We have over 1,000 ticke...
Hi, Summary - I'm using the Jira Cloud plugin for MSExcel and my JQL queries in separate spreadsheets are being overwritten with the last query i have run. Background I am working with 2 s...
Hello all, I have a list of Program Epics and I need to find out which Epics do not have a linkage ("is a child of" linkage) to any of those Program Epics. My company only allows native ...
Hello Community, I'm trying to filter my several tickets and one part of my filter is using ths status of the ticket. However I have one ticket that is appearing in both scenari...
...he date, and the time the comment was posted. I understand that this might be achievable using global automation, JQL (Jira Query Language), or webhooks, but I am unsure of how to implement these m...
In the filter issue query, I would like to see the list of features linked to the Portfolio epic with the relationship "Split to". Currently I can see all the issue linked to the porfolio epic (i...
Hi Community, I try to find within one filter all issues with matches multiple criteria a) If I search for Project = XYZ AND NOT (labels = AAA AND labels = BBB AND labels = CCC) I get som...
I'm seeking assistance in modifying an existing Jira filter to capture a more specific set of issues. The current filter is as follows: project in (XYZ, QWERTY) AND issuetype = Feature AND labels in...
I want to do a JQL search for an exact match to a string and ONLY those characters are in the string. For example, I want to find all issues where the value of the text field MyString = "0" I can...
...ickets in the board , when looking to the backlog feature. 2 - 50 tickets in the board, when looking to the "List" feature. 3 - 61 tickets, when I query them (JQL), based in the associated EPIC. H...
Hi Dear colleagues. We are using Element Connect Configuration plugin in order to get Group Emails from the Active Directory. I have this query and want to display both Group Trees and E...
Hi guys, I am trying to write a quick filter for my Jira KANBAN board that returns all tickets that have an associated sub-task in the In-Progress status. Is it possible to do this without scriptrun...
...bsp; I am looking for these epics are not closed and still in progress before April 2, 2024. What field could I use and what would be query? Thanks
...xecute the following query to search for all issues whose parent is of esc level 1, it works great: issue in childrenOfIssuesInQueryRecursive("'Esc Level' = 1") But when I execute the query to s...
While working with Jira Server I'm having an issue with a webhook when attempting to complete a search. With the query /rest/api/2/search?jql=Parent+Link={{issue.key}} or /rest/api/2/search?j...
Hello, I have a use case in which I have a database that contains the hierarchy of 4 goals, 8 objectives, 15 initiatives, and 51 tactics. I would like to enter the number of a specific tacti...
Hi, I would like to know if there is some DB query in PostgreSQL to get a list of all empty repositories from Bitbucket instance. Another option for me will be to get a list of all r...
our JIRA process is made with ticket which type is "Change Request". each Change Request ticket has subtask that are ticket which type is called "impact". is it possible to make a query a...
in our workflow we have defined tickets with type "PR" and tickets with type "IMPACT" PR tickets are always linked to "IMPACT" tickets. Is there a way to make a search of CR tickets like th...
We recently switched the workflow for the projects, and I'm trying to set the filter to get all the issues types in every current status in a query, but I want to exclude those that was r...
Hello All, I would like to create into another column (the same column I will be creating) a summation formula with these following items grouping by different themes. SUM 1 = 100 + ...
Hi all, in our JIRA XRAY project no defect has to be closed without a linked testrun in status 'passed'. To find out, if there are closed defects without a positive test I tried the following JQL query...
Copied to clipboard