USP_DATALIST_EVENTPREFERENCEGROUPS
Returns a list of preference groups for a given event.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_EVENTPREFERENCEGROUPS
(
@EVENTID uniqueidentifier
)
as
set nocount on;
select
EVENTPREFERENCEGROUP.ID,
EVENTPREFERENCEGROUP.NAME,
dbo.UDA_BUILDLIST(EVENTPREFERENCE.NAME)
from
dbo.EVENTPREFERENCEGROUP
left join dbo.EVENTPREFERENCE on EVENTPREFERENCE.EVENTPREFERENCEGROUPID = EVENTPREFERENCEGROUP.ID
where
EVENTPREFERENCEGROUP.EVENTID = @EVENTID
group by
EVENTPREFERENCEGROUP.NAME, EVENTPREFERENCEGROUP.ID
order by
EVENTPREFERENCEGROUP.NAME;