PARTadmin -> Roles category -> Display index page -> Status colors for catalog index dialog

Any desired number of colors with conditions can be defined.

A useful rule could be:

Dark green =     Already used at all locations
Middle green =   Already used at two locations
Light green =    Already used at one location
Yellow =         Used at no location, but with ERP number
Orange =         Standard part
Red =            Not according to any specification

Another example could be to define colors which signalize whether a part is in stock. Each rule which can be derived from table or project information is possible!

Anyway parts should be preferably used according to the marking.

	Note
	To define status colors in the catalog index please use SQL syntax.

Note

The colors are prioritized. First (above) set colors have higher priority. This means: If several conditions are fulfilled at the same time, then that color is "winning", which in the list of conditions, is at the uppermost position. You can change the position of a line in the following way: Select the desired line and move it to the wanted position when pressing the mouse button. Delete lines by selection and clicking the Del key.

PARTadmin -> "Roles" category-> "Display" index page -> "Status colors for catalog index" dialog

	Tip
	If you want to follow the example by yourself, see the settings in the PLDBDEMO database instance with user "location" in the role "LOC1" The demo environment is offered in the installation routine. PARTsolutions parts management with PDM/ERP/PLM integration

In the example above, the location columns are called "LOC1" to "LOC3". If the part was used at a location, the column has an "x".

The condition for the existence of an ERP number is:

LINKTABLE.ERP_PDM_NUMBER<>''

You have the possibility to include parts to the set of rules, which are classified according to the standards classification.

The respective condition is:

IsStandardPart()

Combinations with further conditions are also possible.

MAT_NAME='STEEL' AND IsStandardPart()

The above mentioned set of rules results in the following depiction in PARTdataManager:

Status colors for catalog index in PARTdataManager

	Note
	Display tabbed page -> Status colors for catalog index overwrites the green/red (or green/transparent) status colors which result from the condition under General index page -> Display condition for parts selection Filtering the index tree via Preferred rows on/off still complies with the condition set on the General tabbed page -> Display condition for parts selection.

Note If under Status colors for catalog index no setting will be performed, then as of v9.08 green and transparent directories are displayed. Green is displayed, if in a project there is at least one row, which is according to the export condition or a directory, which at least contains on project, which is according to the preferred row condition.[a] If the behavior up to v9.07 with Green/Red depiction shall be used, then please perform the following settings: LINKTABLE.ERP_PDM_NUMBER<>'' | Color Green Meaning: If an ERP_PDM_NUMBER exists, then green is displayed. 1 | Color Red Meaning: In all other cases red is displayed.

[a] This description refers to a standard condition. However, any setting is possible.