USP_DATALIST_EVENTRESTRICTIONOPTION

Lists options for a restriction type.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_EVENTRESTRICTIONOPTION
                (
                    @EVENTRESTRICTIONTYPEID uniqueidentifier
                )
                as
                    set nocount on;

                    select EVENTRESTRICTIONOPTION.ID,
                           EVENTRESTRICTIONOPTION.NAME,
                           EVENTRESTRICTIONOPTION.DESCRIPTION
                    from dbo.EVENTRESTRICTIONOPTION
                    where EVENTRESTRICTIONOPTION.EVENTRESTRICTIONTYPEID = @EVENTRESTRICTIONTYPEID
                    order by EVENTRESTRICTIONOPTION.NAME