All Nodes Tree - Filter on Null or None

serco.paul

I added a custom property (BusinessUnit) that uses a drop-down list. I am trying to create a Node tree that is filtered on the nodes that are in the default value of None.

Filters that DO NOT work

• BusinessUnit = ''
• BusinessUnit = 'None'
• BusinessUnit = 'NULL'
• BusinessUnit = NULL
• BusinessUnit Like ''
• BusinessUnit Like 'None'
• BusinessUnit Like 'NULL'
• BusinessUnit Like NULL

What is the correct filter?

serco.paul

Haha, well I answered my own question.

The Answer is

• BusinessUnit IS NULL