More about codelists

<< Click to Display Table of Contents >>

Administration > Menu reference > Administration > Codelists > Codelist manager >

More about codelists

Variants of code lists

Subtype-dependent code lists

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.

 

Linked code lists

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.