How can I exclude certain issue types using JQL? Example issuetype = ‘Release Infra/Net/Security’ AND project = BTPNCORE AND status changed to COMPLETED during (2023-09-01,2024-12-31) and (L...
Hi Community, I want to hide a custom field (radio type) present on Parent issue based on JQL query, Child filter: project = CHILD AND "Parent Link" = PARENT-XXX AND status != Done when Parent i...
Hey everyone! I have an reminder issue type for annual activities that need to be done annually, these have a date field that I want to flag on a dashboard, but ideally I don't want to keep updating...
We have multiple projects setup in Jira - "Global", "Modernization", etc. These are the projects that represent active work, or active projects. We also have a separate project for the in...
As part of a Dashboard I'm trying to create a filter to show Bugs or Epics that have had their due date changed. I know the WAS IN JQL operator will look at a history, but can it look at a history f...
...ind work items with specific labelled comments? Obviously, scrolling is not the answer. A tailored JQL function is! A dedicated JQL function to filter Jira work items You’re a support agent tasked w...
My board typically has JQL that selects all issues from the project. For example: project = SP However, my team sometimes needs to work on tickets from other projects. Instead of creating a d...
...hildren from tasks or stories. how to filter it? Found something weird... If I remove the "sprint = 1299" from the JQL, I can see all the subtasks from the project include those which are on that s...
Hi Community, I want to write JQL query for Start Date and Close Date so that I can use them in single Jira automation rule. For example: Date format - mm/dd/yyyy Start Date = 01/01/2...
I know we can search by Sprint ID Date range Status (was in, was not, etc) I don't understand why I can't search for all issues that were in a sprint based on the start date (expressed as a dat...
...sing a JQL query. Simply enter your desired JQL, confirm your actions, and you're done. All these are done in 4 easy steps as described below Step 1 Navigate to the BulkOps Pro on y...
G’day Atlassian community! On Oct 31, 2024, we announced the deprecation of several widely used REST APIs in JIRA, namely: GET /rest/api/2|3|latest/search - Search for issues using JQL (G...
In Jira Software, there is a project with an automation to change the assignee. There is a field that, through the script runner, we do not make it editable. It has two options, true or false...
...iraEntityProperties and I did it, so I tested it and it did work, kind of, thats where my problem comes in place. I created an issue, then I set the issue property and tested the jql, and it worked, t...
I was making this JQL filter: project = "DEV" AND issuetype IN ("Story") AND issueLinkType IS NOT EMPTY And I need to add a condition that certifies the type of the item linked to the s...
Hello. Can someone provide a jql query for pulling all subtasks of a certain issue type? In my project Tasks and Stories issue types have subtasks and I'm looking for separate queries to d...
...he overall trends. Issues with the History tab: Using the History tab for too many issues can be inefficient and may affect system performance. JQL Queries Jira Query Language (JQL) helps u...
...eport , but its showing with 6h 30m and estimated is 6h. We are using scriptrunner jql function. The query we are using is, and its showing all the tickets. project = "TEST" AND issueFunction in e...
...he below automation: Current Setup: 1. Trigger: Issue Created. 2: JQL Condition: "Page URL" ~ {{issue.fields.customfield_57501 AND statusCategory != Done AND key != i...
Hi all, Does Jira offer any tool to help an end user (i.e., not an admin) fine-tune their JQL? Let's suppose a complex JQL query composed of a mix of filters, sub-filters, issue functions, AND/OR c...
Dear Community, Does anyone know if and how to access the JQL Query Profile shown to an admin via Java? What we are doing: - find any place in Jira, where JQL is used. For example, f...
My dashboard only has JQL option for filters but I do not know what field names to use
Hello, I got 2 tables: Table 1: T | Key | Summary | Epic Link | Parent Link T can be a Epic. Then it has a Epic Link Or T can be a Story. Then it has a Parent Link. Table ...
Recently i tried to make a filter that shows me the issue progress (The % of subtasks done), but I dont know how to add this type of information. I want this data in my filter: This...
I have created dashboards for the tracking of various types of initiatives - currently the scrum master is spending a lot of time chasing people for updates on their assigned items (yes, I know this ...
Copied to clipboard
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.