USP_DATALIST_CMSSECURITYGROUPTASK

Returns the tasks associated with the specified CMS Security Group

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CMSSECURITYGROUPTASK(@CONTEXTID uniqueidentifier)
                as
                    set nocount on;

                    select ID,
                           CMSSECURITYGROUPID,
                           TASKGUID
                    from dbo.CMSSECURITYGROUPTASK
                    where CMSSECURITYGROUPID = @CONTEXTID