Operation Details
Description: Returns list of Users and their Active Activities Count for the Users having a role in a Case.
Sterotype: nsmulti
SQL 
SELECT
  count(Activity.activityID),
  Users.fullName,
  Users.userName
INTO
  :countActivity,
  :fullName,
  :userName 
FROM
  Activity,
  CaseHeader,
  Users,
  CaseUserRole,
  OrgObjectLink 
WHERE Activity.userName = Users.userName 
  AND OrgObjectLink.userName = Users.userName 
  AND CaseUserRole.orgObjectLinkID = OrgObjectLink.orgObjectLinkID 
  AND CaseUserRole.caseID = CaseHeader.caseID 
  AND CaseHeader.caseID = :caseID 
  AND CaseUserRole.recordStatus = :recordStatus 
  AND Activity.recordStatusCode = :recordStatusCode 
  AND Activity.startDateTime >= :startDateTime 
  AND Activity.endDateTime < :endDateTime 
GROUP
  By Users.fullName,
  Users.userName