UFN_SMARTFIELDVALUEGROUP_GETGROUPS_2

Returns value group information for a given smart field. Includes date value groups.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SMARTFIELDID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_SMARTFIELDVALUEGROUP_GETGROUPS_2
(
    @SMARTFIELDID uniqueidentifier
)
returns table            
as 
return            
(
    select 
        SMARTFIELDVALUEGROUP.ID,                     
        SMARTFIELDVALUEGROUP.MONEYVALUERANGE,
        SMARTFIELDVALUEGROUP.INTEGERVALUERANGE,
        SMARTFIELDVALUEGROUP.GROUPNAME,
        SMARTFIELDVALUEGROUP.DATEVALUERANGE
    from 
        dbo.SMARTFIELDVALUEGROUP
    where
        SMARTFIELDVALUEGROUP.SMARTFIELDID = @SMARTFIELDID                
);