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

414 questions
84
votes
8 answers

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this is that Now() is time specific so there is no way…
Shevek
  • 3,449
  • 4
  • 37
  • 60
46
votes
4 answers

JIRA: Searching for all issues with a given link type

Is there a way to query for all issues with a particular link type? For example, let there be a dependency link where an issue can "depends on" another issue. Is there a query to find all issues that depend on some other issue (aka. all issues with…
James An
  • 1,363
  • 1
  • 10
  • 16
32
votes
7 answers

JIRA: Find all issues related to a user

In JIRA, how do a find all issues related to a user, across all projects. A simple query search yields only full text results. i.e. only issues where the name is mentioned and not if the name has been assigned, has reported, has been cc’d etc. My…
Quintin Par
  • 14,646
  • 27
  • 87
  • 142
24
votes
1 answer

JQL: Filter other query

I have a saved query from another user, showing all open tickets of our developers. What I want to do is to filter this query for tickets to me: ticket in (other query) and assignee = currentUser() Is something like this possible in JQL?
Martin
  • 3,510
  • 6
  • 26
  • 46
21
votes
2 answers

How can I view all the JIRA tickets I'm watching?

I clicked watcher for many JIRA tickets, but I can't find a filter that shows me all the tickets I am watching. Can someone direct me to the right link or filter to look.
Mariam P
  • 211
  • 1
  • 2
  • 3
20
votes
2 answers

Jira jql query to search for tickets that status changed to a particular status after a date

I need to filter on tickets that went into status a status of RTT after a particular date. These tickets would be resolved now but I need to see all those that entered that status after a date regardless of their current status.
user2117045
  • 201
  • 1
  • 2
  • 3
18
votes
2 answers

How to find issues added to active sprint in JIRA?

We use corkboard with printed Agile Cards. I would like to be able to create filter in JIRA's Issue Navigator to find issues that were added to the active sprint in the last 24 hours, last 2 days, etc. That way I wouldn't have to manually select new…
beam022
  • 1,623
  • 4
  • 19
  • 26
15
votes
8 answers

JQL: Get list of sprints

Is it possible to get a list of sprints for a particular project ? I know there is a way to find issues by a sprint, but haven't found any way to get all the sprints.
user2445124
14
votes
4 answers

Hibernate/JPA: How to force implicit joins to use LEFT OUTER JOINS

There is a class Offer that has optional relationship to class Article. So that some offers article property holds a null value. If i use the following statement, everything works fine. I got all offers, even those that have no article. SELECT o…
Dangermouse
  • 270
  • 1
  • 3
  • 11
14
votes
4 answers

JIRA API: Get epic for issue

Is there a way in which I could get the epic for an issue ? The api returns a lot of information about an issue, but the epic is not included. I'm using the JIRA REST API (https://developer.atlassian.com/display/JIRADEV/JIRA+REST+APIs).
user2445124
14
votes
4 answers

Jira Quick-filter to show all task with subtasks assigned to current user

Currently, I have a quick filter to show me my task that does this: assignee = currentUser() This works ok, but doesn't show me tasks that are assigned to someone else, but have subtasks assigned to me. Is it possible to make it show me both tasks…
Robert Kovačević
  • 1,178
  • 4
  • 15
  • 23
13
votes
4 answers

How do I query Jira to search for all issues that have been resolved within a length of time from when it was created?

For example, let's say I need to find all issues that were resolved within 1 week's time. I need something like: resolved - created < '1w' Another example: Let's say I have 3 issues: 1) created 2 days ago, resolved 1 day ago. 2) created 5…
Marc
  • 133
  • 1
  • 1
  • 5
12
votes
1 answer

JIRA JQL - Find all subtasks that are open where the parent is closed

I have to do a little sub-task clean-up and wondering if there is an easier solution to do this using JQL. Basically i want to find all sub-tasks that are not closed where the parent of that sub-task is closed. Is this possible? I have tried to…
ziggy
  • 14,901
  • 61
  • 181
  • 273
10
votes
2 answers

Jira query - show cards created between today and minus 14 days from today

I can't seem to find a solution for my query in jira. I wish to only show cards created between today and -14 days from today. I am thinking along the lines of created >= today(-14d) AND created <= today(). I can't seem to use today(-14d) in my…
Samuel Meddows
  • 32,294
  • 12
  • 35
  • 36
10
votes
2 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,664
  • 3
  • 14
  • 23
1
2 3
…
27 28