IBM Support

Filter Out Decommissioned and Not Ready Locations

Question & Answer


Question

Is it possble to prevent decommissioned locations from being displayed in the 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. Turn on Admin mode and "Apply Database Configuration Changes" in Database Configuration application.

5. Go to the Create Service Request application, click on the "Select Value" next to the Location field. Now you will only see locations that are in operating status.

You will not see any location that has NOT READY / DECOMMISSIONED status.

Related Information

[{"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Domains","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.1;7.5","Edition":"Edition Independent","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
23 June 2018

UID

swg21407904