USP_DATALIST_ASSIGNCONSTITSECURITYATTRIBUTESPROCESS

Returns a list of saved assign constituent security attribute 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_ASSIGNCONSTITSECURITYATTRIBUTESPROCESS(@CURRENTAPPUSERID uniqueidentifier = null)
as
    set nocount on;

    select
        ASSIGNCONSTITSECURITYATTRIBUTESPROCESS.[ID],
        ASSIGNCONSTITSECURITYATTRIBUTESPROCESS.[NAME],
        ASSIGNCONSTITSECURITYATTRIBUTESPROCESS.[DESCRIPTION],
        ASSIGNCONSTITSECURITYATTRIBUTESPROCESS.[DATELASTRUN],
        SCOPEIDSETREGISTER.[NAME],
        ASSIGNTOIDSETREGISTER.[NAME],
        BPI.OWNERID as OWNERID      
    from
        dbo.[ASSIGNCONSTITSECURITYATTRIBUTESPROCESS]
    left join
        dbo.[IDSETREGISTER] SCOPEIDSETREGISTER
    on
        ASSIGNCONSTITSECURITYATTRIBUTESPROCESS.[SCOPEIDSETREGISTERID] = SCOPEIDSETREGISTER.[ID]
    left join
        dbo.[IDSETREGISTER] ASSIGNTOIDSETREGISTER
    on
        ASSIGNCONSTITSECURITYATTRIBUTESPROCESS.[ASSIGNTOIDSETREGISTERID] = ASSIGNTOIDSETREGISTER.[ID]
    left join 
       dbo.BUSINESSPROCESSINSTANCE BPI 
    on 
       ASSIGNCONSTITSECURITYATTRIBUTESPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
    where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, ASSIGNCONSTITSECURITYATTRIBUTESPROCESS.ID) = 1)

    order by
        ASSIGNCONSTITSECURITYATTRIBUTESPROCESS.[NAME];