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
5
votes
3 answers

Filter issues updated by particular user in period of time using JQL

Is there any way to find all issues updated by particular user in particular time period in every day by using JQL or is there any plugin to solve this?.
Nuwan
  • 1,226
  • 1
  • 14
  • 38
5
votes
2 answers

JIRA JQL select issues where issuekey contains key

I can select JIRA issues using this JQL query: issuekey >= PRJ-23 results: PRJ-23 PRJ-24 ... PRJ-2345 ... How can I select JIRA issues using "contains-like" operator? Smth. like: issuekey contains…
Alex Gusev
  • 1,526
  • 3
  • 16
  • 35
4
votes
2 answers

How to get specific assignee of a story, subtask with a specific summary in JIRA?

I am using JIRA version v8.5.9, where I am running the following query in its search option. issuetype = "Sub task" AND assigned == 'xyz' and summary = '16.4' Where xyz is a user. Basically what I am trying to achieve is: I am looking for all…
IT hero
  • 77
  • 4
4
votes
1 answer

Angular Querybuilder in a single textbox with auto suggestion of next query

I'm planning to build a query builder using Angular The feature is like to have a textbox which keep autopopulating the suggestions [Field + Operator + Value] + (Keyword) + ... Eg - Name = 'Technosaviour' OR Age > 2 The autocomplete should give…
Biswakalyan
  • 145
  • 1
  • 1
  • 9
4
votes
1 answer

Jira JQL - Show all child tasks

I am trying to display all my tasks under 3 levels of Macro-Feature and/or Epic Link, as my organization look like this : Macro Feature Epic Link (= feature) => Epic Link (= subfeature) => Tasks or directly Epic Link => Tasks I want to see both…
andrea06590
  • 1,259
  • 3
  • 10
  • 22
4
votes
2 answers

Jira query to return issue status in a specific date using resolution date

I am trying to run a query using a resolution date and retrieve a list of results with the actual status according to the resolution date. When running this query today, I receive a list with the resolved bugs while I would like to know if they were…
EpsilonTal
  • 437
  • 4
  • 20
4
votes
1 answer

JQL: Find the latest closed sprint

How can I find the last closed sprint?I tried using ORDER BY updatedDate DESC but this returns all the closed sprints. I need only the latest one.
eureka19
  • 2,731
  • 5
  • 26
  • 34
4
votes
2 answers

JPA: Differences between JQL and SQL

I need just an answer to a very specific question: For example: Customer c =(Customer) manager.createQuery("SELECT c FROM Customer c").getResultList().get(0); This code works because of the use of the Java Persistence Query Language. Customer c =…
f4lco
  • 3,728
  • 5
  • 28
  • 53
4
votes
2 answers

JIRA JQL: search all issues where two fields have identical value

At our company we have a custom field in our JIRA that tracks who verified an issue (it is a single user selector). Now I would like to find all issues that are assigned to and verified by the same person. I tried this JQL project = OURPROJECT AND…
reto
  • 85
  • 1
  • 8
4
votes
2 answers

How to filter resolved tasks that were "In Progress" and assigned to the current user

I'm looking to make a JIRA filter to get a list of resolved tasks that I have worked on. Currently I have the following: resolution = Fixed AND assignee was currentUser() AND status was "In Progress" ORDER BY resolutiondate DESC But really I'm…
Samuel Parkinson
  • 2,992
  • 1
  • 27
  • 38
4
votes
2 answers

Query JIRA versions using wildcards with JQL

Is there a way to search a field with wildcards? I have two fields and I just want names starting with DEVX. I have tried quotes and asterisks, like "DEVX*". Is there a way to do it in this query? These are custom fields of type Version Picker with…
Gary Seven
  • 109
  • 1
  • 1
  • 7
4
votes
1 answer

JIRA: Find all issues that were at some point assigned to user while in specific status

I am looking for a query that lets me search through JIRA for all issues that belonged to a user at any point while in a specific status. For example, say that when work is finished, issues get set to a "Code Review" status and assigned to user X…
bengoesboom
  • 2,119
  • 2
  • 23
  • 27
3
votes
2 answers

JIRA JQL: How to search on issues closed before a time in the day?

I want to search for issues closed since 10am yesterday. startOfDay("-1d") only gets me from 8am... how do I tack on the last couple of hours?
David Parks
  • 30,789
  • 47
  • 185
  • 328
3
votes
1 answer

JQL search: figure out list of distinct projects for a given text search

I am doing a search in Jira and I would like to know the names of the projects satisfying my JQL search. I am performing the following search: The problem is that there are hundreds of issues that satisfy this text search belonging to the same…
Mouna Camelia Hammoudi
  • 596
  • 1
  • 5
  • 19
3
votes
2 answers

Results of running two subqueries do not add up to the number of results when running the main query

I am running a JQL query to count how many issues have an empty value for the "Components" field versus how many issues have a non empty value for the "Components" field. Here is the screenshot that I get for my 1st JQL query: category = "Cloud…
Mouna Camelia Hammoudi
  • 596
  • 1
  • 5
  • 19
1 2 3
…
34 35