Question & Answer
How do I set field defaults in Maximo?
There are three ways to set a field default in Maximo.
The first way is to set a field default at the database level using Database Configuration.
To set a field default in Database Configuration:
Select the object the attribute exists in.
Select the attribute for which the default is to be set.
Expand the details of the attribute.
In the right hand side of the Details section there is a Default field.
This is where you would enter your literal value for the default value.
There are also three system defaults that work in the Database Configuration Default field.
&SYSDATE& - This will default a field with the current system date/time
&USERNAME& - This will default a field to the current USERID value
&AUTOKEY& - This is used for attributes that are set to autonumber to default to the next autonumber value.
&PERSONID& - This will default the current user's PERSONID value.
Note: The four system defaults will only work in Database Configuration.
The second way to set a field default in Maximo is by using a Default Object in Application Designer.
To set a default at an application level using Application Designer:
Launch Application Designer.
Select the application in which you want to set a default.
From the Select Action menu, select the Toggle/Show All Controls option.
Select the Tab of the application the field exists on.
Select the Control Palette icon and drag and drop a Default Object object to the section the field you want to set the default on exists in.
You will then see an object defaultvalue… just below the section header for that section.
Highlight the defaultvalue… and select the Control Properties icon.
Enter the attribute for the field you want to set the default value for, this value can be found by looking at the properties for the field.
Also enter the default value for the field.
Once these values are entered in the properties for the default object, the attribute and default will display for the default object in the section.
If additional defaults for other fields are desired, drag and drop a new default object for each field and repeat the steps for filling out the properties.
The system defaults of &USERNAME&, &SYSDATE&, and &AUTOKEY& will not work using the second method.
To default a field with the value of another field:
In the Object Default properties, leave the Value field enpty and enter a value in the From Data Source ID field for example MAINRECORD and in the From Attribute field enter the attribute value of the field you want to take the value from.
The third method requires the use of a SQL tool. There is an appfielddefaults table in Maximo which allows you to set a default by application, group and/or user. The object and default values are required, but you can then specify a certain app that uses that object or security group or user you want to have a particular default value.
Once your record(s) are inserted in the appfielddefaults table, you will need to restart the Maximo application server for your changes to take effect.
13 April 2021