USP_DATALIST_GIVINGLEVELDEFAULTVALUE

Returns a list of default levels from a giving level smart field.

Parameters

Parameter	Parameter Type	Mode	Description
@SMARTFIELDID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_GIVINGLEVELDEFAULTVALUE
                    (@SMARTFIELDID uniqueidentifier)
                as
                    set nocount on;                    

                    select 
                        SMARTFIELDVALUEGROUP.GROUPNAME AS NAME,
                        SMARTFIELDVALUEGROUP.MONEYVALUERANGE AS MINIMUMAMOUNT
                    from 
                        dbo.SMARTFIELDVALUEGROUP
                    where
                        SMARTFIELDVALUEGROUP.SMARTFIELDID = @SMARTFIELDID
                    order by
                        SMARTFIELDVALUEGROUP.MONEYVALUERANGE;