I created a JQL but Some issues that are not worked on for today are still appearing

[Fritzie Quizon]

I created a JQL but it seems that there is something wrong. Some issues that are not worked on for today's date are still appearing. This is in Team Board - Timeline.

[Sam Bartolome]

Hi @Fritzie Quizon

Could you provide the JQL and an explanation of your expectations on what it should display?

[Fritzie Quizon]

Here is the JQL

It should only display all the work done in today's date. As you can see on the image i provided above, it still shows other dates like July 12,15 and Aug 5. 

[Sam Bartolome]

I would shorten the query for the update to:

updated >= 2024-08-07 (instead of updated >= "2024-08-06" AND updated <= "2024-08-07"), so this way you guarantee to get the results form today only.

However, your screenshot shows Start and End date which has not been filtered in your JQL and this is where you can get confused or thinking the JQL is not working as expected. You filter by updated date but not by Start or End dat so so display as they are 3 different fields.

You should think how would you like to filter this part, Start date, Due date or both.

If you are filtering using both dates, you can use the below after the assignee string:

"Start" >= "2024-08-07" and "End" >= "2024-08-07"

This will provide issues with a start date and end date for today, both included (note the name of field may be different)

[Fritzie Quizon]

I will try this. Thank you!

[Fritzie Quizon]

Why is some of the tickets are not showing for this specific person? 

Also, I want to ask if there is a way or JQL code to show only the Time Spent for today's date. 

[Sam Bartolome]

Let's start by parts.

Did you get the JQL amended and it is now showing the expected results? Post the JQL please, if any issues.

Is the "specific person" added on the filter as assignee? What do you mean with your question, should the person see more issues?
If so, is there any security level applied to the project? You can inspect the permissions for Browsing on the specific non visible issue and the user.

https://jira.atlassian.com/browse/JRACLOUD-12312, this may answer your last question.

JQL is designed to return Jira issues based on your search. TimeSpent options is the amount of time added (spent) and not if that time was logged today. Yo may be able to achieve that with an app from the Marketplace