USP_SIMPLEDATALIST_PROSPECTRESEARCHTEMPLATE

Returns a list of Prospect Research Report Templates.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_PROSPECTRESEARCHTEMPLATE(@CURRENTAPPUSERID uniqueidentifier = null) as
                    select 
                        PROSPECTRESEARCHTEMPLATE.ID as VALUE, 
                        PROSPECTRESEARCHTEMPLATE.NAME as LABEL,
                        PROSPECTRESEARCHTEMPLATE.ISSYSTEM as DESCRIPTION
                    from dbo.PROSPECTRESEARCHTEMPLATE
                    left join dbo.PROSPECTRESEARCHTEMPLATEDEFAULT
                      on PROSPECTRESEARCHTEMPLATEDEFAULT.PROSPECTRESEARCHTEMPLATEID = PROSPECTRESEARCHTEMPLATE.ID
                        and PROSPECTRESEARCHTEMPLATEDEFAULT.OWNERID = @CURRENTAPPUSERID
                    order by case when PROSPECTRESEARCHTEMPLATEDEFAULT.ID is null then 1 else 0 end, PROSPECTRESEARCHTEMPLATE.NAME