IBM Support

Need ALN Domains to Display in Description Order

Troubleshooting


Problem

ALN look-ups display in the wrong order.

Symptom

Click on a look-up (magnifying glass) beside a field:



The value is not sorted by description:

Resolving The Problem

Please follow the steps below:


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 the LOOKUPS.XML -
Create a backup of the LOOKUPS.XML
Open the LOOKUPS.XML in a text editor.

2) Add the following:

<table id="lookup" inputmode="readonly" selectmode="single"
orderby="VALUE asc">
<tablebody displayrowsperpage="20" filterable="true"
filterexpanded="true" id="lookup_lookup_tablebody">
<tablecol dataattribute="value"
id="lookup_lookup_tablebody_col_5" mxevent="selectrecord"
mxevent_desc="Go To %1" sortable="true" type="link"/>
<tablecol dataattribute="description"
id="lookup_lookup_tablebody_col_6" mxevent="selectrecord"
mxevent_desc="Go To %1" sortable="true" type="link"/>
</tablebody>
</table>

Save,

3) Import the Modified LOOKUPS.XML in Application Designer.

4) Access the application in Application Designer where you have the
Look-up specified. Access the field - click on the field and then click on Control Properties on the toolbar.

Change the Look-up Reference from VALUELIST to LOOKUP.

Save.

5) Sign out of Maximo - sign back into Maximo - Access the Application
- Click on the Look-up for the field.

ALN domain look-up should be sorted by description now.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21666595