USP_DATALIST_WORKFLOW_INBOX_ASSIGNMENT

Returns all Workflow Inbox Assignment records.

Parameters

Parameter	Parameter Type	Mode	Description
@WORKFLOWINBOXID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



create procedure dbo.USP_DATALIST_WORKFLOW_INBOX_ASSIGNMENT

@WORKFLOWINBOXID uniqueidentifier 

as
    set nocount on;


      select 
        WFIA.[ID],
        WFIA.[ASSIGNMENTTYPECODE],
        WFIA.[APPUSERID],
        WFIA.[SYSTEMROLEID],
        WFIA.ASSIGNMENTTYPE,

        COALESCE(
        CASE WHEN APPUSERID IS NOT NULL THEN
            (SELECT CASE WHEN DISPLAYNAME ='' THEN USERNAME ELSE DISPLAYNAME END FROM dbo.APPUSER as AU WHERE AU.ID=WFIA.APPUSERID)
          WHEN SYSTEMROLEID IS NOT NULL THEN
            (SELECT NAME FROM dbo.SYSTEMROLE as SR WHERE SR.ID=WFIA.SYSTEMROLEID)

            END , '') AS [ASSIGNEDTO]



    from 
        dbo.BBWORKFLOWINBOXASSIGNMENT as WFIA

    where WFIA.BBWORKFLOWINBOXID=@WORKFLOWINBOXID

        ORDER BY ASSIGNMENTTYPE,ASSIGNEDTO    ;