Limit out of the box lookups using WHERELCLAUSE by using LOOKUP.XML - IBM Maximo

Let’s start with an example, suppose our requirement is to limit Work types in Work Order Tracking application to just show CM and PM.

Therefore, we achieve this by using below mentioned solution:

Go to > System Configuration > Platform Configuration > Application Designer

click on Export System XML from Select Action

Click on blue blued juxtaposed to LOOKUP and then Save into your computer.

Note: make a copy to backup LOOKUPS.XML first.

1. Open LOOKUP.XML in your favorite editor, mine is Notepad++ and find html tag looks like this:

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

2. append this line and add where clause, and it will become like this:

<table id="worktype" inputmode="readonly" selectmode="single" whereclause=" worktype IN ('CM','PM')">

Save the file and import back again. Restart WebSphere once and that’s all.