Automation Script Quick Reference

Here are some of the quick reference guide for every maximo developer.

Before we begin with some example, you must be aware of automation script implicit variables. Please refer to this post for detailed explanation of the implicit variables. 

How to get current month records since first date in database query?

To get the records for the current month since day one of current month you may use the below where clause.

How to create a custom Auto-Number for attribute in Maximo

Follow the below steps to add autonumber for the attribute and add seed and key to the autonumber.

Show current status memo for records in Maximo

Objective:

To display the status memo of the current status in record.

For any object having status functionality the status history is tracked in different table, for example Work Order status will be tracked in WOSTATUS table.

To display the memo entered for the current status in the application can be done using relationships and application designer application.

How to pull a value through relationship in result set portlet in start center?

For selecting columns to display in the result set portlet we'll get the list of persistent attributes for the object that the query is based on.
This attribute list will be present in RESULTSETCOLS table. We will not get the related attributes by default.

What is REORDERMUTEX table

The REORDERMUTEX table is a locking mechanism to make sure no two users are running a Material Request, Direst Issue or Storeroom Reorder at the same time.
The REORDERPAD table is a temporary data holder to collect item information for the Reorder process.
After the Reorder process is done, data will be left in ReorderPad.
When the next Reorder is run by the same user, data will be removed from ReorderPad.
If you are sure no Reorder is running currently, you could delete data from these two tables.

Installing Eclipse Plugin for Maximo Development

Here is an eclipse plugin for IBM Maximo Asset Management customization.

Maximo Developer is an Eclipse plug-in designated for customization of IBM Maximo Asset Management System. It can help Maximo consultant or developer by automatically doing lot of boring and repetitive tasks.