<< Click to Display Table of Contents >> Administration > Menu reference > Administration > Codelists > Codelist manager > More about codelists |
Some code lists need to distinguish between different subtypes of objects. One example is Conductor type that exist in both low and high voltage. For this, the DP_SUBTYPE field is used.
A code list can contain several fields that together control several drop-down lists in the attribute form. This allows for dynamic filtering where a selection in one list limits which options appear in the next.
Example:
A code list with Manufacturer, Material and Dimension columns can be configured so that the manufacturer selection controls which materials become selectable, and the material selection in turn controls which dimensions are displayed.
Codenum |
Manufacturer |
Material |
Dimension |
0 |
ABB |
Plastic |
10 |
1 |
ABB |
Plastic |
20 |
2 |
ABB |
Plastic |
30 |
3 |
ABB |
Plastic |
40 |
4 |
ABB |
Plastic |
50 |
5 |
ABB |
Plastic |
60 |
6 |
ABB |
Steel |
20 |
7 |
ABB |
Steel |
30 |
8 |
ABB |
Steel |
70 |
9 |
ABB |
Steel |
80 |
10 |
ABB |
Copper |
20 |
11 |
ABB |
Copper |
30 |
12 |
ABB |
Copper |
90 |
… |
|
|
|
100 |
Ericsson |
Plastic |
10 |
101 |
Ericsson |
Plastic |
20 |
102 |
Ericsson |
Plastic |
30 |
… |
|
|
|
120 |
Ericsson |
Plastic |
110 |
121 |
Ericsson |
Plastic |
120 |
122 |
Ericsson |
Steel |
20 |
123 |
Ericsson |
Steel |
90 |
124 |
Ericsson |
Paper |
20 |
If ABB is selected as the manufacturer, the material list shows the material types defined for ABB. Similarly, if you then enter Copper in the material list, only the options 20, 30 and 90 are filtered out in the dimension list.
The value saved for the object is, as before, only the code value. If you want an additional dimension for ABB's copper cables, you add a new line in the code list with the field values code value/ABB/Copper/new dimension.