7.1.3.  Display condition for part selection - Colored catalog index - plinkgroups.cfg -> Block [Role_name] -> Key "CONDITIONTREE"

The directories and products/projects in the directory structure (catalog index) are colored green or white/semi-transparent according to the condition under Display condition for part selection [Display condition for parts selection].[15] Green means that at least one line in a product/project corresponds to the condition under CONDITIONTREE or display condition for part selection [Display condition for parts selection]. Green is "inherited" upwards in a direct line. White/semi-transparent means that no line of any project meets the condition.

3Dfindit: Products with green and white directories and products

3Dfindit: Products with green and white directories and products

PARTdataManager: Catalog index with green and semi-transparent directories and projects

PARTdataManager: Catalog index with green and semi-transparent directories and projects

At Activation of the preferred row function via the button Preferred rows On/Off [Preferred rows on/off] / all white/semi-transparent Products/projects and directories hidden.

Example: Setting in $CADENAS_SETUP/plinkgroups.cfg configuration file

[Note]Note

Please use SQL syntax for this setting.

[Rollenname]
CONDITIONTREE=(LINKTABLE.ERP_PDM_NUMBER<>'') AND (ACTIVE_STATE=1)

Meaning: The ERP number is not equal empty, in other words available AND the column ACTIVE_STATE has the value 1 (= released).

Setting under PARTadmin -> Category Roles -> Tab page General -> Display condition for part selection [Display condition for parts selection]

[Note]Note

No entry in the CONDITIONTREE key or display condition for part selection [Display condition for parts selection] matches:

CONDITIONTREE=(LINKTABLE.ERP_PDM_NUMBER<>'')

[Note]Note

The display condition for part selection [Display condition for parts selection] only applies if there are also parts with numbers in the respective directories!

-> Effect in 3Dfindit:

Preferred series function off: All directories/products are displayed

Preferred series function off: All directories/products are displayed

Preferred series function: Only green directories/products are displayed

Preferred series function: Only green directories/products are displayed

-> Effect in PARTdataManager:

If you activate the Preferred rows on/off filter, only those directories and projects are displayed that contain parts that meet the condition, i.e. the green ones.

Preferred series function off: All directories/projects are displayed

Preferred series function off: All directories/projects are displayed

Preferred series function: Only green directories/projects are displayed

Preferred series function: Only green directories/projects are displayed

More examples:

[Note]Note

For the declaration of the column also state the table in addition (ERPTABLE or LINKTABLE).

You will find the corresponding table in the Configure dialog box.

Example:

LINKTABLE.ACTIVE_STATE

  • 1

    With '1' the whole tree is displayed in green color without restrictions.

  • ERPTABLE.PREIS<=0.8

    Only directories are displayed, which contain parts with prices lower or equal than 0.8.

  • LINKTABLE.ERP_PDM_NUMBER<>''

    Only directories are displayed, which contain parts with ERP numbers.

  • (LINKTABLE.ERP_PDM_NUMBER<>'') AND (ERPTABLE.PRICE3>0.0)

    Only those directories are displayed which contain parts to which an ERP number has been assigned and which contain a price.

  • ((LINKTABLE.ACTIVE_STATE=1) AND (ERPTABLE.STANDORT1<>''))

    Only those directories are displayed which contain parts whose current status is set to "released" and which also have an entry in the "Location1" column.

Interaction with other settings

  • Is the option under PARTlinkManager -> Extras menu [Extras] -> Configure ERP environment -> Mark linked parts in the [Assign linked parts in the parts selection] part selection is deactivated, the catalog index is displayed in one color.

    If the option is activated, there is a green/semi-transparent display in the catalog index according to the definition on the General tab page under Display condition for part selection [Display condition for parts selection]. The setting in the COLORCONDITIONTREE key or under Status colors for catalog index overwrites and possibly leads to a multi-colored index tree (see Section 7.2.2, “ Status colors for catalog index - plinkgroups.cfg -> Block [role name] -> Key "COLORCONDITIONTREE<number>" ”.

    Assign linked parts in the parts selection

    Assign linked parts in the parts selection

    If the option is deactivated, no colors are displayed.

    "Mark linked parts in the part selection [Assign linked parts in the parts selection]" deactivated: Result in 3Dfindit

    "Mark linked parts in the part selection [Assign linked parts in the parts selection]" deactivated: Result in 3Dfindit

    "Mark linked parts in the part selection [Assign linked parts in the parts selection]" deactivated: Result in PARTdataManager

    "Mark linked parts in the part selection [Assign linked parts in the parts selection]" deactivated: Result in PARTdataManager

  • If settings are set under the Display -> Status colors for catalog index tab page, the green/semi-transparent coloring is disabled. The catalog index can then have any number of colors. See under Section 7.2, “ Rollers: Tabbed page "Display" ”.

    [Note]Note

    The filter of the Preferred rows on/off [Preferred rows on/off] button button continues to function according to the condition set under Display condition for part selection [Display condition for parts selection].

    The above-mentioned setting Mark linked parts in the part selection [Assign linked parts in the parts selection] is then also disabled, as it only refers to the standard red-green setting.

    The following matrix shows the relations:

     

    Entries under PARTadmin -> Category Roles -> Display tab page -> Status colors for catalog index (the setting under Mark linked parts in the part selection [Assign linked parts in the parts selection] does not matter)

    [compare role "location" in PLDBDEMO environment]

    No entries under PARTadmin -> Category Roles -> Display tab -> Status colors for catalog index

    [compare role "ecat" in the PLDBDEMO environment]

    Select linked parts in the parts selection [Assign linked parts in the parts selection]: ActivatedDirectory/product level or catalog index with any number of individual colors Directory/product level or catalog index with green/semi-transparent display according to the condition under PARTadmin -> Category Roles -> Tabbed page General -> Display condition for part selection [Display condition for parts selection]
    Select linked parts in the parts selection [Assign linked parts in the parts selection]: DeactivatedDirectory/product level or catalog index with any number of individual colors Directory/product level or catalog index monochrome

    The following figure shows the directory/product level in 3Dfindit when using the settings under Tabbed page Display -> Status colors for catalog index. See Section 7.2, “ Rollers: Tabbed page "Display" ”.

    The following figure shows the catalog index in PARTdataManager when using the settings under Tabbed page Display -> Status colors for catalog index. See Section 7.2, “ Rollers: Tabbed page "Display" ”.

[Tip]Tip

As a rule, it makes sense to set the condition for the preferred series [Preferred ranges] and the display condition for part selection [Display condition for parts selection] in the same direction. See Section 7.1.2, “ Preferred series - plinkgroups.cfg -> Block [Role_name] -> Key "PREFRANGE" ”.

Example: Preferred series [Preferred ranges] and display condition for part selection [Display condition for parts selection] are both based on the existence of an ERP number.

Example: Preferred series [Preferred ranges] and display condition for part selection [Display condition for parts selection] are both based on the existence of an ERP number.




[15] Settings under COLORCONDITIONTREE or status colors for catalog index [Status colors for catalog index] overwrite and possibly lead to a multi-colored index tree or directories/products (see Section 7.2.2, “ Status colors for catalog index - plinkgroups.cfg -> Block [role name] -> Key "COLORCONDITIONTREE<number>" ” ).

If the option under PARTlinkManager -> Extras menu [Extras] -> Configure ERP environment -> Mark linked parts in the part selection [Assign linked parts in the parts selection] is deactivated, the catalog index is displayed in one color.