IBM Maximo consultant, geek, agile evangelist
In this post I will show how to enable the lookup functionality for selecting one or multiple values in a report parameter.Instead of creating a new lookup I will show all the necessary configurations looking at the built-in report ‘Inventory Balance’ (inventory_balance_tbl.rptdesign). Enabling lookup in report Open the ‘Report Administration’ application and search for ‘Inventory […]
Sometimes you may develop a custom Maximo application that shows a list of entries in a table. If the application is used frequently and the result set to show is not huge, it could be useful to automatically display the table content without the need to hit enter or click on the search icon.Here is […]
I know that there is an official IBM Technote that already provides a solution to apply a default filter in a given Maximo application.However this solution has some drawbacks. The main problem I see is that using this technique the field filters are not displayed in the application so it could be tricky for the […]
This entry is part of the Maximo Java Development series. A typical need during Maximo application customization is the ability to display a message on the GUI. The first step is to define the custom message. Open the Database Configuration application and select Messages for the Action menu. Create a new entry filling the required […]
The standard Maximo ‘Security Groups’ application provides an easy way to view and modify users access to applications. However it is not always easy to have an overview of what groups are granted to access a specific application or what applications can be accessed by a specific group.With the following SQL query you can get […]
This entry is part of the Maximo Java Development series. In this post I will describe all the steps needed to execute custom Java code upon the selection of an entry in the action menu or the click of a button in the toolbar. Add a sigoption First you need to create a new sigoption. […]
This is a working Java method that can be used to execute an Oracle stored procedure. It can be linked to standard Mbo methods, application beans, actions, toolbar buttons, etc. public int callOracleProcedure(String procName, int arg1) throws MXException, RemoteException{ int ret; logger.info(“Calling ” + procName + “(” + arg1 + “)”); MXServer mxServer = MXServer.getMXServer(); […]
Here is an example of how to add the attachment capability to the organizations (MULTISITE) application. Add the ‘attachment’ control to the MULTISITE application using the Application Designer. Then add the DOCLINKS relationship to the ORGANIZATIONS object as shown in the following picture. Please check the ‘Where Clause’ statement and modify it to match your […]
During one of my consultancies I was asked how it is possible to remind one person to produce a report each month. They want to generate the PM application to generate a work order for the first working day of each month.This can be achieved with a tricky use of a ‘Time Based Frequency’ and […]
By default Maximo 6 does not show the units of measure description in the lookup dialog.To add this column you must edit the LOOKUPS.xml system configuration file.Open th Maximo Application Designer: Go To > Configuration > Application DesignerIn the dropdown box select ‘Export System XML’.Select the LOOKUPS entry and save the resulting xml file.Locate the […]