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]
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 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:
First create one or more filter variables in the PARTdesigner one or more filter variables [35] define. "FILTER" is used here as an example.
Then enter the desired filter name in the single rows to be filtered. In above example this is "ENGLISH"; "GERMAN" and "FRENCH":
Enter the relevant variable name(s) in PARTproject under Filter variable, enter the corresponding variable name(s).
Here exemplified "FILTER". (See Fig. „ Project filter “.)
Click in PARTproject under Edit project -> General -> Table filter [Table filters] -> Project filter, click on the Search Button.
-> The Project filter dialog box opens.
With a click on
, add the desired variables (filters). Here exemplarily "ENGLISH"; "GERMAN" and "FRENCH".
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.
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 inpartsol.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.