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.
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 FilePairMasterView 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 revision files are displayed. A parent item that has only a released iteration (RevID is not null, IsCanceled is false, and thePendingRevID is null) displays each current released revision file. A query that requires the current released parent must test that the parent PendingRevID is null andIsCanceled is false. The complete set of item files and external links is always displayed.
The basic SQL statement is SELECT * FROM FilePairMasterView
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.
This view is also contained in the local views database. Client-side ODBC applications can select from this view and from SQLite-compatible Views collection members based on this view.
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 |
| FileList | string: Item,Revision, External | list that contains file attachment |
| Filename | string | original file name, as seen in the PDXpert client's file list |
| LibraryName | string | physical file name (notes 1, 2) |
| Size | integer | byte count (note 2) |
| AddedOn | date | date that file was attached (note 2) |
Notes:
- To ensure uniqueness, PDXpert assigns a separate alias filename when the file is copied into the library folder.
- Value is null when FileList is External
1179