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.
ReferencePairView & ReferencePairMasterView reference
The ReferencePairView and ReferencePairMasterVieware parent-child lists of items and their reference items. The view is a side-by-side set of the parent item attributes; a single child item's attributes; and the parent-child relation attributes of row number and notes. The parent part or document may have zero, one, or many child reference records.
The ReferencePairView is derived from theItemView list of items, and excludes custom attributes from the parent and child items. The ReferencePairMasterView is derived from theItemMasterView list of items, and includes custom attributes.
When a parent item has a pending iteration (that is, the PendingRevID is not null), then its markup row numbers, items, and notes are displayed. When a parent item has only a released iteration (RevID is not null, IsCanceled is false, and thePendingRevID is null), then it displays each current released child iteration (Revision_Child, Lifecycle_Child, etc.) with row numbers and notes. If a child item has a pending iteration, that's shown in separate columns (PendingRevision_Child,PendingLifecycle_Child, etc.) but is not yet assigned to the parent's current configuration. A query that requires the current released parent must test that the parent PendingRevID is null andIsCanceled is false.
The basic SQL statement is SELECT * FROM ReferencePairView
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 |
|---|---|---|
| ItemId ... Notes | see: ItemView columns | parent item standard attributes |
| ItemId_Child ... Notes_Child | see: ItemView columns | child item standard attributes |
| Row | integer | reference Row number |
| RowNotes | string | reference row Notes |
| Column name | Data type | Record attribute |
|---|---|---|
| ItemId ... custom_Member | see: ItemMasterView columns | parent item standard and custom attributes |
| ItemId_Child ... custom_Member_Child | see: ItemMasterView columns | child item standard and custom attributes |
| Row | integer | reference Row number |
| RowNotes | string | reference row Notes |
1180