<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
This works for me.</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Try this:</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Create two layers with the same name and group.</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Layer 1 ( takes care of values 2000 and 2100) :</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
LAYER</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
NAME "A"</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
GROUP "A"</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
.....</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
PROCESSING 'NATIVE_FILTER=gst IS NOT NULL'</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
CLASS for 2000</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
....</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
CLASS for 2100</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
....</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
END</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Layer 2 ( value = NULL ) ❤️</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
LAYER</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
NAME "A"</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
GROUP "A"</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
....</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
PROCESSING 'NATIVE_FILTER=gst IS NULL'</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
CLASS for NULL</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
....</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
END</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>Från:</b> MapServer-users <mapserver-users-bounces@lists.osgeo.org> för Seth G via MapServer-users <mapserver-users@lists.osgeo.org><br>
<b>Skickat:</b> den 28 mars 2025 10:43<br>
<b>Till:</b> angelique.kroisl@stadt-koeln.de <angelique.kroisl@stadt-koeln.de>; MapServer Users <mapserver-users@lists.osgeo.org><br>
<b>Ämne:</b> Re: [MapServer-users] NULL-EXPRESSION</font>
<div> </div>
</div>
<style type="text/css">
<!--
#x_qt p.x_qt-MsoNormal
{margin-top:0cm;
margin-right:0cm;
margin-left:0cm;
margin-bottom:0.0001pt;
font-size:11pt;
font-family:"Calibri",sans-serif}
#x_qt a:link
{color:rgb(5,99,193);
text-decoration-color:currentcolor;
text-decoration-line:underline;
text-decoration-style:solid}
#x_qt a:visited
{color:rgb(149,79,114);
text-decoration-color:currentcolor;
text-decoration-line:underline;
text-decoration-style:solid}
p.x_MsoNormal, p.x_MsoNoSpacing
{margin:0}
-->
</style>
<div>
<div>Hi,<br>
</div>
<div><br>
</div>
<div>Unfortunately, MapServer doesn't have a NULL type.<br>
</div>
<div>The workaround is to create a database view or query that will set the NULL to a numeric value of your choosing, e.g. -1 and then use that value in the CLASS expressions.<br>
</div>
<div><br>
</div>
<div>Seth</div>
<div><br>
</div>
<div id="x_sig62266145">
<div class="x_signature">--<br>
</div>
<div class="x_signature">web:<a href="https://geographika.net">https://geographika.net</a> & <a href="https://mapserverstudio.net">https://mapserverstudio.net</a><br>
</div>
<div class="x_signature">mastodon: @<a href="mailto:geographika@mastodon.social">geographika@mastodon.social</a><br>
</div>
</div>
<div><br>
</div>
<div>On Fri, Mar 28, 2025, at 8:55 AM, Angelique Kroisl via MapServer-users wrote:<br>
</div>
<blockquote type="cite" id="x_qt" style="">
<div class="x_qt-WordSection1">
<p class="x_qt-MsoNormal">Hello,<br>
</p>
<p class="x_qt-MsoNormal">I'm trying to create a class using the class item "gst."<br>
</p>
<p class="x_qt-MsoNormal">The attribute in the database can only have three values (2000, 2100, and <NULL>).<br>
</p>
<p class="x_qt-MsoNormal">Unfortunately, I can't create the NULL EXPRESSION.<br>
</p>
<p class="x_qt-MsoNormal"> <br>
</p>
<p class="x_qt-MsoNormal">I've already tried the following:<br>
</p>
<p class="x_qt-MsoNormal">EXPRESSION IS NULL<br>
</p>
<p class="x_qt-MsoNormal"> <br>
</p>
<p class="x_qt-MsoNormal">EXPRESSION "<NULL>"<br>
</p>
<p class="x_qt-MsoNormal"> <br>
</p>
<p class="x_qt-MsoNormal">EXPRESSION <NULL><br>
</p>
<p class="x_qt-MsoNormal"> <br>
</p>
<p class="x_qt-MsoNormal">EXPRESSION EMPTY<br>
</p>
<p class="x_qt-MsoNormal"> <br>
</p>
<p class="x_qt-MsoNormal">What is the correct syntax for this?<br>
</p>
</div>
<p><br>
</p>
<div>
<hr>
<br>
</div>
<p><br>
</p>
<div><span class="x_font" style="font-family:Arial">Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem Newsletter!
<a href="https://www.stadt-koeln.de/service/onlinedienste/newsletter-anmeldung?para=allgemein">
Newsletter Anmeldung</a></span><br>
</div>
<div>
<hr>
<br>
</div>
<p><br>
</p>
<p><br>
</p>
<div><span class="x_font" style="font-family:arial"><br>
<a href="https://www.stadt-koeln.de/leben-in-koeln/freizeit-natur-sport/veranstaltungskalender/lidl-final4-dhb-pokal"><img src="https://www.stadt-koeln.de/images/footer-final4-2025.jpg"></a></span></div>
<div>_______________________________________________<br>
</div>
<div>MapServer-users mailing list<br>
</div>
<div><a href="mailto:MapServer-users@lists.osgeo.org">MapServer-users@lists.osgeo.org</a><br>
</div>
<div><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</div>
<div><br>
</div>
</blockquote>
<div><br>
</div>
</div>
</body>
</html>