Maximo Unable to Search Text With Special Characters

August 31, 2016 Ghazala

image

 

Welcome to the EAM Corner!!!!

My name is Ghazala and I work in level 2 support for IBM on the EAM product. This blog series will all be helpful tips, tricks and how-to's on Maximo EAM .

Be sure to follow me on DeveloperWorks  --------->   Click here to follow me on DeveloperWorks!

Recently I came across an issue whereas  any description value that contains special characters (-,_,$  etc) will be unable to search because Maximo standard API stores those characters in the CONTAINS function expression and will be processed as operators.

 

Following steps have been used to reproduce the issue:

1- Go to to any applications main tab and change the description to have special characters.

2- Go to the list tab and enter the exact description for that record.  Press enter and it should fetch the modified record but it instead it displays no results.     

 

Resolving the problem:

The following suggestion has been applied: Refer to the Oracle document:                                           
http://docs.oracle.com/cd/B14117_01/text.101/b10730/cqspcl.htm                  
                                                                                
For special characters such as -, you will need to use \ instead so it is not treated as a special character.                                                                                                                         
For example, one asset's description is "word-of-mouth communication".      

To search for it, enter this search term:  word\-of\-mouth                     

 

Thanks for reading, be sure to look out for my next installment. 

Previous Article
Maximo Revised Contract Status Changed to History if Purchase Contract Status is Changed to WSTART

Welcome to the EAM Corner!!!! My name is Ghazala and I work in level 2 support for IBM on the EAM product. ...

Next Article
Maximo Closing Request for Quotations Without Awarding All Lines to POs
Maximo Closing Request for Quotations Without Awarding All Lines to POs

Welcome to the EAM Corner!!!! My name is Ghazala and I work in level 2 support for IBM on the EAM product. ...

×

Want our latest news? Subscribe to our blog!

Last Name
First Name
Thank you!
Error - something went wrong!