Spent Time Report Filter options
There is possibility in Spent Time Report now to filter spent time by issues's some fields. In my case, I added some custom fields, and see them in the filter options, for example:
It would be cool, if there would be presented also standart issue's fields like Target Version, Assigne, etc. - all filter options that are presented on Issues tab now:
#1 Updated by Michael Esemplare over 4 years ago
There are some issues with this however.Currently a time_entry has no real reference to some of these. The table holds a reference to:
- date/time spent_on, created, updated
While it is possible to get the information from the issue the time entry corresponds to, that information is volatile data that can be modified when you update the issue. A time_entry is relative to a specific point in time so it needs to capture what ever data it wants persisted.
Unless the OP was talking about querying the issue in the time_entry for its current properties?
I would like to be able to correlate in what version time has been spent on without doing a double query (time_entries between version start date/end date).
Yay or nay adding version to the time_entries table? :)
Just thought about this also, the issue column is nullable, which means there can be time_entries without an issue to query these extra filters off of.
#10 Updated by Jean Louis almost 2 years ago
And it should be usefull to have criteria "greater than to" and not only "greater than or equal to", to have list of issues with spent time greater than zero (and not equal to zero) because there are issues with spent time of 0.2 hour for example, thanks.
#12 Updated by Valdir Stiebe Junior about 1 year ago
I suggest that this issue must be split in two feature requests.
- Add standard issue fields on spent time report filter that use the current value in a group Current Issue's Values; (Maybe easier and fast to do)
- Freeze standard issue fields on time entries on time entry creation with a filter group Historic Issue's Values; (Obviously harder and demands a lot of discussion and definitions)