Make location inactive?

[Heather White]

Good morning,

      Is there a way to make locations inactive in ServiceNow?   We imported current(updated) locations from AD and users now have the correct locations within their company.   However, the "old" locatoins are still available in the drop down menu.   We do not want users to see these depricated locations.

Thank you!

Heather

[EricMiller]

Chuck,

This is something that I have learned from you by watching you create custom tables for applications.  I have this issue and determined that this is what I would need to do.  I looked it up in the community just to be sure and here we are.  Thank you for this post!  With this and some reference qualifiers I will be able to hide some locations on my SP forms without deleting any data.

-Eric

[wefw]

CHUCK, 

what is the scriot that should be used in business rule

[G24]

I think Chuck was suggesting that you pull up the existing "user query" business rule and use that as an example.  It looks like this:

Reference Guide for addActiveQuery() 

[Cheyenne1]

On your Location Reference field you can put a reference qualifier (reference qual condition) to only show certain locations.

For example you could create a new field on the location form and point your reference field to show only those that are checked ('true')

[Chuck Tomasi]

Great idea Cheyenne,

FWIW, a reference qualifier was my first idea, but then realized you would have to make it available on all fields that reference cmn_location, which could be a rather large effort. A before query business rule acts more like a "global" reference qualifier.

Thanks for bringing up the option - in the event this only applies to one field, this is a great solution. We just covered reference qualifiers on yesterday's TechNow episode #36.

TechNow Episode List