USP_DATALIST_REGISTRANTRESTRICTIONOPTION

Registrant Event Restriction Option list.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_REGISTRANTRESTRICTIONOPTION(@REGISTRANTID uniqueidentifier)
                as
                    set nocount on;

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