USP_DATALIST_ADVOCACYLOG

CREATE procedure dbo.USP_DATALIST_ADVOCACYLOG
(
    @ADVOCACYLOGID int = NULL,
    @CONSTITUENTID uniqueidentifier = NULL,
    @ACTIONITEMID uniqueidentifier = NULL,
    @SITECONTENTID int = NULL
)
as
    set nocount on;

    select ID,
           ADVOCACYLOGID,
           ACTIONITEMID,
           CONSTITUENTID,
           SITECONTENTID,
           LEGISID,
           STATUS,
           SERVERDATEUPDATED

    from dbo.ADVOCACYLOG
    where ADVOCACYLOGID = ISNULL(@ADVOCACYLOGID,ADVOCACYLOGID)
    AND CONSTITUENTID = ISNULL(@CONSTITUENTID,CONSTITUENTID)
    AND ACTIONITEMID = ISNULL(@ACTIONITEMID,ACTIONITEMID)
    AND SITECONTENTID = ISNULL(@SITECONTENTID,SITECONTENTID)