USP_CREATESELECTIONSFROMSMARTFIELD

Creates selections for a smart field's value groups.

Parameters

Parameter	Parameter Type	Mode
@SMARTFIELDID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_CREATESELECTIONSFROMSMARTFIELD (
    @SMARTFIELDID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
) as begin

    declare @SMARTFIELDVALUEGROUPID uniqueidentifier;        
    declare VALUEGROUPCURSOR cursor local fast_forward for (
        select
            SMARTFIELDVALUEGROUP.ID
        from
            SMARTFIELDVALUEGROUP
        where
            SMARTFIELDVALUEGROUP.SMARTFIELDID = @SMARTFIELDID
    )    

    open VALUEGROUPCURSOR;
    fetch next from VALUEGROUPCURSOR into @SMARTFIELDVALUEGROUPID;

    if (@@FETCH_STATUS = 0)
    begin
        while (@@FETCH_STATUS = 0)
        begin                
            exec dbo.USP_CREATESELECTIONFORSMARTFIELDVALUEGROUP @SMARTFIELDVALUEGROUPID, @CURRENTAPPUSERID, @CHANGEAGENTID;

            fetch next from VALUEGROUPCURSOR into @SMARTFIELDVALUEGROUPID;
        end
        close VALUEGROUPCURSOR;
        deallocate VALUEGROUPCURSOR;
    end

    return 0;
end