Filter Out Decommissioned and NotReady Locations in the Location Lookup

Written by Chon Neth, Editor-in-Chief

Question

Prevent Decommissioned and Not Ready locations from getting displayed in the locations lookup

Answer

Workaround:
1. Go to the domains application. Create a new Table domain
click New Row button. Enter the following:

DOMAIN: OPERATINSTATUS

Object: LOCATIONS

List Where Clause:
siteid=:assetsiteid and status in (select value from synonymdomain where domainid=’LOCASSETSTATUS’ and maxvalue=’OPERATING’)

Validation Where Clause:
siteid=:assetsiteid and status in (select value from synonymdomain where domainid=’LOCASSETSTATUS’ and maxvalue=’OPERATING’)

Error Message Key NotValidLoc

Error Message Group locations

NOTE: all these fields are case sensitive

2. Go to database configuration application
search for Object=SR and attribute=LOCATION

3. On the location attribute, enter OPERATINSTATUS in the domain field

4. Shut down the Maximo Server

5. Run the ConfigDB.bat under Maximo\Tools\Maximo directory

6. Restart the Maximo Server

7. Go to the Create Service Request application, click on the Select Value besides the Location field. Now you will only see locations that are in Operating status

i.e. You will not see any location that has NOT READY / DECOMMISIONED status [IBM Support]

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobile, EZMaxPlanner and EZMaxRequest.

Find Out More

2 thoughts on “Filter Out Decommissioned and NotReady Locations in the Location Lookup”

  1. Hi! I followed these steps and was able to filter DECOMMISSIONED Locations from the “Select Value” option. However, I can still select them from the “Open Drilldown” option. Is this a bug? Is there a way to filter them too from “Open Drilldown” option?

    TIA!

  2. As the drilldown is controlled via a java class and is not populdated via the domain a Java customization would be required. We opted to remove the drilldown option for the user when selecting locations in places like Work Orders

Leave a Reply