Have more fun with Kudos
- Collect badges and make progress
- Participate in fun challenges
- Climb up the leaderboard
- Gift Kudos to your peers
Community resources
Community resources
Community resources
Tag: "jql" in "Jira questions"
-
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...
-
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...
-
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...
-
...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 ...
-
We have time entry turned on in Jira Premium. I can take a filter that looks like projects in (list of projects) AND worklogDate >=(startofweek(-1) AND worklogAuthor=(currentuser) to give the lo...
-
How can I find all subtasks within a certain sprint that contain a certain Summary. This seems like a very basic query but the results continue to return nothing. Sprint=381 and issuetype=Su...
-
I want a list of jiras created against each issue type under all the project from jan 2024. I am using below sql but it doesn't return list of those issue types where no jira was created from above m...
-
Setting up a pre-receive hook so that when a pull request is created, if the Jira ticket has a block
...Within the Push check parameter, I enabled: Issue-Key checks - At least one commit must contain a valid issue key. JQL check - At least one issue reference must match the given JQL, and I set t...
