This content has been marked as final. Show 3 replies
When in enter query mode enter an ampersand (&) in the item you want to query for NULL value.
Click on Execute Query.
Now, a popup screen will appear. In this screen, enter the following:
Click on OK.
& is null
You can use this method for any more complicated searches, like this one on a date item:
& between trunc(sysdate) and trunc(sysdate) +7
You can also enter
directly in the item you want to query.