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

JQL: Show all sub-tasks of stories in current sprint

###Background### I'm using Atlassian's Confluence to make a page where to display our teams subtasks. Subtasks that do not have the status Done will prevent the Sprint from being closed by the Scrummaster. In our case, users do not assign values…
Panatella
  • 31
  • 1
  • 4
3
votes
2 answers

Is there a JQL query that checks if a specific person has updated anything in the Jira ticket from the past week?

I can figure out how to see who it was last updated by, but I'm looking for a list of Jira Tickets that has been updated by someone at any point during the week. Even if someone else updated it afterwards.
Bukimon
  • 31
  • 1
  • 3
3
votes
2 answers

JQL (Jira): Issues containing Sub-tasks assigned to me

How do I query issues that have sub-tasks assigned to me? Resulting issues may or may not be assigned to me but they must contain sub-tasks within them which are assigned to me (currentUser()).
aLL
  • 1,596
  • 3
  • 17
  • 30
3
votes
1 answer

How to write a query in (Jira Query Languange) to restrict issues by week number?

I have the query written in Jira Query Language assignee was brad and status was WIP DURING ("2019/1/20", "2019/1/26") which works but I'd rather write assignee was brad and status was WIP DURING week("2019", 4) which is easier to formulate. Is…
bradgonesurfing
  • 30,949
  • 17
  • 114
  • 217
3
votes
3 answers

Show Sub-task's parent Story on JIRA Dashboard using Filter Query

I have a Kanban Software Project in JIRA Cloud. I use Stories with Sub-tasks to separate different things that have to be done. On a dashboard, I use a Filter Results gadget to show Issues. The Sub-tasks are shown in a format as such: ABC-13 /…
Rein
  • 1,347
  • 3
  • 17
  • 26
3
votes
4 answers

JPA: 'SELECT DISTINCT' with BLOB columns

I'm trying to run this JPQL query: SELECT DISTINCT i FROM Table i JOIN i.other o which promptly fails with: "Internal Exception: java.sql.SQLException: Columns of type 'BLOB' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT,…
Cogsy
  • 5,584
  • 4
  • 35
  • 47
3
votes
3 answers

How to retrieve the summary of a JIRA ticket via REST API?

I am trying to write a shell script, that automates my workflow with JIRA. I aim for something like: jira_flow start $KEY The steps of the script shall be as follows: deploy current project to sonarqube create a new branch according to jira issue…
tgr
  • 3,557
  • 4
  • 33
  • 63
3
votes
2 answers

URL rest api parameter with spaces

I am using the rest API of JIRA to retrieve issues while filtering on the project name and issue type. When I try to use an API call like: String url3 = "jiraURL/rest/api/2/search?jql=project=GB AND issuetype=Requirement&maxResults=1000"; It…
Urban
  • 585
  • 2
  • 13
  • 28
3
votes
1 answer

JQL to search subtasks of not completed stories

I am trying to create a custom search that lets me see the subtasks I touched of tasks that are still not done. I have the two queries sorted out: q1 -> status changed by [username] after -7d q2 -> status != Done I tried status changed by…
ggonmar
  • 760
  • 1
  • 7
  • 28
3
votes
5 answers

JQL to get blocked Issues

Is there a native JQL (not a plugin) that returns tickets that have linked issues listed as "is blocked by" (so I can see all my blocked tickets). All I have found is linkedIssues() but that can require a specific issue ID to search for which is…
Justin
  • 26,443
  • 16
  • 111
  • 128
3
votes
0 answers

Mixpanel JQL returning indexOf is not a function

I have a JQL query in mixpanel which should return result based on two different events. Here are the steps: First event after filtering would return some array of values as result. Second event should use that result and return the required values…
Anudeep Reddy
  • 31
  • 5
3
votes
1 answer

Date math and formatting using JQL

I need to create a JQL filter that uses the current date and subtracts 2 months from it only using FixVersion (String). Is there a way to basically say (this is pseudocode): fixVersion = "'"+(now().month() - "2m").toString()+"_2017"
Fueled By Coffee
  • 2,467
  • 7
  • 29
  • 43
3
votes
2 answers

JIRA: Filter all issues that has subtasks of a particular component

I want to filter out all issues that has subtasks but of a particular component. The following works but it returns all stories with subtasks. project = ABCDEF123 AND issuetype in (Story) and issueFunction in hasSubtasks() I have tried this but it…
munchine
  • 479
  • 1
  • 9
  • 23
3
votes
2 answers

JIRA JQL for query contains does not work with the letter "A"

Here is my JQL : project = XXX AND issuetype = Bug AND status in (Open, 'In Progress', Reopened) and summary ~ '\\\\[A\\\\]' JIRA return no result even I have tickets that contain the text "[A]" in the summary. It only doesn't work for "[A]", if i…
max
  • 613
  • 3
  • 13
  • 26
3
votes
1 answer

Get all JIRA issues that have been worked on in the last X hours

I need a JQL query, that shows me all issues, that have been worked in since X hours. I can find in JIRA, to get all resolved issues in the last X hours resolved >= '-1h' or created created >= '-1h', but don't find any to get those, that have been…
Emerson Cod
  • 1,990
  • 3
  • 21
  • 39
1 2 3
…
34 35