USP_BATCHTEMPLATE_GETLIST
Returns a list of all batch templates of a give batch type.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHTYPECATALOGID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_BATCHTEMPLATE_GETLIST(@BATCHTYPECATALOGID uniqueidentifier)
as
set nocount on;
select BATCHTEMPLATE.ID, BATCHTEMPLATE.NAME, BATCHTEMPLATE.DESCRIPTION, BATCHTEMPLATE.ADDROWDATAFORMINSTANCEID,
BATCHTEMPLATE.EDITROWDATAFORMINSTANCEID, BATCHTEMPLATE.COMMITROWADDDATAFORMINSTANCEID, BATCHTEMPLATE.COMMITROWEDITDATAFORMINSTANCEID,
BATCHTEMPLATE.COMMITROWEDITDATAFORMIDFIELD, BATCHTEMPLATE.ROWRECORDOPERATIONID, BATCHTEMPLATE.ROWCONTEXTVIEWDATAFORMINSTANCEID, BATCHTEMPLATE.ROWCONTEXTEDITDATAFORMINSTANCEID,
BATCHTEMPLATE.FORMDEFINITIONXML, BATCHTEMPLATE.BATCHWORKFLOWID, BATCHTEMPLATE.CUSTOM, BATCHTEMPLATE.SITEID
from dbo.BATCHTEMPLATE
where BATCHTEMPLATE.BATCHTYPECATALOGID = @BATCHTYPECATALOGID
and (BATCHTEMPLATE.CUSTOM = 0 or exists (select ID from dbo.BATCH where BATCH.BATCHTEMPLATEID = BATCHTEMPLATE.ID and BATCH.STATUSCODE in (0, 3)))
order by BATCHTEMPLATE.NAME;