Add Validation on Change Status with Automation Scripts

Phil Runion, Technical Account Manager
February 16, 2024

Maximo can enforce business logic in many ways. Each approach has some advantages and varying levels of technical skills to implement. Requiring a field on the screen can be approached in a few different ways.

The first approach to creating required fields in Maximo is by setting a field to “required” via Application Designer; this is an easy way to make a specific field required 100% of the time in a single application. This is an excellent option for users who only interact with a single application in Maximo and for which the field is always required. The second approach is helpful when a user wants to add conditional logic to the “required” field; this can be done by using data restrictions. These data restrictions can be implemented at a security group or global level. I find that Global Data Restrictions work well most of the time. This approach is more complex than the Application Designer change because you must write a where clause. This is a go-to solution in my tool bag since they are so versatile.

Both approaches are great because they can visibly show a field as “required” in the application. These approaches are efficient in the application while still being straightforward to implement and support. A disadvantage is that when a status on a work order is changed, a field that wasn’t required in the prior status may become required in the newly updated status.  For example, a work order in WAPPR status is being moved to APPR status, and a field that wasn’t required in WAPPR status is required within APPR status; when the user goes to change the status, they will receive a generic error that a field is required. The other disadvantage is that conditional logic can only be as good as the implementor’s skills in writing a where clause.

Automation scripts shine in delivering complex logic with clear messages. Adding custom business logic on a record's status change is a great use case for automation scripts. I have used this approach on the change status of assets, work orders, service requests, purchase orders, and configuration items. I have found that automation scripts allow me to deliver targeted messages with logic that can be as complex as needed. I will share some common examples.

Launch Point

Utilizing an attribute-based launch point will allow the logic to fire each time the status changes. In the example below, I am implementing a validation of an asset change status. If you want to run the validation more often, you could use an object save launch point.

Error Message

Pairing the automation script with a Maximo Message allows for specific and flexible messages to be given to the user. For each automation script I implement, I like to have a corresponding message with a parameter to which I can pass a message. This message is configured in Database Configuration within the Messages dialog. The “{0}” will be the parameter we pass with a custom message.

Once you have a message in the automation script, you can call an error utilizing the message. Note that the first two parameters indicate the message to be used. The third parameter is an array that gets passed to the message. When called, the “{0}” in the message will replace the first string in the array. Adding a “{1}” to your message would map to the second value in the array.

service.error(“emx”,”assetStatusValidation”,[“Address are required to move to ACTVE status.”])

Examples:

Required Address When Status Changed to ACTIVE

if mbo.getString("STATUS")=="ACTIVE" and mbo.isNull("emxAddress"):

service.error(“emx”,”assetStatusValidation”,[“Address are required to move to ACTVE status.”])

Require Value for All Asset Specification When Status Changed to OPERATING

if mbo.getString("STATUS")=="OPERATING":

   mboSetAssetSpec= mbo.getMboSet("$EMXASSETSPECREQUIRED","ASSETSPEC","assetnum = :assetnum and siteid=:siteid”)

   mboAssetSpec = mboSetAssetSpec.moveFirst()

   while mboAssetSpec:

       if mboAssetSpec.isNull("ALNVALUE") and mboAssetSpec.isNull("NUMVALUE") and mboAssetSpec.isNull("TABLEVALUE"):

           service.error("emx","assetStatusValidation",["Asset Spec " + mboAssetSpec.getString("ASSETATTRID") + " is required to not be null"])

       mboAssetSpec = mboSetAssetSpec.moveNext()  

All WO Task Must be COMP to change to COMP

if (mbo.getString("STATUS") == "COMP" ):

 mboSetTask = mbo.getMboSet("$EMXWOTASK","WOACTIVITY","historyflag=0 and istask=0 and status!="COMP" and parent=:wonum and siteid=:siteid")

if (not mboSetTask.isEmpty())

service.error(“emx”,”woStatusValidation”,[“This work order has “+mboSetTask .count()+“ open child work orders that must be complete to complete this work order.”])

Share this post
Phil Runion, Technical Account Manager
February 16, 2024
IBM Maximo Tips & Tricks

More Blogs

Maximizing Business Value with IBM Maximo Application Suite Licensing Benefits

Maximizing Business Value with IBM Maximo Application Suite Licensing Benefits

In today’s fast-paced, asset-intensive industries, organizations need comprehensive solutions that enable streamlined operations, efficient maintenance, and proactive asset management. IBM Maximo Application Suite (MAS) stands out as a modular, flexible solution designed to support these goals by delivering robust enterprise asset management (EAM) capabilities. But beyond functionality, one of the key advantages of adopting MAS is its flexible and value-driven licensing model.
Read post
Transforming Facility Maintenance and Management with Maximo Application Suite

Transforming Facility Maintenance and Management with Maximo Application Suite

Keeping building assets at peak performance may seem like a never-ending process, but the right EAM can help alleviate the manual processes behind facility maintenance and management.
Read post
How Energy and Utility Companies Can Prep for Severe Weather with Maximo AI-Powered Technology

How Energy and Utility Companies Can Prep for Severe Weather with Maximo AI-Powered Technology

Weather can profoundly affect the functionality of energy and utility companies. With recent wildfires, mudslides, tornadoes, and hurricanes ravaging the United States, energy and utility companies are tasked with everything from local power restoration to utility and power line repairs. How do these companies prepare for natural disasters while proactively addressing the issues presented after the storm has passed?
Read post

Become a part of our thriving community with over 4,500 Maximo users.

MORE offers users a platform to discover valuable resources and engage in insightful discussions surrounding the intricacies of Maximo software. Connect with peers and experts to explore the depths of possibilities and enhance your expertise.