[mapguide-users] Maestro and Nulls
Jackie Ng
jumpinjackie at gmail.com
Fri Jan 31 22:20:09 PST 2025
Hi David,
I'm pretty sure the FDO filter grammar spec treats nulls as a separate
category of values which do not apply to comparison operators.
It's why we have dedicated operators in FDO to test for nullability:
property_name NULL
NOT property_name NULL
Instead of
property_name = NULL
property_name <> NULL
So to go back to your original question, I would say you amend the filter
to be this instead.
COUNTRY NULL OR COUNTRY <> 'CANADA'
- Jackie
You wrote:
Hi Jackie,
We're encountering an issue where data is not showing up on the map when a
filter, under Layer Settings, is used and the attribute is null. For
example, if the filter is COUNTRY <> 'CANADA' any record that does not
contain a country will not show up on the map.
We're using composite styles for this specific layer and our database is
Oracle.
Thanks,
David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20250201/223d20eb/attachment.htm>
More information about the mapguide-users
mailing list