USP_DATALIST_REGISTRANTRESTRICTIONOPTIONSRELATIONAL

Retrieves the restriction options for the registrant and guests of the registrant.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_REGISTRANTRESTRICTIONOPTIONSRELATIONAL
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select
    REGISTRANT.ID,
    null [PARENTID],
    REGISTRANT.EVENTID,
    REGISTRANT.CONSTITUENTID,
    dbo.UFN_REGISTRANT_GETNAME(REGISTRANT.ID) [REGISTRANTNAME],
    null [REGISTRANTRESTRICTIONOPTIONID],
    null [EVENTRESTRICTIONTYPEID],
    null [EVENTRESTRICTIONTYPENAME],
    null [EVENTRESTRICTIONOPTIONID],
    null [EVENTRESTRICTIONOPTIONNAME],
    0 [ROWTYPE],
    REGISTRANT.ID [ROWID]
  from 
    dbo.REGISTRANT 
  where 
    REGISTRANT.ID = @ID
    or REGISTRANT.GUESTOFREGISTRANTID = @ID

  union all

  select
    REGISTRANT.ID,
    REGISTRANT.ID [PARENTID],
    REGISTRANT.EVENTID,
    REGISTRANT.CONSTITUENTID,
    null [REGISTRANTNAME],
    REGISTRANTRESTRICTIONOPTION.ID [REGISTRANTRESTRICTIONOPTIONID],
    EVENTRESTRICTIONTYPE.ID [EVENTRESTRICTIONTYPEID],
    EVENTRESTRICTIONTYPE.NAME [EVENTRESTRICTIONTYPENAME],
    EVENTRESTRICTIONOPTION.ID [EVENTRESTRICTIONOPTIONID],
    EVENTRESTRICTIONOPTION.NAME [EVENTRESTRICTIONOPTIONNAME],
    1 [ROWTYPE],
    REGISTRANTRESTRICTIONOPTION.ID [ROWID]
  from 
    dbo.REGISTRANT 
    inner join dbo.REGISTRANTRESTRICTIONOPTION on REGISTRANT.ID = REGISTRANTRESTRICTIONOPTION.REGISTRANTID
    inner join dbo.EVENTRESTRICTIONOPTION on EVENTRESTRICTIONOPTION.ID = REGISTRANTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID
    inner join dbo.EVENTRESTRICTIONTYPE on EVENTRESTRICTIONTYPE.ID = EVENTRESTRICTIONOPTION.EVENTRESTRICTIONTYPEID
  where 
    REGISTRANT.ID = @ID
    or REGISTRANT.GUESTOFREGISTRANTID = @ID
  order by 
    ROWTYPE, 
    REGISTRANTNAME, 
    EVENTRESTRICTIONTYPENAME, 
    EVENTRESTRICTIONOPTIONNAME