UFN_SMARTFIELDVALUEGROUP_GETGROUPS

Returns value group information for a given smart field.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SMARTFIELDID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_SMARTFIELDVALUEGROUP_GETGROUPS
(
    @SMARTFIELDID uniqueidentifier
)
returns table            
as 
return            
(
    select 
        GROUPS.ID,                     
        GROUPS.MONEYVALUERANGE,
        GROUPS.INTEGERVALUERANGE,
        GROUPS.GROUPNAME
    from 
        dbo.UFN_SMARTFIELDVALUEGROUP_GETGROUPS_2(@SMARTFIELDID) [GROUPS]
);