"Is not null" and "is not empty" not working as expected.
Discover the importance of handling null values in active directory and how to effectively write queries that filter out empty or missing data.
Written by Neil Langston
Updated at June 25th, 2024
In active directory, an attribute value can have many states.
Null and blank (is empty) are two different states for an attribute value.
PowerSyncPro can handle this circumstance, by combining both states to ensure you have the flexibility when you want to use Null independently on a different expression.
For example, if you want to employeeID attribute to have something in it for scoping. You would have the complex expression
- “is not empty” AND
- "is not null"
rather than only choosing one which will not cover all circumstance.
Here is an example snapshot
