This topic is contained in the PDXpert help file: select Contents from the application's Help menu.
Views
Purpose
Defines an administrator-defined SQL Server view.
Where used
ODBC database connections.
Data fields
- Name
- This is the SQL Server view name that is referenced by ODBC clients. The name must conform to PDXpert's and Microsoft SQL Server's view naming guidelines. For example, PDXpert view names must always begin with the letters My... as in, say, MyReleasedParts
- Description
- This describes the view and its purpose.
- SQL SELECT statement
- This is the SQL Server SELECT statement that produces the view.
- For example:
SELECT *
FROM ItemMasterView
WHERE (Class = 1) AND (NOT (Revision IS NULL))
ORDER BY Owner, Type, Number
- Active: users can select
- Default member of collection
- Permanent member of collection
- For a description of these checkboxes, see the Collections reference > Common properties & attributes help topic.
Setup suggestions
A SQL Server administrator-defined view must always be based on PDXpert's public views.
For important information about creating views, refer to the How to report, import & export > Viewing & exporting via ODBC help topic.
2008
Help topics describe the most current PDXpert PLM software release, and may differ from earlier releases.
