I just found this out and I find it very useful. There is a way for you to search for NULL fields from the Advanced Search dialog or even from the list column within the Work Order Tracking module. You don’t have to know SQL to search for NULL cause you don’t even have to modify the where clause. You can search for NULL by entering ~null~ into any field.
You are here: / / Search for NULL fields from within Maximo screens
I am a Senior Consultant/Software Engineer and co-lead developer of EZMaxMobile at InterPro Solutions, LLC