Stack Overflow
Stack Overflow

Questions tagged [jql]

JIRA Query Language (JQL) is used to perform advanced searches within JIRA.

JQL allows users to perform an advanced search using structured queries within JIRA. JIRA is a issue tracking product, developed by Atlassian, used for bug tracking, issue tracking and project management.

A simple query in JQL (also known as a 'clause') consists of a field, followed by an operator, followed by one or more values or functions. For example, the following simple query will find all issues in the "TEST" project:

project = "TEST"

References

522 questions
13
votes
4 answers

Custom sort order of jira workflow statuses in a filter using JQL

I know you can change the order statuses are displayed by admin > issues > statuses and sort order but I'd prefer to order the results in my jql with certain statuses at the top and a specific order. Is it possible to order how statuses appear in a…
yoshiserry
  • 20,175
  • 35
  • 77
  • 104
13
votes
3 answers

How to filter for last working day in Jira JQL

We use Jira Agile with a "Daily Scrum" board which filters for issues due in the last day. This will show us the issues we should have fixed yesterday and the issues we will fix today. This works great, except for Mondays. On Monday we want to see…
Frank Groeneveld
  • 1,794
  • 3
  • 16
  • 23
12
votes
4 answers

JIRA JQL - Find issues with more than X days in Status

I want to show all issues where it has been in a current status for more than X days - is this possible? We have this workflow: Registered => Analyze => Planned ... etc. The ticket can be in Registered for 3 weeks and it can be 3 weeks in Analyze…
Beauvais
  • 2,149
  • 4
  • 28
  • 63
10
votes
3 answers

filter to retrieve all the JIRA issues where I was mentioned in the last 7 days in a comment

I'm trying to setup a JIRA filter to find all the mentions of me(currentUser()) in the last 7 days. I'm close with the search below, but it still gives me all issues that mentioned me AND were updated in the last 7 days. Which is a lot more. :) I…
Christina
  • 1,389
  • 1
  • 11
  • 12
10
votes
4 answers

Jira JQL that returns date of status change

I'm trying to use JQL to measure cycle times (the Control Chart has other issues), so I need to get the date that an issue changed status. I see that one can use the CHANGED keyword to filter issues that have changed status on certain dates, but I…
ScottEdwards2000
  • 15
  • 1
  • 8
  • 21
9
votes
3 answers

List all JIRA tasks that are not blocked by other tasks

Using JIRA 4.4.3, I've created a filter that list all the tasks that: - The current user is assigned to; - are Open; - are not blocked by any other task. To make it clear: the task that are ready for a user to work on. We've installed the Craftforge…
FMaz008
  • 11,161
  • 19
  • 68
  • 100
9
votes
1 answer

Querying JIRA to Produce Counts of Issues by Different Type

Suppose I have the following JIRA filter. project = XXX AND resolution = Unresolved AND assignee in (EMPTY) ORDER BY Type asc, priority desc I use it to see all unassigned issues in a certain project and pull from for triage. Every now-and-then, I…
MadPhysicist
  • 5,401
  • 11
  • 42
  • 107
9
votes
6 answers

JQL to retrieve all stories and sub tasks related to specific epic

Is it possible to use raw JQL (not using any plugins) to filter for ALL stories AND their respective sub-tasks? Currently, I have the following which successfully retrieves all stories for EPIC-123: project = PROJ1 AND "Epic Link" = EPIC-123 AND…
pele88
  • 802
  • 2
  • 8
  • 16
9
votes
1 answer

JIRA JQL: coloring cards by blocked status

I'm trying to use the "Card colors" feature of JIRA Agile, plus the ScriptRunner plugin, to color blocked cards on a JIRA agile board. My definition of "blocked" is: ticket has a value for the "Blocked" field or is linked to an unresolved ticket in…
yolfer
  • 95
  • 1
  • 8
9
votes
5 answers

JIRA JQL: Issues resolved in the current sprint

I would like to be able to filter for issues that are have been resolved in the current sprint. Generally this would be used to prevent issues resolved in a previous sprint but delayed in testing (not reopened) showing up when we are discussing what…
Inductiveload
  • 6,094
  • 4
  • 29
  • 55
9
votes
3 answers

JQL for "Issues added to sprint after start time"

In the sprint report jira reports that any issue with a * on it has been added after the sprint started. How can i get the JQL for that?
Pratik Khadloya
  • 12,509
  • 11
  • 81
  • 106
9
votes
2 answers

JIRA jql Query - what * means?

There is no regexp in JQL: https://answers.atlassian.com/questions/138055/how-can-i-use-regex-in-a-jql-query-i-cannot-match-strings-that-have-a-specific-ending-in-jql-ex-ing-should-match-running-jogging-etc What is the meaning of * in a jql Query?,…
nagy.zsolt.hun
  • 6,292
  • 12
  • 56
  • 95
8
votes
4 answers

How to make a JQL query for issues with multiple components

I'd like to query all issues in JIRA that are associated with more than 1 component. Is that feasible in JQL, and how?
Antoine
  • 5,055
  • 11
  • 54
  • 82
8
votes
3 answers

How do I query for issues in JIRA that have a specific label and only that label?

I have a label in JIRA, say Foo. I want to query for all issues that have that label and that label only. How do I do that? I've tried labels = Foo AND NOT(labels NOT IN (Foo)) but that returns issues labelled Foo and Bar as well. I want the issues…
SQB
  • 3,926
  • 2
  • 28
  • 49
8
votes
3 answers

JIRA On-Demand Querying by parent

I'm using the On Demand version of Jira. I need a filter that will show me: All issues within a particular epic AND all sub tasks of those issues. So effectively: Epic Story 1 Sub Task 1 Sub Task 2 Defect 1 Story 2 Sub Task 3 Sub Task…
Paul Fleming
  • 24,238
  • 8
  • 76
  • 113
1
2
3
…
34 35