How to filter a group from the Opened by" field on a report?

[Vin_cius Freire]

I'm trying to great a report to get the requests opened by 2 groups from a department. I can't get the group from the "Opened by" field, and I'm trying to find the best place to use some script o get this information

[tiagomacul]

HI Vinícios,

 Probally you're talking about:

01.

02. 

03. Select your group

04. Configure > Choose Columns

05. 

[Vin_cius Freire]

Tiago,

Let me clarify my problem

I am building a report that need to verify the Equested items opened from 2 groups that are assingned to another group.

I am already using the assignment group field to filter the recipient group of those RITMs. I need to filter the groups from the other side, which are the groups of the users that opened the RITMS.

[bammar]

One thing I had to do in the past that works for folks in 1 group or want to count all incidents closed by the them in one group is as follows.

I added a field in user table called Primary Group- then When i set a user up say in Desktop Group as a member - I populate that Primary group reference field in their user record. - this also helped when a user closedan incident and they didnt put in a group- we programmed Primary group to backfill in automatically to help on reports

Now I can go run reports on say Show all incident where Opened By.Primary Group = Desktop

I just got another idea...

The only other way i can think of is if you can get some javascript dynamic code or filter in the report- Opened by is Dynmic- Member of Group - Desktop - i want to say this exist now in reports filtering by default and you can find those incidents...

[Vin_cius Freire]

Bammar

I'm trying to avoid customizations on the ITSM forms, we already do a lot of them to attend the company standards and processes. This is to avoid more problems on version updates. But your idea is really good, and i'll propose them to the manager.

The script seems a good idea, like, getting the sys_user_grmember in some way I couldn't find yet