Troubleshooting
Problem
Search "_" text doesn’t support on table view.
Symptom
On MAS Health and Predict - Utilities UI, open Assets page or Locations page, on the table view, click the search icon and input text like "POLE_". The table will show “No results”, but there may be assets that are named POLE_xxx in the system.
Cause
This result is determined by how the database is processing the query. Underscore is a wildcard character in SQL, which stands for any single character when used with LIKE operator. Searching POLE_ matchs all records with POLE followed by a single character. It will also match the length, which means it must be of length 5. That is why there are no results.
Affected versions
IBM Maximo Health and Predict - Utilities 8.0+ (in Maximo Application Suite 8.4.x + )
IBM Maximo Health and Predict - Utilities 8.0+ (in Maximo Application Suite 8.4.x + )
Resolving The Problem
If you want to search keyword by using the wildcard, search for POLE________ or POLE_%.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m3p0000006xe7AAA","label":"Maximo Application Suite-\u003EMAS Applications-\u003EHealth and Predict - Utilities"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.4.0"}]
Was this topic helpful?
Document Information
Modified date:
22 November 2022
UID
ibm16840965