Adding columns to a lookup in Maximo

Technote (FAQ)


Question

How can I display additional columns in a lookup.

Answer

All the lookups in Maximo exist in the LOOKUPS.XML file and are referneced by a table id value.

When a field has a lookup associated to it, the properties for that field will show the lookup's table id value in the Lookup property.
Once you have the name of the lookup, the LOOKUPS.XML file can be searched for that table id value.
To modify this file, you will need to export the LOOKUPS.XML file.
In App Designer, from the Select Action menu, select Export System XML option.
Select the blue icon next to LOOKUPS.XML
The XML file will display. Save the file to your desktop anmd keep a copy as a backup.
Open the LOOKUPS.XML file to be modified using Word Pad or another test editor.
Search for the table id for your lookup.
Typically this will be the name of the object the lookup takes it's values from.
For example you want to add a serialnum column to the Asset lookup.
You would find the following sectionin the LOOKUPS.XML
<table id="asset" inputmode="readonly" selectmode="single" >

<tablebody id="asset_lookup_tablebody" filterexpanded="true" filterable="true" displayrowsperpage="20" >
<tablecol id="asset_lookup_tablebody_col_1" dataattribute="assetnum" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" />
<tablecol id="asset_lookup_tablebody_col_2" dataattribute="description" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" />
<tablecol id="asset_lookup_tablebody_col_3" dataattribute="location" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" />
<tablecol id="asset_lookup_tablebody_col_4" dataattribute="siteid" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" />
</tablebody>

</table>

Add the following line to the table id section:
<tablecol id="asset_lookup_tablebody_col_5" dataattribute="serialnum" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" />

Note: The dataattribute value represents the attribute from the object denoted in the table id that you want to display in the lookup.

The modified code would look like:
<table id="asset" inputmode="readonly" selectmode="single" >

<tablebody id="asset_lookup_tablebody" filterexpanded="true" filterable="true" displayrowsperpage="20" >
<tablecol id="asset_lookup_tablebody_col_1" dataattribute="assetnum" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" />
<tablecol id="asset_lookup_tablebody_col_2" dataattribute="description" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" />
<tablecol id="asset_lookup_tablebody_col_3" dataattribute="location" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" />
<tablecol id="asset_lookup_tablebody_col_4" dataattribute="siteid" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" />
<tablecol id="asset_lookup_tablebody_col_5" dataattribute="serialnum" mxevent_desc="Go To %1" mxevent="selectrecord" sortable="true" type="link" />
</tablebody>

</table>

Save the changes and then import the LOOKUPS.XML file using the Import XML tool bar icon in the App Designer application.
Now when the lookup is launched you will see your added column in the lookup.

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Tivoli Asset Management for IT All
Systems and Asset Management IBM Maximo Asset Management Essentials All

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
Appl Designer

Software version:

6.2, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8, 7.1, 7.1.1, 7.5

Operating system(s):

Platform Independent

Reference #:

1382018

Modified date:

2009-07-09

Translate my page

Machine Translation

Content navigation