Maximo Open Forum

 Start Center Color Options with Date logic

  • Administration
Adam Olson's profile image
Adam Olson posted 11-02-2021 13:21
Has anyone had any luck on being able to drive Color Options for Start Center Portlets based on the current date in relationship to a Work Order field date.

I'm trying to compare the Work Orders Status Date to the Current Date, and I am able to due this using  :&datetime& in the expression field for the color options.  This works for simple comparison of the Status Date to the Current Date.  I'm looking to figure out how write the statement so that if the Work Orders status date is more that 14 days ago when compared to the System date, the row would be red.  I've tried a few ways but with no luck, any advice would be great.

Works without ability to adjust days ahead/before


Does Not Work


Thanks,
Jade Warren's profile image
Jade Warren
This cannot be done--as a workaround, I've created a non-persistent alpha or numeric field on the object (e.g. WORKORDER) and then you can use either an automation script on INIT or potentially an attribute-level Maximo formula to populate a value into the non-persistent field.  Then, you can use the start center conditions to key off the non-persistent field to get the desired coloration.
Steven Shull's profile image
Steven Shull
As Jade mentioned this isn't currently possible. This is a RFE (https://ibm-ai-apps.ideas.ibm.com/ideas/MASM-I-442) and I expect to be done when the modernization of start centers is done in MAS.
Simon Barnes's profile image
Simon Barnes

Further to other answers - this remains still and idea on the IBM Ideas - see Steven's reply for the link. 

Resolved the old school way - Create a additional attribute that is calculated based on the date 

I create Days Since and populated that and then did the > 30 = Blue; > 60 = Orange; > 90 = Red 

Rachel Rivera's profile image
Rachel Rivera

We have the same process as @Simon Barnes reported.  Our PM's are color coded: Overdue PM's are in Red set off by the Finish No Later Than. Blue for PMs that are currently to be worked on, and green for the PM's "Coming Soon" (To be scheduled and planned).  Our Assets are also set up the same color-coded.  Red when it's down and Green when RTS (returned to service). 

Jade Warren's profile image
Jade Warren

We ended up creating a non-persistent numerical attribute and using an automation script to do date calculations then set the value of that non-persistent attribute.  Then, coded the portlet based on those values...

Shannon Rotz's profile image
Shannon Rotz

My solution to was to create a non-persistent attribute as well.  I then used a database formula to set the value.  It works quite well.