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

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

I'm using the On Demand version of Jira. I need a filter that will show me: All issues within a particular epic AND all sub tasks of those issues. So effectively: Epic Story 1 Sub Task 1 Su...

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

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

In the sprint report jira reports that any issue with a * on it has been added after the sprint started. How can i get the JQL for that?

I'm trying to setup a JIRA filter to find all the mentions of me(currentUser()) in the last 7 days. I'm close with the search below, but it still gives me all issues that mentioned me AND were upda...

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

There is no regexp in JQL: https://answers.atlassian.com/questions/138055/how-can-i-use-regex-in-a-jql-query-i-cannot-match-strings-that-have-a-specific-ending-in-jql-ex-ing-should-match-running-jo...

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

I would like to be able to filter for issues that are have been resolved in the current sprint. Generally this would be used to prevent issues resolved in a previous sprint but delayed in testing (...

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

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

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

Using JIRA 4.4.3, I've created a filter that list all the tasks that: - The current user is assigned to; - are Open; - are not blocked by any other task. To make it clear: the task that are ready...

I'm trying to use the "Card colors" feature of JIRA Agile, plus the ScriptRunner plugin, to color blocked cards on a JIRA agile board. My definition of "blocked" is: ticket has a value for the "Bl...

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

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

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