Add Filter Condition - is (dynamic) not me

Dan Brown2 · ‎03-13-2019

Hi,

Quick question - in the filter conditions of a report, is there a way to add a dynamic filter of Assigned To is (Dynamic) Not Me?

thanks

Dan

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

View solution in original post

Tracy Davis · ‎03-13-2019

No, but you could try dynamic filter is one of your groups (assuming that's what you want)

and assigned to is not <enter your name> - of course that wouldn't be dynamic but would remove anything assigned to you.

Hope that makes sense.

Dan Brown2 · ‎03-14-2019

Thank you for the reply. That does makes sense.

I was hoping to create a dashboard for a team of people, where they could see a list of calls assigned to them. And then another list of all other calls not assigned to them.

Cheers.

Vera H_ · ‎09-02-2019

Helpful, but not if you want your team members to use the same filter. (e.g. I am making a dashboard for my team)

Thanks anyway for this kind of thought!

Vera H_ · ‎08-26-2019

Like this?

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