Maximo Open Forum

Hi everyone,

In the Work Order Tracking application, under the Plans → Materials tab, we are trying to improve how ITEMNUM is displayed.

Currently, the ITEMNUM field contains long values like 0000000064895214. In the UI, only the first part of the value is visible (e.g., 00000000), and we have to right-click or hover to see the rest.

What we want is for the last 8 digits (e.g., 64895214) to be visible directly in the same field (ITEMNUM) in the UI - without altering the actual stored value. The full item number should remain intact in the backend and available when the user right-clicks or drills in - we just want the UI to show the last 8 digits instead of the first.

Is there any way to control this - maybe via a relationship, field mask, view, or formatting trick - to change what part of the string is rendered in the field, without creating a new field or modifying the stored data?

Thanks in advance for any guidance or workaround ideas!

If displaying the entire value in the UI is acceptable, then you can add the 'size' property against that data attribute i.e., size="20" in the presentation xml. This will increase the width of the control in the UI. 

Hi everyone,

In the Work Order Tracking application, under the Plans → Materials tab, we are trying to improve how ITEMNUM is displayed.

Currently, the ITEMNUM field contains long values like 0000000064895214. In the UI, only the first part of the value is visible (e.g., 00000000), and we have to right-click or hover to see the rest.

What we want is for the last 8 digits (e.g., 64895214) to be visible directly in the same field (ITEMNUM) in the UI - without altering the actual stored value. The full item number should remain intact in the backend and available when the user right-clicks or drills in - we just want the UI to show the last 8 digits instead of the first.

Is there any way to control this - maybe via a relationship, field mask, view, or formatting trick - to change what part of the string is rendered in the field, without creating a new field or modifying the stored data?

Thanks in advance for any guidance or workaround ideas!

Hi everyone,

In the Work Order Tracking application, under the Plans → Materials tab, we are trying to improve how ITEMNUM is displayed.

Currently, the ITEMNUM field contains long values like 0000000064895214. In the UI, only the first part of the value is visible (e.g., 00000000), and we have to right-click or hover to see the rest.

What we want is for the last 8 digits (e.g., 64895214) to be visible directly in the same field (ITEMNUM) in the UI - without altering the actual stored value. The full item number should remain intact in the backend and available when the user right-clicks or drills in - we just want the UI to show the last 8 digits instead of the first.

Is there any way to control this - maybe via a relationship, field mask, view, or formatting trick - to change what part of the string is rendered in the field, without creating a new field or modifying the stored data?

Thanks in advance for any guidance or workaround ideas!

Good morning, Raziela

Quick answer = no

Longer answer = Refer to Arul's answer

My question is not why the item number is so long, but why, based on what you've shown us, is it padded with 0's.  This is not something that Maximo does, so I assume that it's from an external system.  If the 00000000 is a fixed length, I would encourage that you have these stripped off on the inbound transactions, and put back on the outbound, since most time we cannot get the external system fixed.

Hi everyone,

In the Work Order Tracking application, under the Plans → Materials tab, we are trying to improve how ITEMNUM is displayed.

Currently, the ITEMNUM field contains long values like 0000000064895214. In the UI, only the first part of the value is visible (e.g., 00000000), and we have to right-click or hover to see the rest.

What we want is for the last 8 digits (e.g., 64895214) to be visible directly in the same field (ITEMNUM) in the UI - without altering the actual stored value. The full item number should remain intact in the backend and available when the user right-clicks or drills in - we just want the UI to show the last 8 digits instead of the first.

Is there any way to control this - maybe via a relationship, field mask, view, or formatting trick - to change what part of the string is rendered in the field, without creating a new field or modifying the stored data?

Thanks in advance for any guidance or workaround ideas!

Hi everyone,

In the Work Order Tracking application, under the Plans → Materials tab, we are trying to improve how ITEMNUM is displayed.

Currently, the ITEMNUM field contains long values like 0000000064895214. In the UI, only the first part of the value is visible (e.g., 00000000), and we have to right-click or hover to see the rest.

What we want is for the last 8 digits (e.g., 64895214) to be visible directly in the same field (ITEMNUM) in the UI - without altering the actual stored value. The full item number should remain intact in the backend and available when the user right-clicks or drills in - we just want the UI to show the last 8 digits instead of the first.

Is there any way to control this - maybe via a relationship, field mask, view, or formatting trick - to change what part of the string is rendered in the field, without creating a new field or modifying the stored data?

Thanks in advance for any guidance or workaround ideas!

Ideas already mentioned sound good and may work for you. If they don't...

Another alternative is to create a non-persistent attribute on Item and put an automation script on its attribute initialization launch point that would read the item number and set itself (the attribute) to that item number with the leading zeros removed. You could do the same in other places where an Item number is needed but add another launch point to format and forward value updates to the real item number attribute.

Hi everyone,

In the Work Order Tracking application, under the Plans → Materials tab, we are trying to improve how ITEMNUM is displayed.

Currently, the ITEMNUM field contains long values like 0000000064895214. In the UI, only the first part of the value is visible (e.g., 00000000), and we have to right-click or hover to see the rest.

What we want is for the last 8 digits (e.g., 64895214) to be visible directly in the same field (ITEMNUM) in the UI - without altering the actual stored value. The full item number should remain intact in the backend and available when the user right-clicks or drills in - we just want the UI to show the last 8 digits instead of the first.

Is there any way to control this - maybe via a relationship, field mask, view, or formatting trick - to change what part of the string is rendered in the field, without creating a new field or modifying the stored data?

Thanks in advance for any guidance or workaround ideas!