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
8
votes
1 answer

How to count the number of comments in JIRA

I want to create an Issue Filter that shows me the number of comments per issue, and then sorts by that. I tried something like: project = "myProject" AND created >= 2012-06-01 AND created < 2012-08-01 ORDER BY count(comment) I'm on JIRA 4.2. How…
Huey
  • 2,714
  • 6
  • 28
  • 34
7
votes
1 answer

Jira issues that are in an epic with certain label

I am trying to write a Jira JQL filter that combines parentEpic with a label or a filter. The below JQL works: project=TML AND parentEpic in (TML-2731, TML-3053) But then I need to know the IDs of the epics, and these only live for few…
matth
  • 2,568
  • 2
  • 21
  • 41
7
votes
2 answers

JQL for Finding Open Issues having Linked Issues in status "Done"

I am having an issue named "TEST-5547" which is linked with a development ticket named "DEVP-8978". Here the development ticket (DEVP-8978) is in status="Done". but the main issue "TEST-5547" is in status= "In Progress" which I want to transition to…
MNP
  • 117
  • 1
  • 1
  • 6
7
votes
1 answer

Query/filter to return child issues from a list of active parents (EPICs)

I'm looking for a JQL query/filter to return a list of child issues from a list of active parents (EPICs). For example: "Epic Link" IN linkedIssuesInQuery("issueType = Epic AND Status = 'In Progress'") I was hoping the above query would work, but…
Eric
  • 1,321
  • 2
  • 15
  • 30
7
votes
2 answers

JQL actual "contains"

I want to perform a simple search on a text field with part of its content but I don't know the beginning. I basically want what someone would expect of a "contains search". If I search issue for 345, I would want this result:…
Puck
  • 2,080
  • 4
  • 19
  • 30
7
votes
6 answers

Is there a JIra query which will return all stories without an EPIC?

I'm trying to tidy up our Jira board and create an accurate story map. To do that I need to come up with a query that will return open user stories within a certain project that don't have any issue links (preferably 'related to (primary)')- the…
user3535684
  • 79
  • 1
  • 1
  • 2
7
votes
2 answers

Is it possible to search JIRA for a list of subtasks whose parents are found in a different query?

I have a filter to return a group of parent tasks based on some criteria. I can use this as a group of issues to search further using filter = FilterName What I would like to be able to do is to use this in the parent field search in something…
Conorjpc
  • 71
  • 1
  • 1
  • 2
6
votes
3 answers

JIRA JQL - search for issues where custom field does not exist

I added a new custom field "Deferred to Date". Because custom fields are optional, none of the existing issues have it. Now I want a JQL search query for all issues where the deferred date is null (doable) or the deferred date field doesn't exist…
jonas789
  • 219
  • 1
  • 3
  • 13
6
votes
5 answers

Jira search all issues in a project with status Done or Closed

I am trying to list all isues in a project with status Done or Closed. When I run a JQL-query with advanced search I get: 3096 issues in the project. However when I run it with python I get around 50 issues. #/usr/bin/python import jira.client from…
user3580316
6
votes
1 answer

How to search for JIRA issues NOT in filter

How can I find issues which are not a member of an existing filter? I have an agile board which naturally have a filter. Some issues within our project has been filtered from showing on this agile board and now I want a JQL search that can find all…
Beauvais
  • 2,149
  • 4
  • 28
  • 63
6
votes
3 answers

Filtering issues in next Sprint

I have the following filter to find issues in current Sprint: resolution is EMPTY AND assignee = currentUser() AND Sprint in openSprints() ORDER BY priority DESC, created ASC It works as expected. However, our team creates separate "sprint" (in…
Alexander Tsepkov
  • 3,946
  • 3
  • 35
  • 59
6
votes
2 answers

JIRA Query (JQL) to filter those issues within a certain set of EPICs

I am currently editing the Quick Filters of my Agile project in JIRA. And I need one where I see all the issues from a given set of epics. I am using something like "Epic Link" in (ABC-1, ABC-18) where ABC-1, ABC-18 are my epics. The problem with…
AMM
  • 17,130
  • 24
  • 65
  • 77
5
votes
3 answers

How to search a text field for multiple possible values in JIRA

According to the Atlassian documentation, you can search for words contained in a text field like so: description ~ term It also indicates you can group terms like so: description ~ (term OR "different thing") But when I try that, it shows that…
snollygolly
  • 1,858
  • 2
  • 17
  • 31
5
votes
6 answers

how can get count of rows in hibernate when hql have group by?

I have hql query that have group by .In pagination result i want to get count of all result to show in pagination . In query that donot have group by .I write a utility that create count of query from hql query like this select u from Personel u…
ali akbar azizkhani
  • 2,213
  • 5
  • 31
  • 48
5
votes
1 answer

Custom 'ORDER BY' status in JIRA

Hi I have the following query for my filter: project = BOARD AND status in (Backlog, New, Design, Dev, "Sign Off", Blocked) ORDER BY status ASC I have my board and am stating what statuses it should display and I though it would display it that way…
lovestocodez
  • 57
  • 1
  • 1
  • 5
1 2
3
…
34 35