ALM Project Database Reference
td.TRAN_RULES Table
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
Related Objects