Wednesday, December 25, 2013

Search Operators in List tab

I would like to share a tip on Search Operators on the List tab fields when retrieving the data in Maximo 7.x

1.    > [greater than Sign) before a date or number to find records that exceed that value

Example: >1172 finds records of occurrences that have Work order number greater than 1172



  >1/11/13 finds records of occurrence after that date.
The date can also be typed. The date format depends on the existing date formats.


2.        < (less than sign) before a number or date to find records that are less than that value
3.        = (equal sign) before a word or number to find only the records that match that value exactly.
Example:
Simply typing APPR value in Status field of work order application List tab would display Work orders of status APPR and WAPPR.
To get exact APPR records, we need to type =APPR in the List tab
4.       != (not equal sign) before a value to find records that doesn't match the value.

5. We can use comma [,] operator to list the records that match with either of the values in the List tab. It acts as OR operator.
For example, Typing WPPR,COMP in the status field will retrieve all records that are in status WAPPR or COMP.