UFN_SMARTFIELD_GETQUERYVIEWOBJECTNAME

Given the ID of a smart field instance, generate and return the name of the corresponding query view.

Return

Return Type
nvarchar(128)

Parameters

Parameter	Parameter Type	Mode	Description
@SMARTFIELDID	uniqueidentifier	IN

Definition

Copy



            create function UFN_SMARTFIELD_GETQUERYVIEWOBJECTNAME
            (
                @SMARTFIELDID uniqueidentifier
            )
            returns nvarchar(128)
            as
            begin

                declare @QUERYVIEWOBJECTNAME nvarchar(128);
                select @QUERYVIEWOBJECTNAME=replace(upper('V_QUERY_SMARTFIELD'+convert(nvarchar(36),TABLECATALOGID)),'-','')
                from dbo.SMARTFIELD
                where ID=@SMARTFIELDID;

                return @QUERYVIEWOBJECTNAME;

            end