4.7.3.1.  Roles: General " tab page
4.7.3.1.3.  Display condition for part selection - Colored catalog index - plinkgroups.cfg -> Block [Role_name] -> Key "CONDITIONTREE"
Prev  Next
4.7.3.1.3.  Display condition for part selection - Colored catalog index - plinkgroups.cfg -> Block [Role_name] -> Key "CONDITIONTREE"

The directories and projects in the catalog index are colored green or semi-transparent according to the condition under Display condition for part selection [Display condition for parts selection].[67] Green means that at least one line in a 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. Semi-transparent means that no line of any project meets the condition.

Catalog index with green and semi-transparent directories and projects

Catalog index with green and semi-transparent directories and projects

When the preferred rows function is activated using the Preferred rows on/off button button, all semi-transparent projects and directories are hidden.

Example:

Setting in configuration file $CADENAS_SETUP/plinkgroups.cfg

[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 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 rows function off: All directories and projects displayed

Preferred rows function off: All directories and projects displayed

Preferred rows function on

Preferred rows function on

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

    "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 4.7.3.3, “ 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]: ActivatedCatalog index with any number of individual colors Catalog index with green/semi-transparent display according to the condition under PARTadmin -> Category Roles -> Tab 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]: DeactivatedCatalog index with any number of individual colors Catalog index monochrome

    The following illustration shows the catalog index when using the settings under the Display -> Status colors for catalog index tab page. See Section 4.7.3.3, “ 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 4.7.3.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.



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

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

Prev Up Next
4.7.3.1.2.  Preferred series - plinkgroups.cfg -> Block [Role_name] -> Key "PREFRANGE"  Home 4.7.3.1.4.  Display condition for table rows - plinkgroups.cfg -> Block [Role_name] -> Key "TABRESTRICTION"