Blog
How to change the color of a field using conditional expressions
This entry is part of the Conditional Expressions HowTo. Here is a step-by-step guide about how to dynamically highlight workorders that have a high priority in the WOTRACK application. This is just an example and the same configuration can be used to change the color of a field based on a particular condition. Define conditional expression Open Administration - Conditional Expression Manager application. Create the following conditional expression.
March 11, 2012
Query users and groups security
Did you have ever spent precious time searching in the Group Security application what group grants a specific permission to a certain user? Do you want to list all the sigoption granted to a specific user? Do you want to list all the groups to which a specific user belongs together with all the granted sigoptions? Do you want to know who has access to a specific application or sigoption? Here is a SQL query that may help you. It joins several tables and allows to answer all the previous questions… and many more.
March 9, 2012
Search for NULL values in Maximo applications
Today I want to share with you a little tip that allows to search for empty (NULL) values in every Maximo/TPAE application. You can search for null and not null values by entering the following values into a search field on the Find tab: To search for a null value enter: null To search for not null values enter: != null If your keyboard does not have the tilde ‘~’ character you may type enter this character by typing 126 on your numeric keypad while pressing the ‘Alt’ key. Maybe this sound obvious to you but it was not easy to discover…
March 3, 2012
Best way to loop through an MboSet
This entry is part of the Maximo Java Development series. In this article I will describe some common ways of iterating through an MboSet and what is the best approach. In the following examples mboSet is the already holding the MboSetRemote that you need to traverse. Example 1 (worst solution) for(int i=0; i<mboSet.count(); i++;){ MboRemote currMbo=mboSet.getMbo(i); ...} The MboSet.count() method will issue a SELECT COUNT(*) query to the database for each loop. This will seriously affect the looping performances with an unnecessary workload on the database server too.
February 26, 2012
Formatting and converting data in Java
This entry is part of the Maximo Java Development series. If you need to format dates and numbers into a locale-sensitive string or if you just need to convert data between different types then take a look at psdi.util.MaxType class. For example, the following piece of code shows how to correctly format a currency amount into a string. MaxType mt = new MaxType(MaxType.AMOUNT);mt.setValue(10.1234);String s = mt.asLocaleString();
February 19, 2012
Automatic login to Maximo UI
As a Maximo consultant I spend many hours on test and development systems developing customizations and testing business processes. This means I frequently login on Maximo Web UI with several users and passwords. I typically store the passwords in my web browser to speedup the annoying step but today I have found a better trick to directly jump into a Maximo application skipping the login page. This can be done providing the username and password in the URL used to connect to the web UI. Lets make some examples.
February 17, 2012
How to migrate Maximo Administrative Workstation
This article explains a procedure that can be used to migrate the Maximo 7.1 Administrative Workstation from one physical system to another. Installation of products based on Maximo/TPAE infractructure (MAM, TAMIT, CCMDB, etc.), industry specific extension (Nuclear, Transportation, etc.) or fixpacks use the IBM Autonomic Deployment Engine. This is installed at the beginning of the installation of any Maximo product and is a core part of the Maximo Administrative Workstation component.
February 15, 2012
Maximo REST APIs reference material
Legacy REST API The REST API are available in Maximo starting from version 7.5. Here is a collection of useful resources to learn how to use REST in Maximo. Official MAM REST API documentation RESTing with Maximo (developerWorks) Using REST API Details (developerWorks) Maximo REST API usage example NextGen REST API The official documentation for the ne OSLC REST APIs is available here: Maximo Integration and Scripting - IoT (ibm.com)
February 14, 2012
Set an attribute as required with no default value
This post describes how to set an object attribute as mandatory without providing a default value. This is to circumvent what it seems to be a TPAE limitation that prevents to do this from the standard Database Configuration application. Lets make an example. The out-of-the-box attribute PO.VENDOR (Purchase Order - Vendor) is not mandatory. Unfortunately if you try to set as required using the Database Configuration application you will get the following error.
February 12, 2012
How to configure data import in Maximo 7.5
In version 7.5 of Maximo/TPAE products, you can import and export data from applications. Learn how to enable this feature in this unofficial guide. There is also a nice TechNote from IBM.
February 11, 2012