USP_TASKCATALOG_GETMETADATA

Returns the meta data for a task.

Parameters

Parameter	Parameter Type	Mode
@TASKCATALOGID	uniqueidentifier	IN
@SPECXML	xml	INOUT
@TSLONG	bigint	INOUT
@STATUSINFOHASAPPUSER	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_TASKCATALOG_GETMETADATA
(
    @TASKCATALOGID uniqueidentifier,
    @SPECXML xml output,
    @TSLONG bigint = null output,
    @STATUSINFOHASAPPUSER bit = null output
)
as
set nocount on;

select
    @SPECXML = TASKSPECXML,
    @TSLONG = TSLONG,
    @STATUSINFOHASAPPUSER = 0
from
    dbo.TASKCATALOG
where ID = @TASKCATALOGID;

declare @SPECIFICNAME nvarchar(max);

with xmlnamespaces ('bb_appfx_task' as [t])
select @SPECIFICNAME = @SPECXML.value('/t:TaskSpec[1]/t:TaskWizardInfo[1]/t:TaskStatusInfo[1]/t:SPTaskStatusInfo[1]/@SPName', 'nvarchar(max)')

if @SPECIFICNAME is not null
select 
    @STATUSINFOHASAPPUSER = 1
from 
    INFORMATION_SCHEMA.PARAMETERS P 
where P.SPECIFIC_SCHEMA='dbo' 
    and P.PARAMETER_NAME = '@CURRENTAPPUSERID'
    and P.SPECIFIC_NAME = @SPECIFICNAME;