PDXpert PLM Software
On-line Help Guide
This help topic describes the current PDXpert PLM release. Earlier releases may be different. To view your release's version of this topic, open PDXpert and press the F1 key or select the Help menu.
ChangePairView & ChangePairMasterView reference
The ChangePairView and ChangePairMasterVieware parent-child lists of all changes (parent), as well as items on theirAffected list (child). 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 iterations. 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 theChangeView and ItemView lists, and excludes custom attributes from the change form and affected items. TheChangePairMasterView is derived from theChangeMasterView and ItemMasterViewlists, and includes custom attributes.
The affected item always reflects the most current item data, as obtained from the ItemViewand ItemMasterView lists. Therefore, only the most recent change pairs indicate the affected item's current iteration; earlier change pair views accurately reflect the items (class, owner, type, number, etc.) that were affected, but not the actual iteration that was released or canceled. To obtain non-current change data that includes the actual released or canceled iterations, use a custom SQL query based on the[AffectedItem_View] and related non-public views.
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 are not 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.
| Column name | Data type | Record attribute (note 1) |
|---|---|---|
| ItemID ... Notes | see: ChangeView columns | change form standard attributes |
| ItemId_Child ... Notes_Child | see: ItemView columns | affected item standard attributes |
| LineNumber | integer | affected item row number |
| ReleaseRevision | string | if affected item was released: new iteration's revision identifier |
| ReleaseLifecycle | Lifecycle Name | if affected item was released: new iteration's lifecycle |
| ReleaseNote | string | if affected item was released: new iteration's Release description |
| CancelRevision | string | if affected item was canceled: old iteration's revision identifier |
| CancelLifecycle | Lifecycle Name | if affected item was canceled: old iteration's lifecycle |
| CancelNote | string | if affected item was canceled: old iteration's Release description |
| Column name | Data type | Record attribute (note 1) |
|---|---|---|
| ItemId ... custom_Member | see: ChangeMasterView columns | change form standard and custom attributes |
| ItemId_Child ... custom_Member_Child | see: ItemMasterView columns | affected item standard and custom attributes |
| LineNumber | integer | affected item row number |
| ReleaseRevision | string | if affected item was released: new iteration's revision identifier |
| ReleaseLifecycle | Lifecycle Name | if affected item was released: new iteration's lifecycle |
| ReleaseNote | string | if affected item was released: new iteration's Release description |
| CancelRevision | string | if affected item was canceled: old iteration's revision identifier |
| CancelLifecycle | Lifecycle Name | if affected item was canceled: old iteration's lifecycle |
| CancelNote | string | if affected item was canceled: old iteration's Release description |
1178