The CreatorCon Call for Content is officially open! Get started here.

Creating a report: Group members without task assignment

MARCHI Frederic
Kilo Contributor

Hello,

Sorry if my question is not in the right place.

For processing our requests, we assign tasks to a group, as well as to a member of that group (which I believe is the standard procedure).

I am looking to create a report that lists the members of this group who have never had any tasks assigned to them (and therefore never closed any).

I tried looking into sys_user_grmember and sc_task, but apart from requests closed by users, I haven't been able to find the opposite.

Would you have a solution, please?

Thank you.

0 REPLIES 0