USP_APPUSERSMARTQUERYINSTANCEFAVORITE_DELETE
Deletes a smart query instance from the user favorites folder
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SMARTQUERYINSTANCEID | uniqueidentifier | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_APPUSERSMARTQUERYINSTANCEFAVORITE_DELETE
(
@SMARTQUERYINSTANCEID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as
begin
set nocount on;
declare @ID uniqueidentifier;
select @ID = ID from dbo.APPUSERSMARTQUERYINSTANCEFAVORITE
where SMARTQUERYINSTANCEID = @SMARTQUERYINSTANCEID and APPUSERID = @CURRENTAPPUSERID;
exec dbo.USP_APPUSERSMARTQUERYINSTANCEFAVORITE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
return 0;
end