How to report on incidents assigned to NOT ME?

Vera H_ · ‎08-26-2019

Hello,

I would like to show 2 reports to show on a dashboard:

1. Incidents assigned to me - that's an easy one
2. Incidents assigned to all the others of my assignment group.

I was hoping there would be a NOT ME choice, but there is not. I don't want to add all the individual names, because that can change over time.

How would you filter the incidents to get this overview?

Thank you!
Vera

Alberto Consonn · ‎08-26-2019

Hi Vera,

please use the suggestion mentioned in the thread below:

https://community.servicenow.com/community?id=community_question&sys_id=759689e3dbc073c01cd8a345ca96...

There is no dynamic way.

If I have answered your question, please mark my response as correct and/or helpful so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

View solution in original post

Vera H_ · ‎08-26-2019

Can you help me how to make this script? Can I use it with a Dashboard that's for my other colleagues, like I mention in my next reply?

Vera H_ · ‎08-26-2019

Dear all,

I forgot one thing... I am making a Dashboard for me and my colleagues... as I read and try this now, there is no possibility to make the report/filter for my colleagues....? I guess that's what's meant by 'dynamic'??

Thank again,

Vera

Robert Ninness · ‎08-27-2019

I thought there should be a way to create a Dynamic Filter Option like this, but unfortunately it's not so easy. You can't just create one similar to the ME dynamic filter such as !gs.getUserID()

As mentioned above you would have to return a list of ALL users excluding the current user, which is overkill and would potentially overflow the filter character limit. There seems to be no way of changing the operator of a Dynamic Filter Option filter, it's always =.

However, you can instead use the javascript: notation on a regular filter to do something similar. e.g.

assigned_to!=javascript:gs.getUserID()

incident_list.do?sysparm_query=assigned_to!%3Djavascript%3Ags.getUserID()

Combining the two methods, is (Dynamic) One of my groups and javascript:gs.getUserID() you get something like the following:

assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744^assigned_to!=javascript:gs.getUserID()

incident_list.do?sysparm_query=assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744%5Eassigned_to!%3Djavascript%3Ags.getUserID()

Hope this helps.

~Robert

Vera H_ · ‎08-30-2019

Hello Robert,

Thank you for your elaborate answer! I'm afraid I have to get into javascript first 😉