USP_SIMPLEDATALIST_SPONSORSHIPGETSMARTFIELDS

Gets all sponsorship smart fields in a simple list.

Parameters

Parameter	Parameter Type	Mode	Description
@SPONSORSHIPOPPORTUNITYTYPECODE	tinyint	IN	SPONSORSHIPOPPORTUNITYTYPECODE

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_SPONSORSHIPGETSMARTFIELDS (
    @SPONSORSHIPOPPORTUNITYTYPECODE tinyint = 0
)
as
    set nocount on;

    select 
    SMARTFIELD.ID as VALUE,
    SMARTFIELD.NAME as LABEL
  from dbo.SMARTFIELD 
  inner join dbo.SMARTFIELDCATALOG on SMARTFIELDCATALOG.ID = SMARTFIELD.SMARTFIELDCATALOGID
  inner join dbo.RECORDTYPE on RECORDTYPE.ID = SMARTFIELDCATALOG.RECORDTYPEID
  where SMARTFIELDCATALOG.PROCEDURENAME like '%SPONSORSHIP%'
  and (@SPONSORSHIPOPPORTUNITYTYPECODE = 0 or RECORDTYPE.NAME = case @SPONSORSHIPOPPORTUNITYTYPECODE when 1 then 'Sponsorship Opportunity Child' when 2 then 'Sponsorship Opportunity Project' end)