Issue Status by Assignee

Owned by Pablo Beltran
Last updated: Jul 22, 2021
1 min read

It allows getting the Time in Status by the assignee in an straightforward way.

ISSUESTATUSASSIGNEES

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.