how to use wildcard characters and Operators in Maximo

Maximo Wildcard Usage Examples.


* or %  
Substitutes for a string of characters
123* or 123% find records that start with 123, such as 123, 12345, and 123ABC.


? or _
Substitutes for a single character
123? or 123_ find any four-character records that start with 123, such as 1234, 1230, 123g.

When searching in a date field you can precede the date with a > (greater than), < (less than), or =

This only works when there is one window to search for a date (not two)  

~null~   searches for records that do not have an entry for the particular field.

!=~null~   searches for records that have an entry for the particular field.

 

Operator action Use

ampersand (&)  And

Find records that contain at least one occurrence of all of your query terms. The operator must be placed between two query terms.

hyphen (-)

Minus

Find records that contain one query term, but you want the presence of your second query term to cause the document to be ranked lower in the result set. The operator must be placed between two query terms.

pipe (|)

Or

Find records that contain at least one occurrence of any of your query terms. The operator must be placed between two query terms.

semicolon (;)

End of SQL command line

Indicate the end of a SQL command line.

tilde (~)

Not

Find records that contain one query term and not another. The operator must be placed between two query terms.


equals (=)

Exact match

Find records that are an exact match to your query. For example, filtering records with a status of "APPR" also returns records that have a status of "WAPPR" unless you type "=APPR" in the status field.

Not equals (!=)

Not match

Find records that are not a match to your query. For example, filtering records with a status of "!=WAPPR" finds records that do not have a status of “WAPPR”.