Report on Opened by's group

[ychick]

I have a client that would like to be able to report on the incidents opened by members of the Service Desk group. In looking at how Incident was configured, there is no field to capture opened by's group.

I tried using a filter Opened By is javascript : gs.isMemberOf('Service Desk'); to see if I can get any result but it is always blank.

Any ideas what I could do differently without changing form configuration to add an opened by group?

Thanks in advance for your help.

[geoff3]

You need to pass isMemberOf() a sys_id, not a name.   So look up the sys_id for your Service Desk group and use that instead.

For example: javascript:gs.isMemberOf('79fe65c3783d61007b2030c80bdaf5d9');

Note that it's not best practice to hard-code a sys_id, so if you can reference the group record in some way, that would be better.   But the above method will work.

[ychick]

Thanks for the reply. I tried using the sys_id but same thing happened. No results were returned.

[DJ11 · Accepted solution]

you could try writing a script include to get the members of the group and use it as a filter on the report.

pl refer to this post Re: Reporting on Incident Opened by a Member of a Group?

[ychick]

Thanks. I'll try that.