It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Display today/yesterday's workerd issues and Tomorrows planned issues

dhaval soni Oct 07, 2012


In Jira, I want to list (or see) the issue for each developer on daily basis as below :

- List the Yesterday's worked issues

- List the today's worked issues

- List the tomorrow's planned task to work on.

Can you please let me know, how to get such information and what are the parameters require to fill up by each developers or any configuration changes.

Thank You

3 answers

1 accepted

2 votes
Answer accepted
Jacques Oct 07, 2012

You could use these "advanced searches" (clicking the "advanced" option in the search page):


updatedDate >= startOfDay() and updatedDate < endOfDay()


updatedDate < -1d AND updatedDate > -2d ORDER BY updatedDate asc

Although this basically counts -24 hours, since UpdatedDate includes timestamp. So you also might see items from the day before yesterday.

tomorrow: Is a somewhat difficult concept if you have no due dates set on your issues.

dhaval soni Oct 08, 2012

Thank You for the comments. It will help.

I want Today/Yesterday/Tomorrow's task filter for each user.

Example: Jack's yesterday/today/tomorrow's task list

Alex's yesterday/today/tomorrow's task list

By your above comments, I can get related task, Now, I want to filter for each user.

If I could have "Updated By" field in advance/simple search then it would be possible becuase, Then i can add "Update By" field in advance search query but this field, i could't find in search parameters.

Please let me know your comments.

Other thing:

We will have due date field updated for each issues then, How can we trap tomorrow's Task as you mentioned in your last comments.

Please let me know on this as I need each developer's Tomorrow's planned task list.

Thank You

Alexander Fedtke Jun 09, 2016

For tomorrow we use due > now() AND due <= 2d

Paul Wilkinson Nov 15, 2017 • edited

If you only wanted to capture issues that closed in the previous working day and not a rolling 24 hours  try something like updatedDate < -12h AND updatedDate > -36h. Or something like that.

0 votes
Jobin Kuruvilla [Go2Group] Community Leader Oct 07, 2012

If they are entering the worklogs, you can use JQL Tricks Plugin (paid) to get issues where work was logged on a specific date (using relative dates like -1d as well).

Fot tomorow's planned work, this won't work but you can probably list the assigned issues which are pending!

dhaval soni Oct 09, 2012

I have also used JQL plugin and all issues has work log updated on daily basis.

I can get the yesterdays' task . But it is not particular for specific user. It gives me all updated tasks which belongs to all users.

I need yesterday's issues updated by specific user. (Updated in sense of , any status update or comments added over the issue or work log added over the issue.)

Please let me know your comment.

Thank You.

dhaval soni Oct 10, 2012

Closing this ticket as logged another ticket for this new question mentioned in last comments for retrieving specific user's worked task.

New ticket:


Jobin Kuruvilla [Go2Group] Community Leader Oct 10, 2012

I missed you comment in yesterdays mail flood. You can provide the username also in the queries to limit the worklogs specific to a user. Did you try that?

dhaval soni Oct 11, 2012

its ok.

Can you please tell me which parameter i have to query to retrieve user specific work log.

it would help if you can paste query for that.

Thank You

dhaval soni Oct 11, 2012

I couldn't find such parameter.

It would really helps if you can paste the query which list the issues where user worked on or commented at yesterday.

Thank You.

Jobin Kuruvilla [Go2Group] Community Leader Oct 11, 2012

Which version of the plugin are you using? In the latest version, you can try this:

issue in workLoggedOn("-1d","username")

where username is the user's name.

dhaval soni Oct 11, 2012


Thanks for the comment.

it is not existed in my JQL parameter list. Is there require to add some additional plugin to achieve this? I will check my jql version.

Please share the plugin link which provides this parameter if other then JQL and , Is it free or paid.

I also want to get user's yesterday tasks where user has not logged the work but logged the comments. which field should i use to query yesterdays' commented issues ?

another thing, Is it possible to get daily summary or filtered result bit informative as below:

Developer 1 yesterday tasks:

=> commented issues (shows that developer has commented)

=> logged worked issues (shows that develooper worked on these issues)

(suppose, if possible to group or highlight what issues are Fixed by developer and what are still in progress & logged the works)

Please share your comments.

Thank You

Jobin Kuruvilla [Go2Group] Community Leader Oct 11, 2012

look like you never had the plugin I was talking about installed. I was talking about a paid plugin (see my original answer). Here is the link.

dhaval soni Oct 11, 2012


if possible to achieve the function of "workLoggedOn" parameter through default JQL parameter as currently, "workLoggedOn" does not appear in my query parameters, then please share its filter query.


0 votes
Ferran Poveda Mar 01, 2016

If you log your work, you can use:

<...> AND worklogDate = -1d AND assignee was currentUser() ORDER BY updatedDate ASC

Alternatively, even it isn't perfect, you can use this more generic filter (for finished things):

<...> AND status changed before -1d AND status changed after -2d AND status was <your "in progress" status> AND assignee was currentUser() ORDER BY updatedDate ASC

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira

Try Jira Cloud for Outlook: Organize your work without leaving your inbox

Hi Atlassian community, My name is Max and I work on the product integration team at Atlassian. I am pleased to announce the early access program for the Jira Cloud add-in for Outlook. This add-in...

1,652 views 3 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you