Above is the default Lookup menu for selecting a parent Work Order in Maximo EAM. Let’s say we want to apply a filter on Status to only show approved work orders. We can achieve this by performing following configuration changes:
- Open
Application Designerand download the lookups.xml file. - Search for
workorderistaskin lookups.xml. You should find the default definition as follows:
1 2 3 4 5 6 7 8 9 10 11 | <table id="workorderistask" inputmode="readonly" selectmode="single"> <tablebody displayrowsperpage="20" filterable="true" filterexpanded="true" id="workorderistask_lookup_tablebody"> <tablecol dataattribute="wonum" id="workorderistask_lookup_tablebody_col_6" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="description" id="workorderistask_lookup_tablebody_col_7" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="woclass" id="workorderistask_lookup_tablebody_col_8" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="location" id="workorderistask_lookup_tablebody_col_9" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="assetnum" id="workorderistask_lookup_tablebody_col_A" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="status" id="workorderistask_lookup_tablebody_col_B" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="istask" id="workorderistask_lookup_tablebody_col_C" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> </tablebody> </table> |
- Add the default value element
1 2 3 4 5 6 7 8 9 10 11 12 | <table id="workorderistask" inputmode="readonly" selectmode="single"> <tablebody displayrowsperpage="20" filterable="true" filterexpanded="true" id="workorderistask_lookup_tablebody"> <tablecol dataattribute="wonum" id="workorderistask_lookup_tablebody_col_6" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="description" id="workorderistask_lookup_tablebody_col_7" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="woclass" id="workorderistask_lookup_tablebody_col_8" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="location" id="workorderistask_lookup_tablebody_col_9" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="assetnum" id="workorderistask_lookup_tablebody_col_A" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <tablecol dataattribute="status" id="workorderistask_lookup_tablebody_col_B" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> <defaultvalue dataattribute="status" defaulttype="query" id="workorderistask_lookup_tablebody_col_B_default" value="APPR"/> <tablecol dataattribute="istask" id="workorderistask_lookup_tablebody_col_C" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/> </tablebody> </table> |
- Import the updated
library.xmlback into Maximo.
