USP_DATALIST_CONSTITUENTGROUPCURRENTMEMBER

List of the current members of a constituent group including itself.

Parameters

Parameter Parameter Type Mode Description
@GROUPID uniqueidentifier IN
@CURRENTAPPUSERID uniqueidentifier IN Input parameter indicating the ID of the current user.
@DATAFORMINSTANCEID uniqueidentifier IN
@INCLUDEGROUP bit IN

Definition

Copy


                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTGROUPCURRENTMEMBER
                    (
                      @GROUPID uniqueidentifier,
                      @CURRENTAPPUSERID uniqueidentifier = null,
                      @DATAFORMINSTANCEID uniqueidentifier = null,
                      @INCLUDEGROUP bit = 1
                    )
                    as
                        set nocount on

                        select
                            ID,
                            NAME
                        from dbo.UFN_GROUP_GETCURRENTMEMBERS(@GROUPID, @CURRENTAPPUSERID, @DATAFORMINSTANCEID, @INCLUDEGROUP)
                        order by NAME