- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-22-2016 01:58 PM
We've recently run into a situation where we need to retire some departments in ServiceNow. Unlike a lot of other tables (users, groups, etc...) I don't see an active field on the default department table. I want to preserve the departments since they are currently referenced in lots of areas like on requested item records, but I don't want them to appear anymore in lists and things like that. I thought about adding a custom Active checkbox and creating an on query BR similar to the "user query" business rule to basically hide the in active departments.
Has anyone ever done this and if so did it work as anticipated? Does anyone have another more elegant solution they've implemented?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-22-2016 02:03 PM
Hi Chase,
You're on the right track. Two options that I see - the first is what you said. Create an Active field (true/false) and use a before/query business rule. The kicker is that it's going to filter for all queries on that table (unless you add a check to only filter for non-admin roles, etc.)
Option 2 is to also create an active field, then find all the references to that field and add reference qualifiers where necessary. While it sounds like more work, it's a bit more surgical.
It really depends if you want the default to be filtered and modify the BR to make exceptions, or make the default be unfiltered and have each field do the filtering.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-11-2025 05:59 AM
It's 2025 and i ended up on a topic of 2016... still no out of the box solution.
