Description
Permitted status changes per group.
Remarks
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.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | 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 |  |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| TR_PRIMARYKEY | | |
See Also