March 3, 2012

Search for NULL values in Maximo applications

Today I want to share with you a little tip that allows to search for empty (NULL) values in every Maximo/TPAE application. You can do this by simply typing ~null~ into any of the search field.
On the other hand if you want to search for records having a field with values that are NOT NULL type !=~null~
If your keyboard does not have the tilde '~' character you may type enter this character by typing 126 on your numeric keypad while pressing the 'Alt' key.
Maybe this sound obvious to you but it was not easy to discover...


  1. This doesn't work on advanced search fields like classification, any suggestions?

  2. Thank you so much! this works like a champ! No more child work orders cluttering the search!!!!

  3. In Windows, if you want tilde ~, you hold down Alt then press 126 on the keypad.