UFN_FUNDRAISINGGROUP_COMMUNICATIONSENTNUMBER
Calculate group number of communication sent.
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_FUNDRAISINGGROUP_COMMUNICATIONSENTNUMBER
(
@ID uniqueidentifier
)
returns int
with execute as caller
as begin
return (
SELECT COUNT(ID)
FROM FAFCOMMUNICATIONSLOG
WHERE CLIENTUSERSID IN (
SELECT dbo.UFN_CLIENTUSERID_GET_BY_CONSTITUENT(CONSTITUENTID) FROM REGISTRANT
WHERE ID IN (SELECT REGISTRANTID FROM dbo.UFN_REGISTRANT_GROUPMEMBERLIST() WHERE GROUPID= @ID)
)
)
end