Syntax notes are found under Section 7.1.1, “Fortran / SQL Syntax ”.

In some input fields you have to use Fortran syntax, in others SQL syntax. In some you may use both. The respective note is found at the top of each of the following items.

If you use the ERP_PDM_NUMBER variable in order to define conditions, then please address it with ERPTABLE.ERP_PDM_NUMBER or LINKTABLE.ERP_PDM_NUMBER, because this variable exists twice in ERPTABLE and in LINKTABLE.

With more complex expressions you possibly have to use brackets. Unneeded brackets are ignored. So you better use too many than too little.

Description:

What is entered under Description will be displayed in PARTdataManager when you open the Choose role... window.

The Choose role... window is called up via the Select group icon.

Note On the Translations tabbed page the entry is automatically set up. There you may depose any number of translations. Detailed information you can find under Section 5.9.2.5.7, “ Tabbed page "Translations" ”. If translations are deposed, then these analogously modify the displayed text.

Note The order of the displayed roles in the window Choose role... can be changed as desired under Roles -> Role. Mark the role and move it - with held down mouse button - to the desired position.

Preferred ranges

Note For this setting please use Fortran syntax.

The Preferred rows on/off button is located in the Standard toolbar as well as in the Link database toolbar.

You can define the preferred ranges in different ways. Only the data records complying with the condition are displayed when Preferred rows on/off is activated.

Examples for conditions:

Filter condition for datasets (Linktable)

Note For this setting please use SQL-Syntax.

ACTIVE_STATE=1 

The „active state“ must be “released”.

The data records which either have no entry in LinkDB or which comply with the condition are displayed in PARTdataManager. Thus, the data records which have the entry "Released" in the "ACTIVE_STATE" column.

Viewing condition for table rows

Note For this setting please use SQL-Syntax.

Examples:

Columns to be displayed

Role-specific display of the columns

Enter all columns to be displayed in PARTdataManager separated by comma.

Note The here defined sequence of the columns is exactly according to the column sequence in PARTdataManager and thus role-oriented. So you can display different columns for the single roles and if needed in different sequence.

Note In case that some ERP columns are to be displayed at the top and others at the bottom - in other words the geometric data somewhere in the middle, then please use the following syntax: ERP_PDM_NUMBER,MAT_NAME, ... ,DESCRIPTION At the position of „...“ the geometric columns are shown. You can determine the sorting of geometry columns among each other (related to the current project). On this see Section 5.9.1.6.7.4, “Column sorting of geometry columns in PARTdataManager ”.

Columns to hide (only for export):

Columns to hide: Comma separated listed as well.

This setting has to be used, if values from columns shall be exported/used, but without displaying the content.

Example:

You have formulated the following as Export condition : ((ERP_PDM_NUMBER.NE.’’).AND.(ACTIVE_STATE.EQ.1))

But you do not want to display the "ACTIVE_STATE" column.

I.e., only parts, which have an ERP_PDM_NUMBER and furthermore which „Active status“ is set on „Released“ are allowed to be exported.

„ACTIVE_STATE“ must be inserted under „Columns to be displayed“ and „Columns to hide“, otherwise the Export condition wouldn't work.

Export condition

Note For this setting you may use both Fortran syntax and SQL syntax.

For the conditions referencing on ERP-values is as possible as on geometry data.

Examples:

Tooltip displayed for exportable lines

Tooltip displayed for not exportable lines

When moving your cursor over the status light in PARTdataManager the text is displayed.

Example: Part will NOT be exported

The entry is automatically applied on the Translations index page. You can deposit as many translation texts as desired. More detailed information can be found under: Section 5.9.2.5.7, “ Tabbed page "Translations" ”.

Display condition for parts selection

Note For this setting please use SQL-Syntax.

If a condition is set, then those catalogs, which meet the condition, are displayed in green in the catalog index, all the others in red.

If the field is empty, then all project with entries in the LinkDB are displayed in green. If you want to restrict specifically, then you have to insert a condition.

If in PARTdataManager the Preferred rows on/off button is activated, then only those directories are shown, which meet the condition, all the others are hidden.

Examples

Interaction with other settings

Use export table

This function allows the release of exported directories and projects independent of other restrictions.

Under PARTlinkManager -> Extras -> Configure ERP environment -> Export tables index page you can define export tables. These are then selected in PARTadmin in the Use export table list field if desired.

PARTlinkManager -> Export tables tabbed page

More detailed information under: Section 5.9.1.3.3.2.4, “ Export tables tab ”.

Displayed bitmap (at role selection in PARTdataManager)

Clicking on the browse button ... you can browse your directories for the desired bitmap.

Comma-separated list of catalogs to hide in this role:

With this new feature you can hide catalogs very simple and role specific.

In PARTadmin in the Roles category select the desired role. Then on the General tabbed page under Comma-separated list of catalogs to hide in this role insert the catalogs to hide.

Note The spelling of the catalog names has to be exactly according to the name used under $CADENAS/23d-libs/{catalog name}and in any case use small letters. The declaration of subdirectories is possible as well.

Example:

festo,skf,norm

or

festo/parts/a,norm/en