USP_DATALIST_REVENUEBATCHCONSTITUENTGROUPCURRENTMEMBER

List of the current members of a constituent group in revenue batch.

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_REVENUEBATCHCONSTITUENTGROUPCURRENTMEMBER 
                (
                  @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)

                    union all

                    select
                        coalesce(BATCHREVENUECONSTITUENT.EXISTINGCONSTITUENTID, BATCHREVENUECONSTITUENT.ID),
                        coalesce(CONSTITUENT_NF.NAME, BATCHREVENUECONSTITUENT.NAME)
                    from
                        dbo.BATCHREVENUECONSTITUENTGROUPMEMBER
                    inner join 
                        dbo.BATCHREVENUECONSTITUENT on BATCHREVENUECONSTITUENTGROUPMEMBER.MEMBERID = BATCHREVENUECONSTITUENT.ID
                    outer apply
                        dbo.UFN_CONSTITUENT_DISPLAYNAME(BATCHREVENUECONSTITUENT.EXISTINGCONSTITUENTID) CONSTITUENT_NF
                    where
                        BATCHREVENUECONSTITUENTGROUPMEMBER.GROUPID = @GROUPID

                    order by NAME