USP_SIMPLEDATALIST_SITESFORUSER

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

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_SITESFORUSER(@CURRENTAPPUSERID uniqueidentifier)

as                

    set nocount on;

    select 

        SFU.[SITEID] as VALUE, 
        SITE.[NAME] as LABEL 

    from 

        dbo.SITE inner join dbo.UFN_SITESFORUSER(@CURRENTAPPUSERID) AS SFU
        ON SFU.SITEID=SITE.ID

    order by 
        SITE.[NAME];