USP_DATALIST_WEALTHPOINTSEARCHPROCESS

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(@CURRENTAPPUSERID uniqueidentifier)
                as begin
                    select 
                        WPSEARCHPROCESS.ID, WPSEARCHPROCESS.NAME, WPSEARCHPROCESS.DESCRIPTION, BPI.OWNERID as OWNERID
                    from dbo.WPSEARCHPROCESS
                    left join dbo.BUSINESSPROCESSINSTANCE BPI on WPSEARCHPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                    where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, WPSEARCHPROCESS.ID) = 1)
                    order by
                        NAME
                end