USP_DATALIST_REGISTRANTPREFERENCES

Displays the preferences for the given registrant.

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_REGISTRANTPREFERENCES
                (
                    @REGISTRANTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        REGISTRANTPREFERENCE.ID,
                        dbo.UFN_EVENTPREFERENCEGROUP_GETNAME(EVENTPREFERENCE.EVENTPREFERENCEGROUPID),
                        EVENTPREFERENCE.NAME
                    from 
                        dbo.REGISTRANTPREFERENCE
                        inner join dbo.EVENTPREFERENCE on EVENTPREFERENCE.ID = REGISTRANTPREFERENCE.EVENTPREFERENCEID
                    where                         
                        REGISTRANTPREFERENCE.REGISTRANTID = @REGISTRANTID
                    order by
                        REGISTRANTPREFERENCE.DATEADDED;