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 search for null and not null values by entering the following values into a search field on the Find tab:

  • To search for a null value enter: ~null~
  • To search for not null values enter: != ~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…

Search for NULL values in Maximo applications

4 thoughts on “Search for NULL values in Maximo applications

Leave a Reply to Gavin Cancel reply

Your email address will not be published. Required fields are marked *


Scroll to top