Hello developers,
I want to create cases report on below condition.
I have custom securitygroups related field in case.
I want to show all cases records which securitygroups is equal to current user’s security group
Hey there,
I’ve had a look, and I don’t think it’s possible in Reports currently, if you’re using a custom “Security Group” relate field
I’ve given it a try by creating a report from the Cases/Users/Security Suite sides, but haven’t had any luck 
I don’t believe Reports currently has the ability to compare relationships across multiple modules like that, i’m afraid
The closest i’ve gotten is:
- Have a Cases report, that lists all Cases, (plus any conditions you need), and nothing around Sec Groups/Users
- Associate a Security Group to this Case via the “Security Groups” subpanel
- Associate a Role to that Security Group, with “Group” permissions on Cases
- Associate a User to that Security Group
Then, when this user views this report, they would only be able to see Cases that are related to the Security Group that they are in
Although, it doesn’t use your custom Security Group relation, so I’m not sure if this would fit your needs?