This topic is contained in the PDXpert help file: select Contents from the application's Help menu.
ChangePairView & ChangePairMasterView reference
The ChangePairView and ChangePairMasterView are parent-child lists of all changes, as well as items on their Affected list. The view is a side-by-side set of the change form attributes; a single affected item's attributes; and the change/affected item relation attributes for released and canceled revisions. The parent change form may have zero, one, or many affected item child records, which determines the number of rows in the view.
The ChangePairView is based on the ChangeView and ItemView lists, and excludes custom attributes from the change form and affected items. The ChangePairMasterView is derived from the ChangeMasterView and ItemMasterView lists, and includes custom attributes.
Column definitions
There may exist in the view one or more "housekeeping" columns that have been reserved for PDXpert's private use. These columns' names begin with the prefix HK (for instance, HK1). Housekeeping columns may be redefined or eliminated in a future PDXpert release without notice. These will not be documented, and you should ignore these columns in your own SQL queries. Do not create any custom attributes that use the HK prefix. You may want to create a user-defined view that excludes the housekeeping columns.
The column ordering may not be exactly as shown in this table, and may change in a future PDXpert release. Use the column name, not ordinal position, in your SQL queries.
ChangePairView
| Column name | Data type | Record attribute (note 1) |
|---|---|---|
| ItemID ... Notes | refer to the ChangeView reference | change form standard attributes |
| ItemId_Child ... Notes_Child | refer to the ItemView reference | affected item standard attributes |
| LineNumber | integer | affected item row number |
| ReleaseRevision | string | if affected item was released: new revision identifier |
| ReleaseLifecycle | Lifecycle Name | if affected item was released: new revision's lifecycle |
| CancelRevision | string | if affected item was canceled: old revision identifier |
| CancelLifecycle | Lifecycle Name | if affected item was canceled: old revision's lifecycle |
ChangePairMasterView
| Column name | Data type | Record attribute (note 1) |
|---|---|---|
| ItemId ... custom_Member | refer to the ChangeMasterView column reference | change form standard and custom attributes |
| ItemId_Child ... custom_Member_Child | refer to the ItemMasterView reference | affected item standard and custom attributes |
| LineNumber | integer | affected item row number |
| ReleaseRevision | string | if affected item was released: new revision identifier |
| ReleaseLifecycle | Lifecycle Name | if affected item was released: new revision's lifecycle |
| CancelRevision | string | if affected item was canceled: old revision identifier |
| CancelLifecycle | Lifecycle Name | if affected item was canceled: old revision's lifecycle |
1178
Help topics describe the most current PDXpert PLM software release, and may differ from earlier releases.
