This topic is contained in the PDXpert help file: select Contents from the application's Help menu.

FilePairMasterView reference

The FilePairMasterView is a parent-child list of all items and the database properties of their file attachments. The view is a side-by-side set of the parent item attributes; a single file's name, Size (bytes), and AddedOn date. The parent item (for example, a document object) may have zero, one, or many file records, one per row.

The database row contains only the file attachment's database properties. It is not the actual file object, which is not contained within the database.

The FilePairMasterView is derived from the ItemMasterView list of items, and includes custom attributes.

The basic SQL statement is SELECT * FROM FilePairMasterView

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.

FilePairMasterView

Notes:

1. To ensure uniqueness, PDXpert assigns a separate alias filename when the file is copied into the library folder. The alias filename is not available in this view.
2. Value is null when FileList is External

1179

Help topics describe the most current PDXpert PLM software release, and may differ from earlier releases.