USP_DATALIST_RESEARCHGROUPHEADER

List of header information for a research group.

Parameters

Parameter	Parameter Type	Mode	Description
@RESEARCHGROUPID	uniqueidentifier	IN	Research Group ID
@REPORTUSERID	nvarchar(128)	IN
@ALTREPORTUSERID	nvarchar(128)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATALIST_RESEARCHGROUPHEADER
(
    @RESEARCHGROUPID uniqueidentifier,
    @REPORTUSERID nvarchar(128) = null,
    @ALTREPORTUSERID nvarchar(128) = null,
  @CURRENTAPPUSERID uniqueidentifier = null

)
as
    set nocount on;

  if @CURRENTAPPUSERID is null
        set @CURRENTAPPUSERID = dbo.UFN_APPUSER_GETREPORTAPPUSERID(@REPORTUSERID, @ALTREPORTUSERID);

    select 
        RESEARCHGROUP.ID,
        RESEARCHGROUP.NAME,
        RESEARCHGROUP.DESCRIPTION,
        APPUSER.DISPLAYNAME as OWNER,
        RESEARCHGROUP.NUMMEMBERS,
    @CURRENTAPPUSERID CURRENTAPPUSERID
    from 
        dbo.RESEARCHGROUP
        left join dbo.APPUSER on APPUSER.ID = RESEARCHGROUP.OWNERID
    where RESEARCHGROUP.ID = @RESEARCHGROUPID