USP_SIMPLEDATALIST_DOCUMENTLIBRARY

DocumentLibrary Simple Data List

Parameters

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

Definition

Copy



create procedure dbo.USP_SIMPLEDATALIST_DOCUMENTLIBRARY(
  @CURRENTAPPUSERID uniqueidentifier=null
)as

  declare @ClientUserId int

  select @ClientUserId=cu.ID from dbo.BBNCUSERMAP map
    join dbo.ClientUsers cu on cu.UserName=map.BBNCUSERNAME
    where map.ID=@CURRENTAPPUSERID

  declare @temp table (Title nvarchar(200))

  insert @temp exec USP_DATALIST_DOCUMENTLIBRARY @ClientUserId

    select 
        Title as VALUE, 
        Title as LABEL
    from @temp
    order by Title