USP_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBERSITES

List of all sites in the system that a given user could interact with (based on Role assignments) and any sites assigned to the charity claim reference number that the user does not otherwise have access.

Parameters

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

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBERSITES
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @CHARITYCLAIMREFERENCENUMBERID 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
                    union
                    select
                        CHARITYCLAIMREFERENCENUMBERSITE.SITEID as VALUE,
                        SITE.NAME as LABEL
                    from
                        dbo.CHARITYCLAIMREFERENCENUMBERSITE
                        inner join dbo.SITE on SITE.ID = CHARITYCLAIMREFERENCENUMBERSITE.SITEID
                    where
                        CHARITYCLAIMREFERENCENUMBERSITE.CHARITYCLAIMREFERENCENUMBERID = @CHARITYCLAIMREFERENCENUMBERID
                    order by
                        LABEL