5.9.2.5. Menu item: Table filter

  • Table restriction [Restricted display] and line suppression [Suppressed rows]:

    These two function have a similar effect.

    You may also use Fortran-Syntax.

    Table restriction [Restricted display]:

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

    Table restriction [Restricted display] with D.EQ.8

    Table restriction [Restricted display] with D.EQ.8

    Line suppression [Suppressed rows]: e.g. D.EQ.8 for a number variable or D.EQ.'8' for a text variable.

    With line suppression [Suppressed rows], only one variable without a value can also be specified (list field selection). In this case, all rows that have any value in this variable are displayed.

    [Note]Note

    Table restriction [Restricted display] and row suppression [Suppressed rows] can be better implemented with the Strategic Parts Management methods if ERP functionality is available (see e.g. Section 4.7.3.1.4, “ Display condition for table rows - plinkgroups.cfg -> Block [Role_name] -> Key "TABRESTRICTION" ” in PARTsolutions Administration - Manual ).

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

  • Project filter and filter variable [Filter variable]:

    You can use project filters [Project filter] and filter variables [Filter variable] to reduce the number of table rows displayed in the PARTdataManager using filters, and also generate a filtered catalog variant when checking out a catalog. See Section 5.8.2.1.15.10, “ Check out catalog ”.

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

    1. First create one or more filter variables in the PARTdesigner one or more filter variables [35] define. "FILTER" is used here as an example.

      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. Enter the relevant variable name(s) in PARTproject under Filter variable, enter the corresponding variable name(s).

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

    4. Click in PARTproject under Edit project -> General -> Table filter [Table filters] -> Project filter, click on the Search ... Button.

      -> The Project filter dialog box opens.

      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 made.

    Application in PARTdataManager:

    Under menu Extras -> Settings [Settings...]... -> Part selection dialog page -> Project filter field, you can use the filter(s) to control the number of lines displayed.

    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.15.10, “ Check out catalog ”.

    Background information: When the catalog is installed, a prjfilter.cfg with the list of filters is created in the main directory of the catalog. Alternatively, you can also create project filters in partsol.cfg: Create the PRJFILTER block with the AVAILABLE key and enter the desired filters there, separated by commas.

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




[34] A more complex syntax is also possible (e.g. D.NE.14.AND.D.NE.16.AND.D.NE.18). Read about Section 7.8.12, “ Attribute algorithms ”.

[35] Filter variables must be of the "Text" type. They are created in addition to the existing variables.