https://wiki.smt-x.com/index.php?action=history&feed=atom&title=Close_workflow_tickets_via_query 2026-04-04T02:31:13Z Revision history for this page on the wiki MediaWiki 1.44.3 https://wiki.smt-x.com/index.php?title=Close_workflow_tickets_via_query&diff=43&oldid=prev 2020-05-25T20:44:27Z

<p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:44, 25 May 2020</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

Smtxwiki https://wiki.smt-x.com/index.php?title=Close_workflow_tickets_via_query&diff=42&oldid=prev 2019-02-06T13:48:57Z

<p></p> <p><b>New page</b></p><div>Single query:<br /> <br /> DELETE FROM ProcessInstance WHERE [Id] = 4094<br /> 4094 is the TicketNr<br /> <br /> Longer query:<br /> <br /> CREATE TABLE [ProcessInstanceToClose] (<br /> [Id] int NOT NULL,<br /> CONSTRAINT PK_ProcessInstanceToClose PRIMARY KEY ([Id])<br /> );<br /> <br /> INSERT INTO [ProcessInstanceToClose] ([Id]) VALUES (1);<br /> <br /> GO<br /> <br /> DECLARE @ProcessInstanceId int, @ProcessInstanceLogId int, @DefaultLanguageId int, @LogText nvarchar(255);<br /> <br /> DECLARE ticketcursor CURSOR FOR<br /> SELECT [Id] FROM [ProcessInstance] WHERE [Id] IN (SELECT [Id] FROM [ProcessInstanceToClose]) AND [DateEnded] IS NULL;<br /> <br /> SELECT @DefaultLanguageId = [Id] FROM [Language] where [IsDefault]=1;<br /> SET @LogText = &#039;Auto closed by system&#039;;<br /> <br /> OPEN ticketcursor <br /> FETCH NEXT FROM ticketcursor INTO @ProcessInstanceId <br /> <br /> WHILE @@FETCH_STATUS = 0 <br /> BEGIN <br /> INSERT INTO [ProcessInstanceLog] ([ProcessInstanceId],[DateAdded],[Type]) VALUES (@ProcessInstanceId,GETDATE(),&#039;ClosedBySystem&#039;);<br /> INSERT INTO [ProcessInstanceLogLanguage] ([ProcessInstanceLogId], [LanguageId], [LogText]) VALUES (SCOPE_IDENTITY(), @DefaultLanguageId, @LogText);<br /> <br /> <br /> FETCH NEXT FROM ticketcursor INTO @ProcessInstanceId<br /> END <br /> <br /> CLOSE ticketcursor <br /> DEALLOCATE ticketcursor <br /> <br /> GO<br /> <br /> UPDATE [ProcessISInstanceActor]<br /> SET [DateEnded] = GETDATE(), [AutoEnded] = 1<br /> WHERE [ProcessInstanceStepInstanceId] IN (SELECT [Id] FROM [ProcessInstanceStepInstance] WHERE [ProcessInstanceStepId] IN (SELECT [Id] FROM [ProcessInstanceStep] WHERE [ProcessInstanceId] IN (SELECT [Id] FROM [ProcessInstanceToClose])))<br /> AND [DateEnded] IS NULL;<br /> <br /> UPDATE [ProcessInstanceStepInstance]<br /> SET [DateEnded] = GETDATE()<br /> WHERE [ProcessInstanceStepId] IN (SELECT [Id] FROM [ProcessInstanceStep] WHERE [ProcessInstanceId] IN (SELECT [Id] FROM [ProcessInstanceToClose]))<br /> AND [DateEnded] IS NULL;<br /> <br /> UPDATE [ProcessInstance]<br /> SET [DateEnded] = GETDATE()<br /> WHERE [Id] IN (SELECT [Id] FROM [ProcessInstanceToClose])<br /> AND [DateEnded] IS NULL;<br /> <br /> GO<br /> <br /> DROP TABLE [ProcessInstanceToClose];</div>

Smtxwiki