IBM Support

Limiting Lookups using WHERECLAUSE

Question & Answer


Question

Can Lookups be limited without a table domain?

Answer

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">

To:

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

Save.

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

UID

swg21605835