For this scenario I wanted an option to easily open attachments without having to go to each individual record, then the attachment icon, then waiting for the dialog to open then selecting the image to open it. I wanted to save time looking at attachments for a bunch of records. (Note: This only works if there is only one attachment that you can identify to open.)

In this case we took a meter reading and have an image that goes with that meter reading in Maximo. So, there is only one image per reading.

In order to do this, you need to go to Application Designer. Find the application you want to add an image link to. Find the table you want to use and add a new tablecol to that table. Open the tablecol properties and fill out the following fields:

Type: OPENURL (Note: This was done in the xml by exporting the application and updating the field and importing the application. This value is not an option in most Maximo environments in the drop-down list for the type field)

Attribute: DOCLINKS.DOCUMENT

URL Attribute: DOCLINKS.WEBURL

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

For the Attribute and URL Attribute you can append as many relationships as you need. For our scenario we added a relationship to the MEASUREMENT table called DOCLINKS with a Child Table of DOCLINKS table that has the image. The whereclause for that relationship is “ownertable = ‘MEASUREMENT’ and ownerid = :MEASUREMENTID”. The table that we are adding the tablecol to is MEASUREMENT.

Once you have updated the application. Save your changes and go to the application. You will see an update to your table that looks like:

 

 

 

 

The underline and the blue text indicate that you can click that and the attachment will open.

Kelly Nimmo is an accomplished Maximo Developer who excels at crafting simple solutions to complex problems. Along with punishing some extremely tough customer problems, Kelly can often be found on the soccer field, demonstrating skills learned as a goalie while at Columbus State University, rejecting foolish attempts to score against her. When Kelly is not at her computer or on the field, she can be found taking orders from her golden retriever pup, Cally, or on the water hunting for the next big fish.

Leave a Reply

Your email address will not be published.