USP_DATALIST_TRIBUTE

Returns a list of tributes.
Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Include inactive tributes
@TRIBUTETYPECODEID	uniqueidentifier	IN	Type
@DATEFILTER	tinyint	IN	Date created
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEFILTERMODE	tinyint	IN	Sites
@SITESSELECTED	xml	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_TRIBUTE
                (
                    @INCLUDEINACTIVE bit = 0,
                    @TRIBUTETYPECODEID uniqueidentifier = null,
                    @DATEFILTER tinyint = 6,
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                )
                as
                    set nocount on;

                    declare @STARTDATE datetime;
                    declare @ENDDATE datetime;
                    exec dbo.USP_RESOLVEDATEFILTER @DATEFILTER, @STARTDATE output, @ENDDATE output;

                    select distinct
                        TRIBUTE.ID,
                        TRIBUTETYPE.DESCRIPTION as TYPE,
                        TRIBUTE.TRIBUTETEXT,
                        NF.NAME as TRIBUTEE,
                        TRIBUTE.TRIBUTEEID as TRIBUTEEID,
                        TRIBUTE.DATEADDED as DATECREATED,
                        TRIBUTE.ISACTIVE,
                        dbo.UFN_DESIGNATION_BUILDNAME(TRIBUTE.DESIGNATIONID) as DESIGNATION,
                        (
                            select dbo.UDA_BUILDLIST(SITE.NAME)
                            from dbo.SITE
                                inner join dbo.TRIBUTESITE on TRIBUTESITE.SITEID = SITE.ID
                            where TRIBUTESITE.TRIBUTEID = TRIBUTE.ID
                        ) as SITES
                    from
                        dbo.TRIBUTE
                    inner join 
                        dbo.TRIBUTETYPECODE TRIBUTETYPE on TRIBUTE.TRIBUTETYPECODEID = TRIBUTETYPE.ID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(TRIBUTE.TRIBUTEEID) NF
                    left join
                        dbo.TRIBUTESITE on TRIBUTE.ID = TRIBUTESITE.TRIBUTEID
                    where
                        ((@INCLUDEINACTIVE = 1) or (@INCLUDEINACTIVE = 0 and TRIBUTE.ISACTIVE = 1)) and
                        ((@TRIBUTETYPECODEID is null) or (TRIBUTE.TRIBUTETYPECODEID = @TRIBUTETYPECODEID)) and
                        ((@DATEFILTER is null) or (TRIBUTE.DATEADDED between @STARTDATE and @ENDDATE)) and
                        ((dbo.UFN_SITEALLOWEDFORUSERONFEATURE(@CURRENTAPPUSERID, TRIBUTESITE.SITEID, @SECURITYFEATUREID, @SECURITYFEATURETYPE) = 1) and
                            (@SITEFILTERMODE = 0
                                or exists(
                                    select 1
                                    from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED) SITEFILTER
                                    where TRIBUTESITE.SITEID = SITEFILTER.SITEID)
                            )
                        )
                    order by
                        TRIBUTE.DATEADDED desc,TRIBUTE.TRIBUTETEXT;