USP_SIMPLEDATALIST_SITESFORUSERINCONTEXTOFFEATURE

List of all sites in the system that a given user could interact with in the context of a specific feature (based on Role assignments).

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@FEATUREID	uniqueidentifier	IN	Feature ID
@FEATURETYPE	tinyint	IN	Feature type

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_SITESFORUSERINCONTEXTOFFEATURE
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @FEATUREID uniqueidentifier,
                    @FEATURETYPE tinyint
                )
                as
                    set nocount on;

                    select                    
                        SITESFORUSER.[SITEID] as VALUE, 
                        SITE.[NAME] as LABEL
                    from dbo.SITE 
                    inner join dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID, @FEATUREID, @FEATURETYPE) as SITESFORUSER on SITESFORUSER.SITEID = SITE.ID
                    order by 
                        SITE.[NAME];