|
Quality Center Database |
|
|
Quality Center Database |
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 |
|
|---|---|---|---|---|---|
 |
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. | Integer | 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. | LongVarChar | 16 | 
|
| Index | Primary | Unique |
|---|---|---|
| TR_PRIMARYKEY |
|
|
Copyright 2002-2007 Mercury Interactive Corporation. |
|
Documentation comments or suggestions? Please send feedback to SW-Doc@hp.com |