Overview

‍In many Maximo applications the specifications table is setup to show dedicated columns for alphanumeric value, numeric value and table value. The dedicated columns map to the three dedicated columns for the three different datatypes in the backend. However, I have found that the three columns can be frustrating to end users. To simplify this I have seen a combination of a non-persistent field and automation scripts to consolidate the three different types of values into one field in the applications. While effective this can be a bit cumbersome to configure and a bit error prone.

A couple years ago I found some IBM documentation that in the Maximo Developing Applications 7.5 documentation. This documentation showed how you can use {CLASSSPECVALUE} in application designer to consolidate the 3 columns into 1 column for the user to both read and enter values. I have added a copy of the IBM documentation below for easy reference. In my experience this has been very reliable and I use it anytime I am given the opportunity. I hope you find it helpful too.

‍

About this task

You can merge classification attribute values only for the classification specification attributes.

Procedure

1. In the Application Designer application, open the application that you want to change.
2. In the Specifications table on the Specifications tab, click the attribute that you want to change.
3. Delete the alphanumeric value column, the numeric value column, and the table value column by using the Context menu.
4. In the toolbar, click Control Palette and select the Table Column icon.
5. Drag the table column onto the Specifications table and close the Controls window.
6. Open the Context menu, click Properties, and specify the label name for the column. If you do not specify a name, the label from the alphanumeric value attribute is used.
7. Specify {CLASSSPECVALUE} as the attribute value, and clear the Show Filter check box.
8. Ensure that the Sortable check box and the Filterable check box are clear.
9. Save the changes.

‍

Follow the discussion in the MORE Maximo Community here.