Help with JQL query for subtasks with a due date less than 2 days

[Raeeq Osman]

Hi everyone,

I'm trying to create a quick filter for my team members to use where you can see a list of subtasks assigned to that person with a due date less than or equal to 2 days.

This is what I had written out but doesn't appear to be working:

assignee = currentUser() AND issuetype = Sub-task AND duedate <= -2d

Greatly appreciate any help!

Best,

Raeeq

[Deleted user]

assignee = currentUser() AND issuetype = Sub-task AND due >= "0" AND due <= 2d

[Raynard Rhodes]

When I converted a basic search into advanced and saw due <= "0" I realize Jira counts negative time.

[Fadoua]

Raeeq,

-2d is looking in the past days you have to have +2d

assignee = currentUser() AND issuetype = Sub-task AND duedate >= 2d

[Raeeq Osman]

Fadoua,

Thanks for responding. Unfortunately, it still didn't seem to work. Please see the screenshots attached.

Pic 1 - I created two test subtasks with due dates of 2/13:

Pic 2 - The jquery filter I set up using what you provided:

Pic 3 - Shows that I received no results after setting up the filter:

Let me know if I set something up incorrectly. Thank you again!

[Fadoua]

ok will check it

[Fadoua]

This is the query:

issuetype = Sub-task AND status in (Open, "In Progress") AND due <= 2d AND assignee in (currentUser())

For Status of course select the ones that you apply to your case

[Fadoua]

Once you select due date in your query, you should see a screen like the following:

[Raeeq Osman]

It still doesn't seem to be working. See screenshot below. When I enter "due" or due date" in my query, the options are what you see below, and I don't see the screen you provided. I wonder if it's because I'm using the cloud version of Jira and if queries have to be written differently?

Thank you for your continued patience and help with this issue.

[Fadoua]

Under the basic screen not the advanced try my query by selecting from the dropdown lists.

For JQL queries, being in Cloud or Server shouldn't be a problem

It is a pleasure assisting you until your issue gets resolved

[Fadoua]

The following is what you will need to use not the advanced link:

[Fadoua]

Click on "More" then type DueDate

You should get a screen like the one I sent you earlier.

[Raeeq Osman]

Perfect! It worked.

Now the issue I'm having though is being able to have the rest of my team members have access to that filter so they can see their own subtasks. We primarily work out of the Backlog page of our project. Is there a way to have the filter viewable from there or where will they need to navigate to in order to use that filter?

[Fadoua]

Great!

Now save your filter by clicking on what I circled in Red:

Then Click "Submit"

[Fadoua]

Sorry I couldn't add more screenshot

Once you click "Submit" on your next screen look at the top by your Filter's name then click on "Details" like the following screen:

Your screen should look like the following:

The Subsequent is what you should see:

[Fadoua]

Add shares is where you can decide who to share the filter with.

You can also add the quick filter to your backlog by "configuring the board". You can add the JQL query on the following screen:

Let me know how it goes or if you need additional assistance.

[Raeeq Osman]

So I copied the query from here (it works when I use it here):

Picture 1:

Then pasted it into a Quick Filter query:

Picture 2:

But when I go to the Backlog to select the Quick Filter, I don't see any results:

[Fadoua]

You mean when you click on "My Sub-tasks - Due Date < 2d" it doesn't display anything? Because you have to select it in order to see the issues on the backlog

[Raeeq Osman]

The last picture is the results after I already selected the filter.

[Fadoua]

I know it may sound silly did you make sure that you copied everything from the JQL query?

[Raeeq Osman]

I thought I made that mistake too! But I actually made sure to resave it again just now with the full query copied over and it still doesn't work.

This is a lot to ask but could you try copying this query and creating a Quick Filter for yourself? And also create some test stories with sub-tasks underneath and the due date as either 2/15 or 2/16?

Query:

issuetype = Sub-task AND status in ("In Progress", "To Do") AND due >= 1d AND due <= 2d AND assignee in (currentUser()) ORDER BY updated DESC

[Fadoua]

Ok I will try it. It is a pleasure assisting you with this issue. Sorry yesterday wasn't feeling well. Logged off early.

[Fadoua]

I did create a filter and created Sub-tasks as well with Due Dates 2/16 and 2/17. Below is my JQL query

issuetype = Sub-task AND status = "In Progress" AND due <= 2d AND assignee in (currentUser()) ORDER BY updated DESC

I named my Quick Filter: Due within 24 Hours and it worked

[Fadoua]

Are your Sub-tasks already added to an active sprint?

[Raeeq Osman]

So it appears that when I'm under the "Active Sprints" tab, the filter does appear to work and shows the two sub-tasks I created.

Picture 1:

However, when I'm in the "Backlog" tab and try using it, then the filter doesn't seem to work, which I guess isn't that big of a deal. Maybe there's some kind of system issue not allowing the filter to work in that tab.

Picture 2:

I even tried creating a very basic filter to just show me all Sub-tasks (issuetype = Sub-task) in the Backlog and that didn't work either. So I think the problem might be just the Backlog being unable to show Sub-tasks because the filter worked when I changed it to show other issue types (Bug, User Story, Epic, Task).

Picture 3:

So really it's not that big of an issue. I can just let my team members know to use the filter in the Active Sprints tab, whenever we start a new sprint.

[Fadoua]

Actually Sub-tasks don't show on a backlog if that will help. JIRA doesn't work that way there is a turn around I can find it for you because i did it in the past but it wont show details about the sub-task