USP_DATALIST_CONSTITUENTRESTRICTIONOPTION

Constituent Event Restriction Option list.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONSTITUENTRESTRICTIONOPTION(@CONSTITUENTID uniqueidentifier)
                as
                    set nocount on;

                    select CONSTITUENTRESTRICTIONOPTION.ID,
                           CONSTITUENT.ID as CONSTITUENTID,
                           EVENTRESTRICTIONTYPE.ID as EVENTRESTRICTIONTYPEID,
                           EVENTRESTRICTIONTYPE.NAME as TYPENAME,
                           EVENTRESTRICTIONOPTION.ID as EVENTRESTRICTIONOPTIONID,
                           EVENTRESTRICTIONOPTION.NAME as OPTIONNAME
                    from dbo.CONSTITUENTRESTRICTIONOPTION
                    inner join dbo.EVENTRESTRICTIONOPTION
                        on EVENTRESTRICTIONOPTION.ID = CONSTITUENTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID
                    inner join dbo.EVENTRESTRICTIONTYPE
                        on EVENTRESTRICTIONTYPE.ID = EVENTRESTRICTIONOPTION.EVENTRESTRICTIONTYPEID
                    inner join dbo.CONSTITUENT
                        on CONSTITUENTRESTRICTIONOPTION.CONSTITUENTID = CONSTITUENT.ID
                    where CONSTITUENT.ID = @CONSTITUENTID
                    order by EVENTRESTRICTIONTYPE.NAME, EVENTRESTRICTIONOPTION.NAME