How to filter a "NULL" within UMP?

Document ID : KB000034259
Last Modified Date : 14/02/2018
Show Technical Document Details
Since "NULL" is a special data structure in MS SQL and not a regular "string" you have to use the following RegEx in order to be able to apply a filter.

/^((NULL).)*$/? ?

This example, when applied to a filter, will filter out any field that is NOT "NULL".

So if you apply this to the "Assigned To" field, it will only list the alarms that have not been assigned.