New report where "Created by" user is part of a specific group

[khalito]

Dear community,

I hope you can help me with this little problem of mine.

I am trying to create a report that gives me the list of all service catalog tasks (SCTASK) where the users who initiated the request are part of a specific group. So, in the example below, instead of saying "Request.Created by is one of A123456, A987654" I would like to say "Request.Created by.Groups is one of ABC, DEF"

I thought I could do this with "Related List Conditions" but I did not find anything there. And when I dot-walk to the "Created by" or "Requested for" fields, I am not to select anything that would bring up the user's group membership...

[Runjay Patel]

Hi @khalito ,

You can do something like below, which give you list of record created by logged in user and groups belongs to.

[khalito]

Dear @Runjay Patel ,

thank you for your suggestion! I think your solution would give me something slightly different from what I need. The conditions that you listed would return the list of SCTASKs that are assigned to one of the current user's assignmentgroups. But what I need is to specifiy a static assignment group, not a dynamic one. 

In pseudo code I would need a condition that would read like

      "Created by.Assignment groups contains Group ABC, Group DEF"

It seems like there is no native way to do this without a script...