USP_SIMPLEDATALIST_CONSTITUENTGROUPCURRENTMEMBER

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

Parameters

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

Definition

Copy



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

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