USP_DATALIST_CONSTITUENTPROFILEDASHBOARDRESTRICTIONOPTIONS

This datalist returns restriction option information that is used by the constituent profile dashboard.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ISVISIBLE	bit	IN	Visible

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDRESTRICTIONOPTIONS
                (
                    @CONSTITUENTID uniqueidentifier,
                    @ISVISIBLE bit = 1
                )
                as
                    set nocount on;

                    if @ISVISIBLE = 1
                    begin
                        select
                            EVENTRESTRICTIONTYPE.NAME [EVENTRESTRICTIONTYPENAME],
                            EVENTRESTRICTIONOPTION.NAME [EVENTRESTRICTIONOPTIONNAME]
                        from 
                            dbo.REGISTRANT
                            inner join dbo.REGISTRANTRESTRICTIONOPTION on REGISTRANT.ID = REGISTRANTRESTRICTIONOPTION.REGISTRANTID
                            inner join dbo.EVENTRESTRICTIONOPTION on REGISTRANTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID = EVENTRESTRICTIONOPTION.ID
                            inner join dbo.EVENTRESTRICTIONTYPE on EVENTRESTRICTIONOPTION.EVENTRESTRICTIONTYPEID = EVENTRESTRICTIONTYPE.ID
                        where REGISTRANT.CONSTITUENTID = @CONSTITUENTID
                    end