Hi, What is the color that gets used? Is it some of the ones that you have defined in the CASE query?
-Jukka Rahkonen- ________________________________________ Lähettäjä: MapServer-users <[email protected]> käyttäjän Linsenmaier, Dierk via MapServer-users <[email protected]> puolesta Lähetetty: Tiistai 13. tammikuuta 2026 10.29 Vastaanottaja: [email protected] <[email protected]> Aihe: [MapServer-users] Issue with line colors in mapserver 8.4.0 Hello mapserver community, Since we switched from mapserver version 7.6.4 to version 8.4.0, I have an issue with colors in line layers. All dynamic color definitions (color is defined by a variable) are rendered with the same color. No matter if we use RGB- or HEX-Color values. COLOR [VAR] The values for the color variable are defined by an oracle SQL querry. Example SQL: DATA "geom FROM (SELECT id,status,zeitraum, case when Zeitraum in ( 2023) then '166 206 227' when Zeitraum in ( 2024) then '31 120 180' when Zeitraum in ( 2025) then '227 26 28' when Zeitraum in ( 2026) the n '255 127 0' when Zeitraum in ( 2027) then '253 191 111' when Zeitraum in ( 2028,2029,2030) then '251 154 153' when Zeitraum in ( 2031,2032,2033,2034,2035) then '51 160 44' when Zeitraum in ( 2036,2037,2038,2039,2040) then '178 223 138' END as color, geom,'Status: '||STATUS__LL||'</BR>Trassenlänge: '||trassenlaenge||'m' AS banner FROM my_oracle_table WHERE 1=1 ) USING UNIQUE ID SRID 25832 FILTER" CLASS definition: CLASS NAME "CLASS 1" EXPRESSION ("[STATUS]" IN "in_ausfuehrung") STYLE OPACITY 90 OUTLINECOLOR 255 255 255 WIDTH 7 LINECAP butt END#STYLE STYLE OPACITY 100 COLOR [COLOR]#28 22 63 WIDTH 4 LINECAP butt END #STYLE END #CLASS CLASS NAME "CLASS 2" EXPRESSION ("[STATUS]" IN "geplant_genehm_gut") STYLE OPACITY 90 OUTLINECOLOR 255 255 255 WIDTH 7 LINECAP butt END#STYLE STYLE OPACITY 100 PATTERN 12 6 12 6 END COLOR [COLOR]#28 22 63 WIDTH 4 LINECAP butt END #STYLE END #CLASS CLASS NAME "CLASS 3" EXPRESSION ("[STATUS]" IN "geplant_n_genehm") STYLE OPACITY 90 OUTLINECOLOR 255 255 255 WIDTH 7 LINECAP butt END#STYLE STYLE OPACITY 100 PATTERN 12 6 4 6 END COLOR [COLOR]#28 22 63 WIDTH 4 LINECAP butt END #STYLE END #CLASS Is this a know issue or do you have any hint for me to solve it? Mit freundlichen Grüßen Dierk Linsenmaier -- Dierk Linsenmaier Team GIS Informationstechnik regioDATA Tullastr. 61 79108 Freiburg i. Brsg. Telefon 07621 91943-477 Telefax 07621 91943-465 [email protected] http://www.regiodata-gmbh.de/ regioDATA GmbH Sitz Lörrach, Amtsgericht Freiburg HRB 412719 Geschäftsführer: Michael Schade _______________________________________________ MapServer-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ MapServer-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
