Search Work Orders by Cause and Remedy within Advanced Search

Answer

In the following example, the Failure Reporting will be added to the Advanced Search in Work Order Tracking.

1) Go To – System Configuration – Platform Configuration – Database Configuration – access the WORKORDER object – click on the Relationship Tab – add the following two relationships:

a) Relationship: FAILURECAUSE
Where Clause: failurecode = (select failurecode from failurereport where wonum=:wonum and siteid=:siteid and type = 'CAUSE')
Child Object: FAILURELIST



b) Relationship: FailureRemedy
Where Clause: failurecode = (select failurecode from failurereport where wonum=:wonum and siteid=:siteid and type = 'REMEDY')
Child Object: FAILURELIST



Save.

2) Go To - System Configuration - Platform Configuration – Application Designer - click on Select Action - Export System XML - click on the LOOKUPS - save the LOOKUPS.XML - create a backup. Open the LOOKUPS.XML within a Text Editor - insert the following:

<table id="failurecodecause" inputmode="readonly" selectmode="single" whereclause=" failurecode in (select failurecode from failurelist where type = 'CAUSE') ">
<tablebody displayrowsperpage="20" filterable="true" filterexpanded="true" id="ffailurecodecause_lookup_tablebody">
<tablecol dataattribute="failurecode" id="failurecodecause_lookup_tablebody_col_2" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>
<tablecol dataattribute="description" id="failurecodecause_lookup_tablebody_col_3" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>
<tablecol dataattribute="orgid" id="failurecodecause_lookup_tablebody_col_4" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>
</tablebody>
</table>

AND:

<table id="failurecoderemedy" inputmode="readonly" selectmode="single" whereclause=" failurecode in (select failurecode from failurelist where type = 'REMEDY') ">
<tablebody displayrowsperpage="20" filterable="true" filterexpanded="true" id="failurecodes_lookup_tablebody">
<tablecol dataattribute="failurecode" id="failurecoderemedy_lookup_tablebody_col_2" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>
<tablecol dataattribute="description" id="failurecoderemedy_lookup_tablebody_col_3" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>
<tablecol dataattribute="orgid" id="failurecoderemedy_lookup_tablebody_col_4" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>
</tablebody>
</table>



Save.

Import the modified LOOKUPS.XML. Close the Browser – Sign Out of Maximo – Restart The Application Server.

3) Sign Into Maximo – Go To – System Configuration – Platform Configuration – Application Designer – Access the WOTRACK application – click on the 'Edit Dialogs' – access the 'searchmore' dialog. Drag and Drop two Textboxes into the Advanced Search – click on one of the textbox and click on the Control Properties – enter the following information:

Label: Failure Cause
Attribute: FAILURECAUSE.FAILURECODE
Lookup: FAILURECODECAUSE



Click on the second Textbox and enter the following information:

Label: Failure Remedy
Attribute: FAILURECAUSE.FAILURECODE
Lookup: FAILURECODEREMEDY



Save.

Sign out of Maximo – close the browser – open a new browser session – sign into Maximo.

4) Go To – Work Orders – Work Order Tracking – click on the Advanced Search – use the Lookups on the Failure Cause and Failure Remedy to test functionality: