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.
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.
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.
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.
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.
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!
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.
Closing this ticket as logged another ticket for this new question mentioned in last comments for retrieving specific user's worked task.
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?
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.
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.
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.
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
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...
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