Limiting Lookups using WHERECLAUSE

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: