How to Change the Drilldown limit

Overview :The Location Drilldown in Enterprise Suite is configured to display only the first 50 children for a parent. This document provides instructions on how to change that limit.

The Drilldown is a very effective tool when used to search through a symmetrically shaped hierarchy. For, example, using a classic 1 to 7 hierarchy, where Locations in a hierarchy have an average of 7 children, a 7 level hierarchy will contain 135,000 Locations. In this case, Locations can be found very quickly using the Location drilldown with just a few mouse clicks and very little scrolling. If a hierarchy is structured such that some individual Locations have a great number of child Locations, however, it may be easier to search using the Select Location action. The Select Location dialog allows you to use filters to quickly find a Location by specifying information contained in the Location code, the Location name and the Organization and Site ID, or combinations thereof.

To make it more efficient to browse through a hierarchy in the Drilldown, Maximo allows you to set a limit on the number of children that are displayed in each level in the hierarchy. By default, this limit is set at 50, meaning that if you have a Location that has more than 50 children, when you click on the plus sign to display that Locations children, Maximo will display the first 50 children of the Location and then will display a message informing you that there are more children in the hierarchy than those that are displayed for that parent.

If you desire, you may change the limit on the number of children displayed for a Location or an Asset in the Drilldown dialog:
1. Go to the Application Designer application
2. Select the Action "Export System XML"
3. Highlight the line Library in the Export System XML dialog and click on the Export XML icon,.

4. Using the "save as" option, save two copies of this file. Name one of them library.xml and the other library.xml.bk, which will serve as a backup.
5. Open library.xml in a text editor
6. Find the string <tree relationship="LOCATIONS"
7. insert maxchildren="200" directly after it.

Note: this will change the display limit for Location children to 200. You may designate another limit by selecting another numeric value.

Note: You should find only one "non commented" occurrence of the string

<tree relationship="LOCATION"

The changed section of the library.xml file should look like the section below. The inserted string is shown in bold:

8. Find the string <tree relationship="ASSET"
9. insert maxchildren="500" directly after it.

Note: this will change the display limit for Asset children to 500. You may designate another limit by selecting another numeric value.

Note: You should find only one “non commented” occurrence of the string

<tree relationship="ASSET"
10. Save library.xml
11. On the Application Designer main tab, select the Import icon, and browse to the library.xml file that you have updated.

12. Click OK to import the file.

Error Message While Using Locations Drilldown (Maximo 7.5)

Procedure:

- Login to Maximo

- Go to System Configuration > Platform Configuration > Application Designer

- Select Action > Export System XML

- From Export System XML box, select LIBRARY and click on Export XML icon.

- The XML file opens up in an other browser session. Save it in to the disk. Save it again in an other location, so you are going to have a backup of your original LIBRARY.XML.

- Open the XML using a text editor.

- Search for id="locations_tree" or relationship="LOCATIONS"

- To set the limit to 500, insert the text maxchildren="500" after relationship="LOCATIONS"

- Now the xml should be like this:
<tree beanclass="psdi.webclient.beans.common.DrilldownTreeBean" checkfornewnodes="true" height="150" id="locations_tree" ignorestructurechange="true" orderby="location asc" relationship="LOCATIONS" maxchildren="500" selectfirstnode="true" width="500">

- Save.

- Go to Application Designer and click on Import Application Definition icon.  

- From Import Application Definition box, browse for the XML file you just made changes to.

- Click OK to import the file.