USP_SMARTFIELD_EDITINSTANCE

Edits the specified smart field instance.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@SMARTFIELDDATAFORMITEM	xml	IN
@USEVALUEGROUP	bit	IN
@SMARTFIELDVALUEGROUPS	xml	IN
@DATEVALUEGROUPUNITCODE	tinyint	IN
@SOURCEQUERYVIEWCATALOGID	uniqueidentifier	IN
@SITESSELECTED	xml	IN
@SITEFILTERENABLEDFORINSTANCE	bit	IN
@DESCRIPTION	nvarchar(4000)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@FEATUREID	uniqueidentifier	IN
@FEATURETYPE	tinyint	IN
@CURRENCYID	uniqueidentifier	IN
@SMARTFIELDCATEGORYCODEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_SMARTFIELD_EDITINSTANCE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100),
  @SMARTFIELDDATAFORMITEM xml,
  @USEVALUEGROUP bit,
  @SMARTFIELDVALUEGROUPS xml,
  @DATEVALUEGROUPUNITCODE tinyint = 0,
  @SOURCEQUERYVIEWCATALOGID uniqueidentifier = null,
  @SITESSELECTED xml = null,
  @SITEFILTERENABLEDFORINSTANCE bit = 0,
  @DESCRIPTION nvarchar(4000) = null,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @FEATUREID uniqueidentifier = null,
  @FEATURETYPE tinyint = 0,
  @CURRENCYID uniqueidentifier = null,
  @SMARTFIELDCATEGORYCODEID uniqueidentifier = null
)
as
begin
  declare @SHOWINFUNDRAISERONTHEGO bit = 0;

  select @SHOWINFUNDRAISERONTHEGO = SHOWINFUNDRAISERONTHEGO
  from dbo.SMARTFIELD
  where ID = @ID;

  exec dbo.USP_SMARTFIELD_EDITINSTANCE_2
    @ID,
    @CHANGEAGENTID,
    @NAME,
    @SMARTFIELDDATAFORMITEM,
    @USEVALUEGROUP,
    @SMARTFIELDVALUEGROUPS,
    @DATEVALUEGROUPUNITCODE,
    @SOURCEQUERYVIEWCATALOGID,
    @SITESSELECTED,
    @SITEFILTERENABLEDFORINSTANCE,
    @DESCRIPTION,
    @CURRENTAPPUSERID,
    @FEATUREID,
    @FEATURETYPE,
    @CURRENCYID,
    @SMARTFIELDCATEGORYCODEID,
    @SHOWINFUNDRAISERONTHEGO;
end