Permitted status changes per group.
This table defines permitted changes from one status to another by group. For example, TR_TABLE_NAME is BUG, TR_FIELD_NAME is BG_STATUS, TR_GROUP_ID is 1, and TR_RULES is Open,FixedReopen,FixedOpen,RejectedReopen,Rejected. This means that members of group 1 can change a defect status from Open to Fixed, from Reopen to Fixed, from Open to Rejected, and from Reopen to Rejected. All other status changes are denied.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
![]() | TR_TABLE_NAME | The table containing the field to which the rule applies. | varchar | 40 | ||
![]() | TR_FIELD_NAME | The field to which the rule applies. | varchar | 40 | ||
![]() | TR_GROUP_ID | The GROUPS.GR_GROUP_ID of the group to which the rule applies. | int | 4 | ||
TR_RULES | One or more allowed transitions. The initial value (or $ANY) is separated by a comma from the permitted target value. There is no separation between a target value and the initial value of the next permitted transition. | varchar | 16 | ![]() |