powered by CADENAS

Manual

Manual

5.9.2.6. Menu item Table filters

  • Restricted Display and Suppressed Rows:

    These two function have a similar effect.

    With Restricted Display you can use SQL or Fortran syntax.

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

    Restricted Display with D=8

    Restricted Display with D=8

    At Suppressed Rows please use Fortran syntax. Meaning for example D.EQ.8 at a numerical variable or D.EQ.‘8‘ at a textual variable.

    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] 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.12.2.1.4, “ Viewing condition for table rows - plinkgroups.cfg -> Block [Role_name] -> Key "TABRESTRICTION" ” in PARTsolutions / PARTcommunity4Enterprise - 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.12.2.1.2, “ Preferred ranges - plinkgroups.cfg -> Block [Role_name] -> Key "PREFRANGE" ” in PARTsolutions / PARTcommunity4Enterprise - 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:

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

      Filter variable "FILTER"

      Filter variable "FILTER"

    2. Then enter the desired filter name in the single rows to be filtered. In above example this is "ENGLISH"; "GERMAN" and "FRENCH":

    3. In PARTproject, under Filter variable, enter the respective variable name.

      Here exemplified "FILTER". (See Fig. „ Project filter “.)

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

      -> The dialog box Project filter is opened.

      Project filter

      Project filter

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

      [Note] 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.

    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.



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

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