USP_DATALIST_PROGRAMPREFERENCEGROUP

Returns a list of preference groups for a given program.

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_PROGRAMPREFERENCEGROUP
                (
                    @PROGRAMID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        PROGRAMPREFERENCEGROUP.ID, 
                        PROGRAMPREFERENCEGROUP.NAME, 
                        dbo.UDA_BUILDLIST(PROGRAMPREFERENCE.NAME)
                    from dbo.PROGRAMPREFERENCEGROUP
                    left join dbo.PROGRAMPREFERENCE 
                        on PROGRAMPREFERENCE.PROGRAMPREFERENCEGROUPID = PROGRAMPREFERENCEGROUP.ID
                    where PROGRAMPREFERENCEGROUP.PROGRAMID = @PROGRAMID
                    group by PROGRAMPREFERENCEGROUP.NAME, PROGRAMPREFERENCEGROUP.ID
                    order by PROGRAMPREFERENCEGROUP.NAME;