USP_DATALIST_PROSPECTASSIGNMENTPROCESS
Returns a list of Prospect Assignment Process parameter sets.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
create procedure dbo.USP_DATALIST_PROSPECTASSIGNMENTPROCESS
(
@CURRENTAPPUSERID uniqueidentifier
)
as
set nocount on;
select
PROSPECTASSIGNMENTPROCESS.ID,
PROSPECTASSIGNMENTPROCESS.NAME,
PROSPECTASSIGNMENTPROCESS.DESCRIPTION,
IDSETREGISTER.NAME as PROSPECTSELECTION,
BUSINESSPROCESSINSTANCE.OWNERID
from
dbo.PROSPECTASSIGNMENTPROCESS
left join dbo.BUSINESSPROCESSINSTANCE on PROSPECTASSIGNMENTPROCESS.ID = BUSINESSPROCESSINSTANCE.BUSINESSPROCESSPARAMETERSETID
left join dbo.IDSETREGISTER on IDSETREGISTER.ID = PROSPECTASSIGNMENTPROCESS.PROSPECTSELECTIONID
where
dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, PROSPECTASSIGNMENTPROCESS.ID) = 1
order by PROSPECTASSIGNMENTPROCESS.NAME