USP_SIMPLEDATALIST_BATCH2OWNER
Returns users who are allowed as to be an owner of a batch
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_BATCH2OWNER(@BATCHID uniqueidentifier = null)
as begin
select
APPUSER.ID as VALUE,
case when APPUSER.DISPLAYNAME = '' then APPUSER.USERNAME else APPUSER.DISPLAYNAME end as LABEL
from
dbo.BATCH
cross apply
dbo.UFN_SECURITY_APPUSER_GRANTED_BATCH(BATCH.ID, BATCH.BATCHTEMPLATEID, BATCH.BATCHWORKFLOWSTATEID) GRANTED_APPUSER
join
dbo.APPUSER on GRANTED_APPUSER.ID = APPUSER.ID
where
BATCH.ID = @BATCHID
order by LABEL
end