UFN_CONFIGURATIONEXPORT_GETPROCESSINSTANCES

Retrieves steps for a specific configuration export process.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONFIGURATIONEXPORTPROCESSID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONFIGURATIONEXPORT_GETPROCESSINSTANCES
            (
                @CONFIGURATIONEXPORTPROCESSID uniqueidentifier
            )
            returns table
            as 
            return
            (
                select 
                    CONFIGURATIONEXPORTINSTANCE.ID,
                    CONFIGURATIONEXPORTINSTANCE.CONFIGURATIONDATACATALOGID, 
                    CONFIGURATIONEXPORTINSTANCE.CONFIGURATIONEXPORTDATAFORMITEM,
                    CONFIGURATIONDATACATALOG.DISPLAYNAME,
                    CONFIGURATIONEXPORTINSTANCE.SEQUENCE
                from
                    dbo.CONFIGURATIONEXPORTINSTANCE                    
                    inner join dbo.CONFIGURATIONDATACATALOG on CONFIGURATIONDATACATALOG.ID = CONFIGURATIONEXPORTINSTANCE.CONFIGURATIONDATACATALOGID
                where
                    CONFIGURATIONEXPORTINSTANCE.CONFIGURATIONEXPORTPROCESSID = @CONFIGURATIONEXPORTPROCESSID
            );