Maximo search features are quite advanced but often neglected. By using the advanced search techniques described in this post it is possible to find relevant records easier and faster.
The equal ‘=’ operator can be used to find only records that match that a word or number exactly. In other words ‘=’ means “exact match”.
Example: Enter =123 to find any records with the exact characters 123 in the field. (Search results would not include numbers such as 0123 or 1234AB. If you enter just 123, without the =, search results would include 0123 and 1234AB.)
To search for all values that are not equal to a specific value enter ‘!=‘.
For example, typing !=WAPPR in the status field will retrieve all records that are not in WAPPR status.
The ‘<‘ and ‘>‘ characters can also be used to search for records that are bigger or smaller than a specific value.
- Greater than ‘>‘: searches for any date after or number/word greater than the specified value.
Example: Enter >1172 finds records of occurrences that have work order number greater than 1172.
- Less than ‘<‘: searches for any date before or number/word smaller than the specified value.
Example: Enter <1172 finds records of occurrences that have work order number smaller than 1172.
List of values
You can use comma ‘,‘ operator to list the records that match with either of the values specified. It basically acts as the OR operator.
For example, typing WAPPR,COMP in the status field will retrieve all records that are in WAPPR or COMP status .
You can use a “wildcard” characters with letters or numbers to indicate you want to find records that begin with, end with, or contain those letters/numbers.
There are four characters you can use as a wildcard:
- Asterisk ‘*‘ or percent sign ‘%‘: stand for any number of characters (zero, one, or multiple) in the specified position.
Example: Enter 123* to find records that start with 123, such as 123, 12345, 123ABC.
Example: Enter *123 to find records that end in 123, such as 123, 5123, PUMP123.
Example: Enter *123* to find records that contain 123, such as 123, 1234, PUMP123xy.
- Underscore ‘_‘ or question mark ‘?‘: stand for a single character in the specified position.
Example: Enter 123_ to find any four‐character records that start with 123, such as 1234, 1230, 123g.
Example: Enter or _18 to find any three‐character records that end with 18, such as 418, J18.
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.
A small additional tip for searching dates in the current month.
If you want to search for WO’s with scheduled start date less than today, you don’t need to type or select the whole date into the search field because Maximo automatically appends the current month and year in the where clause.
For example, if you search with <15, system will return all WO’s where scheduled start date before the 15th of the current month.
Understanding Search Methodologies
To Search For Records in a Maximo Database
Search for NULL values in Maximo applications
9 thoughts on “Maximo search operators”
Bruno, pls highlight using = sign in combination with list of values return exactly the records containing search string … =APPR,=CAN ! Maybe you can add it to your article
Thankful for such splendid blog yours…!
Mobile Application Development in Delhi
Wonderful guide and I must say that this is very basic info that you have shared but many times people often forget the basics. So that is why your work is wonderful in many ways.
This particular post is really very interesting. It has a really great peace of Data,
I enjoyed very well with this particular blog it has very useful information
I like to much the style of this Article
thats really nice and informative article.Thank You.
Best Gas Grill Under 500
A compelling SMS Gateway can take care of three noteworthy issues. The principal serious issue is time and area obstructions as SMS can be conveyed whenever anyplace. Furthermore, SMS is progressively compelling with a 98 percent open rate and thirdly, it is route less expensive than different channels, for example, calls or messages.
If the comma acts as the “OR” operator in a list of search options, is there something you could use that would be “AND”?
@Black Tuckerr: Welcome to the weird world of Maximo! If you want to do “AND” searches you need to enable Text search instead of Wildcard search. This in other words means you have to enable this on you database system.
How do you search for an searchoperator? I need al the rows with a dash – in it.
And i can’t figure it out.
Is there a way to search for multiple values that are not equal to in status?
Example: !=wclose (as well as) !=comp