How to get a report that brings info about users who have tasks assigned to them with certain status

[Erlan01]

I need to create a report using information from the sys_user table, but I also need information from sc_task, as the report needs to bring me all the users from certain groups who have tasks assigned to them and have a certain status. For example: Joe is from the accounting group and has 3 tasks assigned to him, one as work in progress, and the other two as assigned. If my report is filtered to only include users from the IT group who have tasks assigned to them with a status of closed complete or closed incomplete, Joe should not appear in this report.

[Erlan01 · Accepted solution]

The solution I found was to create a Script include client callable, accessible from all application scopes that get through a GlideRecord on sys_user_grmemberall the users from the groups I needed, and through another glideRecord, this time on sc_task, filter by scTask status, what I got from the first GlideRecord. Then in the filter report, I put the follow condition - (field )sys Id --- (operator) is one of --- (value) javascript: new API(script include) Name().functionName()