nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Running JQL Query - Updated Date not filtering

Kaitlin Meehan

Good evening,

I am trying to run a query for activty, when I select "Worked on" feature per person, I am trying to update the JQL query to show only those items within the last 24 hours. I used this:

assignee in (5c98dcd1*****01c20dc37) AND updated = endOfDay(-1) OR reporter in (5c98dcd1*****01c20dc37) OR creator in (5c98dcd1*****01c20dc37) ORDER BY updated DESC

**** just for protecting data, not actually in query

However, the results are not changing. Can someone help me figure out what is wrong with the JQL that I am using?

Thank you!

Accepted answers

All comments

Bhav Makwana

Have you tried "updated < endOfDay ( )" since that should show those updated by the end of the current day?

Find issues due by the end of today:
due < endOfDay()
Find issues due by the end of tomorrow:
due < endOfDay("+1")

Bhav Makwana

Evening, have you tried "updated < endOfDay()" since that should display the results for the given day?

Find issues due by the end of today:
due < endOfDay()
Find issues due by the end of tomorrow:
due < endOfDay("+1")

Bill Sheboy

Hi @Kaitlin Meehan -- Welcome to the Atlassian Community!

Please try updating your query for the updated check to use >= rather than =

... AND updated >= endOfDay(-1) ...

Also, the placement of your OR statements may not be what you are seeking. Are you really looking for things which were reported by a specific person, regardless of update time-frame? If not, please try this:

( assignee in (5c98dcd1*****01c20dc37)
  OR reporter in (5c98dcd1*****01c20dc37)
  OR creator in (5c98dcd1*****01c20dc37) )
 AND updated >= endOfDay(-1)
 ORDER BY updated DESC

Best regards,

Bill

Kaitlin Meehan

Hey Bill,

Thank you so much! So how it has been requested to track activity for my team is tasks we not only created but also listed as a watcher. I believe reporter and creator would be the same thing, but watcher is important because if we made a comment that is not tracked by reporter or creator in activty from my understanding.

I tried the order and with >= as well :

assignee in (5c98dcd167af62601c20dc37) OR reporter in (5c98dcd167af62601c20dc37) OR watcher in (5c98dcd167af62601c20dc37) AND updated >= endOfDay(-1) ORDER BY updated DESC

and I am still getting over 1000+ results, which I know I haven't done that many in a day haha.

Thank you again for your help!

Kaitlin Meehan

Hey Bhav! Thank you for helping out! I tried them both and it is still resulting in 1000+ tasks. Not sure if maybe it is just how we are utilizing JIRA in my company.

2021-04-07 19_45_04-Issue navigator - JIRA.png 2021-04-07 19_46_50-Issue navigator - JIRA.png

Bill Sheboy

Hi Kaitlin,

You are missing a set of parenthesis around the user checks. Without those, JQL is assuming something like this;

assignee IN (...) OR reporter IN (...) OR

( watcher IN (...) AND updated... )

What you may want is, noting the bold parenthesis I added:

( assignee IN (...) OR reporter IN (...) OR watcher IN (...) ) AND updated...

Yuliia_Borivets__SaaSJet_

Hi @Kaitlin Meehan

If you won't find a solution with JQL, you can try Dynamic Filters: JQL Replacer add-on. It's created by my team to simplify database queries. Here is an example:

1. Set data you need with the help of visual composer.

2. Choose the required date or time: 1 day.png

3. Select the created Smart Fields to display the result:

Hope you find the best option for you.

Regards

ldevore

I am facing this same issue

ldevore

My query should only be returning this from feb 16th, but it is instead returning thousands of things not from this date. Am I doing something wrong? Screen Shot 2022-02-17 at 9.11.16 AM.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

jql