IBM Support

Limiting Lookups using WHERECLAUSE

Question & Answer


Can Lookups be limited without a table domain?


Out of the Box Work Order Tracking Worktype is displayed as the following:

To limit this through the LOOKUPS.XML, complete the following steps:

1) Go To – System Configuration – Platform Configuration – Application Designer – click on Select Action – Export System XML – click on the blue arrow corresponding with the LOOKUPS. Save and create a backup of the LOOKUPS.XML.
2) Open LOOKUPS.XML within a text edit, search for table id="worktype":

Add 'whereclause' to the following line to meet your business needs:

<table id="worktype" inputmode="readonly" selectmode="single">


<table id="worktype" inputmode="readonly" selectmode="single" whereclause=" worktype not in ('CAL','PMCAL','EMCAL','CMCAL')">


3) Import the modified LOOKUPS.XML – sign out – close the browser – restart the application server – sign back into Maximo – Go To – Work Orders – Work Order Tracking – create a new Work Order – click on the Work Type lookup the following will now appear:

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"System Related","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5;7.6","Edition":"All Editions","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
17 June 2018