Sometimes you may need to allow some users to update only few fields. This may be hard to achieve using conditional UI and conditional expressions. In the following snippet I’m setting all fields as readonly except DESCRIPTION and STATUS if the current user is in MANSUP security group. Attach the script to the Initialize event […]
The importance of ‘sameas’ in Database Configuration
An often misused feature of Maximo Database Configuration is the ‘Same as Object’ and ‘Same as Attribute’ fields when defining custom database attributes. To understand how this works lets consider the ASSET.LOCATION attribute. As you can see from the screenshot below, the LOCATION column of the ASSET table is defined ‘same as’ LOCATIONS.LOCATION’ field. The […]
Route Workflow error in cloned applications
Maximo Everyplace is the quick way-to-go to provide access to mobile devices for IBM Maximo. It is basically a slightly changed look and feel of the standard web interface with a dedicated start center that is automatically displayed when logging from a mobile web browser. Obviously it works only in online mode but is straightforward […]
Reset all meter readings
On a development/test environment today I had to reset all meter readings. Maximo is storing the last readings in a set of fields of the ASSETMETER table and the reading history in the METERREADING table. Here are the SQL statements I have used. delete from meterreading; update assetmeter set lastreading=0, lastreadingdate=null, sincelastrepair=0, sincelastoverhaul=0, sincelastinspect=0, sinceinstall=0, […]
Improved Automation Scripts application
Maximo automation scripts are a very useful tool to implement custom business logic for your customer. After time you may have many scripts to maintain and it may become hard to understand all the logic you have implemented on a specific object. I easy and useful trick I always use is to modify the Automation […]
Special automation scripts .NEW .SAVE .DUPLICATE
I want to share a small trick I have learned from this presentation. It is an undocumented feature of Automation Scripts that will automatically launch a script based on a special naming convention. For example if you want to run a script each time a ASSET object is saved you just have to create an […]
Implement a Refresh List button
We all know IBM Maximo is not a monitoring console and has no auto-refresh feature in the start center or in the applications. However, in some situations, we may need a Refresh button to reload the content of a table in a Maximo application. In this example I have added a button to refresh the […]
How to correctly define a Table Domain
Have you ever wondered what’s the difference between ‘Validation Where Clause’ and ‘List Where Clause’ in the Maximo Table Domain definition dialog? I believe this is one of the most common misused features in Maximo. I have see so many times tables domains defined in the wrong way. Let me show a good example of […]
Maximo escalations demystified (3/3) Monitoring execution
In the two previous posts (first, second) about escalations we have seen what are escalations and how to tune them. In this post will give you some hints bout how to monitor escalation execution.We know that escalations are background tasks to execute actions on a specific set of records. Some of these actions may be […]
Maximo escalations demystified (2/3) Performances and the ‘repeat’ option
In our first Maximo escalations demystified post I have described the general functionality of Escalations. We will now dig into some details that will help you using this powerful feature at its best. The Repeat flag When defining an escalation you always have to create an escalation point and then you can assign actions and […]