Disabling a Location

[mtaituha]

Looking to disable some locations from cmn_location table (not delete). I know you can add an Active column to the table. The issue is all reference tables are still displaying the disabled locations.

So to get around this issue can you:

Set a default view (only active locations) of the table?

Or is there an easier way of modifying all reference qualifiers for all   fields referencing   cmn_location?

Or create another table to put all locations on and push to cmn_location?

[michael_baker]

Hi Myles,

You could create a Query Business Rule on the cmn_location table to add a filter of active = true.

Hope this helps!

[Shishir Srivast]

Hello,

You can do with reference qualifier, you need to go to the dictionary of the Field by right clicking on it and under 'Reference Specification' tab set the Filer condition there. Please find the screenshots below:

and then you can provide the Reference Qual condition, on what condition you want to display the location.

[Harsh Vardhan]

Hi

May i know how did you disable the location? because "Active" field does not exist in cmn_location table.

have your created any custom field and based on that you are disabling it . if yes then you can simply use "Simple Reference Qualifier" as explorenow has already mentioned in above screenshot.

condition filter should be "Active is True"

In my org we have created custom "Active" field and we used that to make location disable.