USP_APPUSERSMARTQUERYINSTANCEFAVORITE_ADD

Adds a smart query instance to the user favorites folder

Parameters

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

Definition

Copy



create procedure dbo.USP_APPUSERSMARTQUERYINSTANCEFAVORITE_ADD
(
    @SMARTQUERYINSTANCEID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as 
begin
  declare @GETDATE datetime;
  set @GETDATE = getdate();

  set nocount on;

  if not exists(select ID from dbo.APPUSERSMARTQUERYINSTANCEFAVORITE where SMARTQUERYINSTANCEID = @SMARTQUERYINSTANCEID and APPUSERID = @CURRENTAPPUSERID)
  insert into dbo.APPUSERSMARTQUERYINSTANCEFAVORITE 
  (
    [ID],
    [APPUSERID],
    [SMARTQUERYINSTANCEID],
    [ADDEDBYID],
    [CHANGEDBYID],
    [DATEADDED],
    [DATECHANGED])
  VALUES
  (
    newid(),
    @CURRENTAPPUSERID,
    @SMARTQUERYINSTANCEID,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @GETDATE,
    @GETDATE
  )
end;