Hi Dierk, Does your use case match the issue at https://github.com/MapServer/MapServer/issues/7167 ? I think adding a new PROCESSING directive to MapServer could be used here to switch between the two different use cases.
Seth -- web:https://geographika.net & https://mapserverstudio.net mastodon: @[email protected] On Tue, Jan 13, 2026, at 9:29 AM, Linsenmaier, Dierk via MapServer-users wrote: > 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] > 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
