USP_DATALIST_ADVOCACY_PETITION

CREATE procedure dbo.USP_DATALIST_ADVOCACY_PETITION
(
      @ACTIONITEMID uniqueidentifier = null,
        @CONSTITUENTID uniqueidentifier = null,
    @SITECONTENTID int = null
) with execute as owner
as
    set nocount on;

    select 
        A.[ID],
        A.[CONSTITUENTID],
            (CASE A.ISANONYMOUS WHEN 1 THEN 'Anonymous' ELSE C.NAME END) as [NAME],
        A.ACTIONITEMID,
        A.SITECONTENTID,
        A.DATEADDED,
        A.FEDERALDISTRICTCODE,
        A.UPPERSTATEDISTRICTCODE,
        A.LOWERSTATEDISTRICTCODE

    from 
        dbo.ADVOCACYPETITION A
        INNER JOIN dbo.CONSTITUENT C
        ON A.CONSTITUENTID = C.ID
    where
        A.ACTIONITEMID = ISNULL(@ACTIONITEMID,A.ACTIONITEMID)
        AND A.CONSTITUENTID = ISNULL(@CONSTITUENTID,A.CONSTITUENTID)
    AND A.SITECONTENTID = ISNULL(@SITECONTENTID,A.SITECONTENTID)