Time report with work item
Hi,
We are trying to create a report with the following requirements:
- Time Report per work item (because we need to see the comment for each work item)
- Group by the issue field "Client"
- Displayed columns: default columns plus the custom work item attribute "Billable" (possible values: Yes, No, None)
It appears that it is not possible to display a work item attribute as a column.
If we group by the work item attribute, it is no longer possible to display the issue field as a column and the work item comment at the same time. We can only choose between:
- displaying data per issue (showing the issue field), or
- displaying data per work item (showing the comment).
First, could you please confirm whether it is currently impossible to achieve these requirements using the Time Report?
If so, is there an alternative approach, such as generating the report via the API or using workflows?
Thank you for your help.
Best regards,
Thomas
Please sign in to leave a comment.
Hi Thomas,
You're right, that combination isn't possible right now. The Issue fields setting only shows selected custom field values (like Client) when the report is displayed per issue, not per work item, so it can't appear as a column alongside individual work item comments. And Work item attributes like Billable aren't shown as columns in the report at all. Their values only get included in the CSV/XLSX export if you use them to group the data, which isn't the same as showing them next to each work item. You can check the exact behavior of these settings in the Time Report docs.
There's already a feature request open for showing work item attributes as report columns: JT-70152. Feel free to vote for it, your vote helps us measure feature demand and automatically subscribes you to updates. To do so, sign in to JetBrains YouTrack and click the thumbs-up icon.
Both alternatives you mentioned would work though:
- The REST API's IssueWorkItem entity gives you the work item's text, its attributes (Billable), and its parent issue (where Client lives) all in one response. A query like /api/workItems?fields=text,attributes(name,value(name)),issue(customFields(name,value(name))) returns everything you'd need to build the Client-grouped view yourself.
- Or set up an on-schedule workflow using the search module to pull work items and build the report for you, similar to this example.
Hope that helps!