Daily Report

Question

i have asked my scrum team to update what was done during their day on a specific story.

Now i want to comb my project and create a report to show me what each team member in that project did (comments) in the last 24hrs ordered by labels (project streams).

for eg., I tried this but i am not able to get comments seen in my report which were updated but only the story number in general

project = V AND Sprint in openSprints() ORDER BY assignee, priority DESC, updated DESC

Aron Gombas _Midori_ · Answer

You can use the JQL query you posted with the Better Excel Plugin and its template that exports the selected issues from the Issue Navigator plus all comments of each issue.

This will give you exactly the view you want (and you can customize the columns simply by selecting those in Issue Navigator):

Jack Brickey · Answer

I concur w/ Danyal here. It is much better to enforce time logging and track progress in that way. Comments are simply too subjective and unpredictable since some user will ramble, some will be vague and some simply want comment. Of course, one could make a similar argument about time logging but IMO it is more easily adopted an consistent given time.

Danyal Iqbal · Answer

You cannot see comments with JQL. You can use the activity stream API to monitor daily comments per user per project e.g rest call to activity?streams=user+IS+dvds

or /activity?os_username=user&os_password=pass

for an authenticated stream or use a feed reader or outlook to do the filtering BUT...

A daily report is a bad practice esp. when your analysis is based on comments.

Your team will disintegrate and very soon you will be the only one making all the comments.  I beg you to reconsider.