IBM Support

Type-ahead limitation with where clause variables and relationships

Troubleshooting


Problem

On Maximo 7.5 the type-ahead feature was added, so you can choose a value from a list as you type. The values are loaded from a Table or ALN domain. However, there are some limitations that may cause problems during the set up.

Symptom

First limitation: if the Table Domain has a where clause with variables like ':ticketid',':ownergroup',':owner', then type-ahead will just ignore it and return no value.

All of the data is downloaded to the client browser and must be filtered there, it does not make server calls to do the filtering.

A second limitation is the use of relationships. It is not possible to filter a column from another table.
As a work around you can create a view that is the join across the tables to get a flat table domain.

For more information on how to set up Type-Ahead please see the following technote:

'Configure Type-Ahead' AutoFill Function
http://www-01.ibm.com/support/docview.wss?uid=swg21613970

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Appl Designer","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5;7.6","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
18 September 2025

UID

swg21961307

Page Feedback