Filter Out Decommissioned and Not Ready Locations

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.