USP_SIMPLEDATALIST_SMARTFIELDPROCEDURES

A simple data list of smart field stored procedures for a specific record type.

Parameters

Parameter	Parameter Type	Mode	Description
@SMARTFIELDRECORDTYPEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_SMARTFIELDPROCEDURES
(
    @SMARTFIELDRECORDTYPEID uniqueidentifier = null
) 
as                
    set nocount on;

    select 
        SMARTFIELDCATALOG.ID as VALUE, 
        SMARTFIELDCATALOG.DISPLAYNAME as LABEL 
    from 
        dbo.SMARTFIELDCATALOG                    
    where 
        SMARTFIELDCATALOG.RECORDTYPEID = @SMARTFIELDRECORDTYPEID
    order by 
        SMARTFIELDCATALOG.DISPLAYNAME;