__sql__ = "SELECT vGef.*, lGef.cmr, lGef.anweisung, lGef.lgk, lGef.kennzeichen FROM view_gefahr AS vGef LEFT JOIN list_gefahr AS lGef ON lGef.kategorie = vGef.kategorie"
; ORDER BY kategorie, substanz

[__global__]
noLinkFromListView = 1

[autoID]
visibility:list = hidden
Key = PRI
order = 10

[tabID]
visibility:list = hidden
order = 20

[substanz]
widget:label = "Substanz"
filter = 1
order = 30

[kategorie]
widget:label = "Gefahrenklasse"
filter = 1
order = 40

[lgk]
filter = 1
order = 50

[cmr]
widget:type = static
widget:label = "CMR"
vocabulary = cmr
filter = 1
order = 55

[anweisung]
widget:type = static
vocabulary = anweisung
widget:label = "BA"
filter = 1
order = 60

[kennzeichen]
widget:type = static
widget:label = "Kennzeichen"
order = 70

[gruppe]
filter = 1
order = 80

[bearbeiter]
order = 90

[zeitstempel]
order = 100