What’s the goal here? Hiding the “All” option in a dashboard’s Interactive Filter.
Background: In a scoped application, I have multiple dashboards that use the same interactive filter. The reports in that dashboard show values from a custom table which is updated weekly with a scheduled script execution. The day the script runs is the date added to a second custom table that contains the report run date. This is used to populate an interactive filter that is on each of these dashboards.
I found something peculiar with the way our LDAP user import was set up (or at least I felt it was a bit peculiar). We have never synched our ServiceNow users’ statuses (active/locked out) with the associated status in active directory. This rarely came up until I was asked to create a unique notification report for HR that required the knowledge if a user was active or not. This is my saga to find a way to ensure the users’ statuses in ServiceNow matched their status in active directory.
The back story (Note this was all done in our dev environment using an update set first [just in case you imagined I was doing this the fast way – directly in production.]):
Join me in my journey to create a Service Portal for the Payroll department within my company to manage requests. My goal is to chronicle this entire process so I can reference it later for future Service Portals and so you can also use it as a guide for developing your Service Portal.
With every new software application the beginning is diving directly into coding … so here we go.
Ummm, wait a minute Rick. You code first? How do you know what the heck to code?
One thing that I find challenging in creating ServiceNow forms is the absence of multi-select dropdowns. There have been many times a customer needed to have this ability and I have resorted to using a series of checkboxes (true/false field type) as my alternative. I don’t like it, but it serves the purpose. Slushbuckets are only available for catalog items and record producers so I don’t have those available.
I discovered today that the problem with this technique is the first solution I found was not the optimal solution. Fortunately I happened across a TechNow Video that enlightened me on the best way.
In this case, I am trying to get a single user record from the sys_user table. Once I get the record I then use the person’s user_name from the user object to search for a record in a custom table. So here’s the inefficient way I wasdoing it (not efficient way in orange highlight):