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; } } }

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

dhaval soni1

Hi,

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

Accepted answers

Jacques

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

today:

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

yesterday:

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.

All comments

Jobin Kuruvilla [Adaptavist]

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!

Jacques

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

today:

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

yesterday:

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 soni1

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

dhaval soni1

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 soni1

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

New ticket: https://answers.atlassian.com/questions/94459/yesterday-s-added-worked-log-tasks-or-resolved-inprogress-status-updated-tasks-by-specific-user

Thanks

Jobin Kuruvilla [Adaptavist]

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?

Ferran Poveda

If you log your work, you can use:

<...> AND worklogDate = -1d <code>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

Alexander Fedtke

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

Paul Wilkinson

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.

Welcome!

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

Quick Links

Find more posts tagged with

jira

filter

dashboard