USP_DATALIST_ADVOCACYGETACIONITEMSBYSITECONTENTANDCONSITITUENTID
Get ActionItems By SiteContentID And ConsitituentID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SITECONTENTID | int | IN | SITECONTENT ID |
| @CONSTITUENTID | uniqueidentifier | IN | CONSTITUENT ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_ADVOCACYGETACIONITEMSBYSITECONTENTANDCONSITITUENTID
(
@SITECONTENTID int,
@CONSTITUENTID uniqueidentifier
)
as
set nocount on;
select
ACTIONITEMID, DATEADDED
from
dbo.ADVOCACYACTIVITY
where
SITECONTENTID = ISNULL(@SITECONTENTID,SITECONTENTID)
And
CONSTITUENTID = ISNULL(@CONSTITUENTID,CONSTITUENTID)