USP_DATALIST_WEALTHPOINTSEARCHPROCESS_2

A datalist of saved WealthPoint search 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_WEALTHPOINTSEARCHPROCESS_2(@CURRENTAPPUSERID uniqueidentifier)
                as begin
                    select 
                        WPRGSP.ID, 
                        WPRGSP.NAME, 
                        WPRGSP.DESCRIPTION, 
                        BPI.OWNERID as OWNERID, 
                        coalesce((select 1 from dbo.BUSINESSPROCESSSTATUS BPS where BPS.BUSINESSPROCESSPARAMETERSETID = WPRGSP.ID and STATUSCODE = 1), 0) as RUNNING
                    from 
                        dbo.WPRESEARCHGROUPSEARCHPROCESS WPRGSP
                    left join 
                        dbo.BUSINESSPROCESSINSTANCE BPI on WPRGSP.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                    where 
                        (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, WPRGSP.ID) = 1)
                    order by
                        NAME
                end