4.7.3.1.3. Display condition for parts selection - Colored catalog index - plinkgroups.cfg -> Block [Role

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

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

Directories and projects in the catalog index are colored in green or semi-transparent according to the condition under Display condition for parts selection.^[63] Green means that at least one row in a project meets the condition under CONDITIONTREE or Display condition for parts selection. Green is transferred to the top (on all hierarchically higher directories). Semi-transparent means that no row of any project meets the condition.

Catalog index with green and semi-transparent directories and projects

When activating the preferred rows function via button Preferred rows on/off all semi-transparent projects and directories are hidden.

Example:

Setting in configuration file $CADENAS_SETUP/plinkgroups.cfg

	Note
	Please use SQL syntax for this setting.

[Role_name]
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 -> tabbed page General -> Display condition for parts selection

Note

No entry in the key CONDITIONTREE or Display condition for parts selection ^[a] is according to:

CONDITIONTREE=(LINKTABLE.ERP_PDM_NUMBER<>'')

^[a] Does not work in Oracle DB. For example, use something like "LENGTH(ERP_PDM_NUMBER)>0".

	Note
	Display condition for parts selection only works, if there are parts with ERP number in the respective directories!

-> Effect in PARTdataManager:

If the filter Preferred rows on/off is activated then only those directories and projects are displayed which contain parts which meet the condition, thus the green ones.

Preferred rows function off: All directories and projects are displayed.

Preferred rows function on:

More examples:

	Note
For the declaration of the column also state the table in addition (ERPTABLE or LINKTABLE). You can find the corresponding table in the Configure dialog box. Example: LINKTABLE.ACTIVE_STATE

Note

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

You can 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 directories are displayed, which contain parts, where an ERP number has been assigned and which contain an entry in the PRICE3 column.
```
((LINKTABLE.ACTIVE_STATE=1) AND (ERPTABLE.STANDORT1<>''))
```
Only directories are displayed, which contain parts, where an ERP number has been assigned and which contain an entry in the PRICE3 column.

Interaction with other settings

If the option under PARTlinkManager -> Extras menu -> Configure ERP environment -> Assign linked parts in the parts selection is deactivated, a plain-colored index tree is displayed.
If the option is activated, in the index tree, you can find a green/semi-transparent display according to the definition on the tabbed page General under Display condition for parts selection. The setting in the key COLORCONDITIONTREE or under Status colors for catalog index overrides and possibly results in 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" deactivated: Result in PARTdataManager:

If under tabbed page Display -> Status colors for catalog index settings are made, then the red-green coloring is suspended. Then the catalog index can be multicolored. See under Section 4.7.3.3, “ Roles: Tabbed page "Display" ”.

	Note
	The function of the button Preferred rows on/off is further available according to the condition set under Display condition for parts selection.

The above mentioned setting Assign linked parts in the parts selection is also suspended then, because it only refers to the standard red-green setting.

The following matrix shows the relations:

Settings under PARTadmin -> category Roles -> Tabbed page Display -> Status colors for catalog index (the setting under Assign linked parts in the parts selection doesn't matter)

[compare role "location" in the demo environment]

No settings under PARTadmin -> category Roles -> Tabbed page Display -> Status colors for catalog index

[compare role "ecat" in the demo environment]

Assign linked parts in the parts selection: Activated

Multicolored index tree

Green/semi-transparent index tree according to the condition under PARTadmin -> category Roles -> Tabbed page General -> Display condition for parts selection

Assign linked parts in the parts selection: Deactivated

Multicolored index tree

Plain-colored index tree

The following figure shows a multicolored index tree according to the settings under Display tabbed page -> Status colors for catalog index section. See Section 4.7.3.3, “ Roles: Tabbed page "Display" ”.

	Tip
Normally it makes sense to use the same condition for Preferred ranges and Display condition for parts selection. See Section 4.7.3.1.2, “ Preferred ranges - plinkgroups.cfg -> Block [Role_name] -> Key "PREFRANGE" ”. Example: Preferred ranges and Display condition for parts selection both require the existence of an ERP number.

Tip

Normally it makes sense to use the same condition for Preferred ranges and Display condition for parts selection. See Section 4.7.3.1.2, “ Preferred ranges - plinkgroups.cfg -> Block [Role_name] -> Key "PREFRANGE" ”.

Example: Preferred ranges and Display condition for parts selection both require the existence of an ERP number.

^[63]Settings under COLORCONDITIONTREE or Status colors for catalog index override and possibly result in 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>" ”).

If the option under PARTlinkManager -> Extras menu -> Configure ERP environment -> Assign linked parts in the parts selection is deactivated, then the index tree is displayed plain-colored.

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