USP_SIMPLEDATALIST_IMPORTPROCESSBATCHTEMPLATE

Returns a list of batch templates which allow data to be imported into them via the import business process.

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_IMPORTPROCESSBATCHTEMPLATE(@CURRENTAPPUSERID uniqueidentifier)
as
    set nocount on;

    select distinct BATCHTEMPLATE.ID as VALUE, 
        BATCHTEMPLATE.NAME as LABEL 
    from dbo.BATCHTEMPLATE
    inner join dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
    where BATCHTYPECATALOG.ALLOWIMPORT = 1 and dbo.UFN_SECURITY_APPUSER_GRANTED_BATCHPROCESSOR(@CURRENTAPPUSERID, BATCHTEMPLATE.ID) = 1
    order by BATCHTEMPLATE.NAME;