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.
Search for NULL fields from within Maximo screens
Did You Know...
As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.
Check out our products by clicking on the following links: EZMaxMobile, EZMaxPlanner and EZMaxRequest.
Is it possible to do a Date field search for NULL date values?