Issue Status by Assignee
It allows getting the Time in Status by the assignee in an straightforward way.
ISSUESTATUSASSIGNEES | ||||||
|---|---|---|---|---|---|---|
Column | ISSUEID | CREATED | STATUSID | STATUSNAME | INTERVALTIME | ASSIGNEE |
Type | BIGINT | TIMESTAMP | BIGINT | VARCHAR | BIGINT | VARCHAR |
Indexed | x |
| ||||
NOTE: This table reports the detailed history by assignee. Therefore the records are not grouped by assignee if the issue was assigned to the same user more than once during the same status.
I.e: If a issue in some particular status (TO DO) was:
unassigned → assigned to X user → assigned to Y user → unassigned → assigned to X user
then there will be two records ford the X user and also for the null user (unassigned).
In that case, the records have to be grouped by assignee and status to get total by assignee in a status.
Since it is always possible to get the total by assignee using group by, we thought it is better to provide a detailed history of the issue assignments.