5.9.2.5. Menu item Table filters

5.9.2. Tabbed page General 5.9.2.5. Menu item Table filters
Prev	Next

Restricted Display and Suppressed Rows:

These two function have a similar effect.

You may also use Fortran-Syntax.

Restricted Display:

For example, determine the condition D.EQ.8, in order to reduce the table display to specific values (see figure below).^[35]

Restricted Display with D.EQ.8

Suppressed Rows: Meaning for example D.EQ.8 at a numerical variable or D.EQ.‘8‘ at a textual variablen.

At Suppressed Rows, only a variable without value can also be given (list field selection). In this case those rows are displayed, which have any value in that variable.

Note

Restricted Display and Suppressed Rows can better be used with methods of Strategic Parts Management (if ERP integration is available) (see e.g. Section 4.7.3.1.4, “ Viewing condition for table rows - plinkgroups.cfg -> Block [Role_name] -> Key "TABRESTRICTION" ” in PARTsolutions - Administration Manual).

The restrictions from Restricted Display and Suppressed Rows are fixed - in contrast to the preferred rows function , which can be switched on and off (see Section 4.7.3.1.2, “ Preferred ranges - plinkgroups.cfg -> Block [Role_name] -> Key "PREFRANGE" ” in PARTsolutions - Administration Manual).

Project filter and Filter variable:

With Project filter and Filter variable, on the one hand you can restrict the displayed number of table rows in PARTdataManager by filters, on the other hand you can create a filtered catalog variant when checking out a catalog. On this see Section 5.8.2.1.14.8, “ Check out catalog ”.

In the following you can find a description for the creation of filters:

At first in PARTdesigner, specify one or more filter variables.^[36] Here exemplified "FILTER".

Filter variable "FILTER"
Then enter the desired filter name in the single rows to be filtered. In above example this is "ENGLISH"; "GERMAN" and "FRENCH":
In PARTproject, under Filter variable, enter the respective variable name.
Here exemplified "FILTER". (See Fig. „ Project filter “.)

In PARTproject, under Edit project -> General -> Table filters -> Project filter, click on the Search ... button.

-> The dialog box Project filter is opened.

Project filter

With a click on , add the desired variables (filters). Here exemplarily "ENGLISH"; "GERMAN" and "FRENCH".

Note

Project filter can be activated or deactivated:

Deactivated: If a project has set the filter in any row of the filter variable, the filter is valid for the whole project.
Activated: The filter is exactly used for respective rows.

In PARTdataManager, the display depends on the setting there.

Use in PARTdataManager:

Under Extras menu -> Settings... -> Part selection dialog area-> field Project filter, you can control the number of displayed rows by filter(s).

In this example only rows with filter "ENGLISH" are visible.

Using the filters for the Check out catalog function: See Section 5.8.2.1.14.8, “ Check out catalog ”.

Background information: During catalog installation a prjfilter.cfg is created in the catalog root directory with the list of filters. Alternatively also in partsol.cfg, project filters can be created: Create the block PRJFILTER and the key AVAILABLE here and enter the desired filters separated by comma.

Then in the dialog box (see Fig. „In this example only rows with filter "ENGLISH" are visible.“) these project filters are offered in all catalogs plus project filters from partsol.cfg.

^[35]Also a more complex syntax is possible (e.g. D.NE.14.AND.D.NE.16.AND.D.NE.18). On this see Section 7.8.11, “ Attribute algorithms ”.

^[36]Filter variables have to be of the type „Text“. They are applied in addition to the existing variables.

Prev	Up	Next
5.9.2.4. Menu item Settings for the catalog (display on catalog level)	Home	5.9.2.6. Menu item PARTserver/PARTcommunity