ReferencePairView & ReferencePairMasterView reference

The ReferencePairView and ReferencePairMasterView are 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 the ItemView list of items, and excludes custom attributes from the parent and child items. The ReferencePairMasterView is derived from the ItemMasterView list of items, and includes custom attributes.

The basic SQL statement is SELECT * FROM ReferencePairView

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 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.

ReferencePairView

Column name Data type Record attribute
ItemId ... Notes refer to the ItemView reference parent item standard attributes
ItemId_Child ... Notes_Child refer to the ItemView reference child item standard attributes
Row integer reference Row number
RowNotes string reference row Notes

ReferencePairMasterView

Column name Data type Record attribute
ItemId ...  custom_Member refer to the ItemMasterView column reference parent item standard and custom attributes
ItemId_Child ... custom_Member_Child refer to the ItemMasterView column reference child item standard and custom attributes
Row integer reference Row number
RowNotes string reference row Notes

1180

Learn More
Help Guide Contents [PDF]