USP_QUEUEPROCESS_GETBYID

Retrieves a queue business process from the database.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_QUEUEPROCESS_GETBYID(@ID uniqueidentifier)
as
    set nocount on;

    select QUEUEPROCESS.NAME,
        QUEUEPROCESS.DESCRIPTION,
        QUEUEPROCESS.STEPLISTXML,
        QUEUEPROCESS.ADDEDBYID,
        QUEUEPROCESS.CHANGEDBYID,
        QUEUEPROCESS.DATEADDED,
        QUEUEPROCESS.DATECHANGED, 
        BUSINESSPROCESSINSTANCE.SITEID
    from dbo.QUEUEPROCESS
    left join dbo.BUSINESSPROCESSINSTANCE on BUSINESSPROCESSINSTANCE.BUSINESSPROCESSPARAMETERSETID = QUEUEPROCESS.ID
    where QUEUEPROCESS.ID = @ID;