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 t...

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-12...

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 Regis...

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, ...

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...

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...

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...

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 orde...

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 "d...

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.

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 ...

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 issue...

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)...

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 g...

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 f...

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-...

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 3...

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 = currentUse...

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.atlas...

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.

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 i...

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 Progr...

I need to filter issues whose title (Summary attribute?) contains a text "config". So what I did is: More->Summary Enter the text "config" But for some reason I only got issues whose title cont...

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 is...

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 pr...