Maximo stores labels in multiple places. When you add a label to a field, tab or section in Application Designer, Maximo stores this in the application XML in the MAXPRESENTATION table and in the MAXLABELS table. For fields, labels are stored in Database Configuration, in the Title field of the attribute (MAXATTRIBUTE table).
For example, if you open the properties of a texbox using the Application Designer you will see two fields: Label and Default Label.
If the Label field is empty this means that Maximo will use the default label as defined in Database Configuration.
If the Label field has a value it is stored both in application XML (stored in the MAXPRESENTATION table) and in the MAXLABELS table.
How labels are loaded
When an application is Maximo loads the application XML and gets the labels in the following order:
- First it looks for a label in the MAXLABELS table
- If no label is found it looks in the application XML
- If no label is found it looks (only for fields) in the title field in Database Configuration.
When this is done, Maximo caches the application definition and all the labels in its memory.
Labels in multiple languages
To translate tabs and fields log in to Maximo selecting another language on the login page. Open the desired application in Application Designer and edit the labels of the tabs or sections. Maximo stores the translated labels in L_MAXLABELS table.
For fields, use Database Configuration to translate the title and description for an attribute while logged in with the other language selected. Maximo stores the translated labels in L_MAXATTRIBUTE.
When you are using multiple languages, the process of finding each label is slightly more complicated. This is the order in which the labels are searched:
- Translated label for the current language as defined in L_MAXLABELS table
- Label for the base language as defined in MAXLABELS table
- The application XML stored in MAXPRESENTATION table
- Translated title of the field for the current language as defined in L_MAXATTRIBUTE.TITLE table
- Title of the field for the base language as defined in MAXATTRIBUTE.TITLE table
Additional details are available on this page.