Mass close stuck tickets - Revision history

Smtxwiki at 17:58, 9 May 2023

2023-05-09T17:58:03Z

← Older revision		Revision as of 19:58, 9 May 2023
Line 19:		Line 19:
	The webservice used here is "Workflow - Stop Process Instance" and that webservice is defined like this:		The webservice used here is "Workflow - Stop Process Instance" and that webservice is defined like this:
	XSLin:		XSLin:
	<?xml version='1.0'?>		<nowiki><?xml version='1.0'?>
	<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ser="http://smt-x.com/Workflow/">		<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ser="http://smt-x.com/Workflow/">
	<xsl:template match='/SSPAdapterCall'>		<xsl:template match='/SSPAdapterCall'>
Line 34:		Line 34:
	</soap:Envelope>		</soap:Envelope>
	</xsl:template>		</xsl:template>
	</xsl:stylesheet>		</xsl:stylesheet></nowiki>

	XSL out:		XSL out:
	<?xml version='1.0' ?>		<nowiki><?xml version='1.0' ?>
	<xsl:stylesheet		<xsl:stylesheet
	xmlns:xsl='http://www.w3.org/1999/XSL/Transform'		xmlns:xsl='http://www.w3.org/1999/XSL/Transform'
Line 57:		Line 57:
	<Error>code:<xsl:value-of select='soap:faultcode' /><xsl:value-of select='soap:Code/soap:Value' /> - string:<xsl:value-of select='soap:faultstring' /><xsl:value-of select='soap:Reason/soap:Text' /></Error>		<Error>code:<xsl:value-of select='soap:faultcode' /><xsl:value-of select='soap:Code/soap:Value' /> - string:<xsl:value-of select='soap:faultstring' /><xsl:value-of select='soap:Reason/soap:Text' /></Error>
	</xsl:template>		</xsl:template>
	</xsl:stylesheet>		</xsl:stylesheet></nowiki>

	Extra settings		Extra settings

Smtxwiki at 17:57, 9 May 2023

2023-05-09T17:57:09Z

← Older revision		Revision as of 19:57, 9 May 2023
Line 20:		Line 20:
	XSLin:		XSLin:
	<?xml version='1.0'?>		<?xml version='1.0'?>
	<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ser="http://smt-x.com/Workflow/">		<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ser="http://smt-x.com/Workflow/">
	<xsl:template match='/SSPAdapterCall'>		<xsl:template match='/SSPAdapterCall'>
	<soap:Envelope>		<soap:Envelope>

Smtxwiki at 16:27, 9 May 2023

2023-05-09T16:27:42Z

← Older revision		Revision as of 18:27, 9 May 2023
Line 19:		Line 19:
	The webservice used here is "Workflow - Stop Process Instance" and that webservice is defined like this:		The webservice used here is "Workflow - Stop Process Instance" and that webservice is defined like this:
	XSLin:		XSLin:
	<?xml version='1.0'?>		<?xml version='1.0'?>
	<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ser="http://smt-x.com/Workflow/">		<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ser="http://smt-x.com/Workflow/">
	<xsl:template match='/SSPAdapterCall'>		<xsl:template match='/SSPAdapterCall'>
	<soap:Envelope>		<soap:Envelope>
Line 34:		Line 34:
	</soap:Envelope>		</soap:Envelope>
	</xsl:template>		</xsl:template>
	</xsl:stylesheet>		</xsl:stylesheet>

	XSL out:		XSL out:
	<?xml version='1.0' ?>		<?xml version='1.0' ?>
	<xsl:stylesheet		<xsl:stylesheet
	xmlns:xsl='http://www.w3.org/1999/XSL/Transform'		xmlns:xsl='http://www.w3.org/1999/XSL/Transform'
	xmlns:soap="http://www.w3.org/2003/05/soap-envelope"		xmlns:soap="http://www.w3.org/2003/05/soap-envelope"
	xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'		xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
	xmlns:xsd="http://www.w3.org/2001/XMLSchema"		xmlns:xsd="http://www.w3.org/2001/XMLSchema"
	xmlns:ssp="http://smt-x.com/Workflow/"		xmlns:ssp="http://smt-x.com/Workflow/"
	version='1.0'>		version='1.0'>
	<xsl:template match="/">		<xsl:template match="/">
	<SSPAdapterResult>		<SSPAdapterResult>
Line 57:		Line 57:
	<Error>code:<xsl:value-of select='soap:faultcode' /><xsl:value-of select='soap:Code/soap:Value' /> - string:<xsl:value-of select='soap:faultstring' /><xsl:value-of select='soap:Reason/soap:Text' /></Error>		<Error>code:<xsl:value-of select='soap:faultcode' /><xsl:value-of select='soap:Code/soap:Value' /> - string:<xsl:value-of select='soap:faultstring' /><xsl:value-of select='soap:Reason/soap:Text' /></Error>
	</xsl:template>		</xsl:template>
	</xsl:stylesheet>		</xsl:stylesheet>

	Type: SOAP		Extra settings
	URL: localhost /Workflow/WebService/WorkflowService.asmx		Type: SOAP
	Call Type: Retrieve Single Value		URL: localhost /Workflow/WebService/WorkflowService.asmx
	Return Type: Single Value		Call Type: Retrieve Single Value
			Return Type: Single Value

Smtxwiki at 16:26, 9 May 2023

2023-05-09T16:26:53Z

← Older revision		Revision as of 18:26, 9 May 2023
Line 1:		Line 1:
	When you have a large amount of stuck tickets, you can use the following javascript script to close multiple at once. Use the serviceIds array to set all tickets ids		When you have a large amount of stuck tickets, you can use the following javascript script to close multiple at once. Use the serviceIds array to set all tickets ids

	const serviceIds = [1234, 1235, 1236];		const serviceIds = [1234, 1235, 1236];
	var errorLog = [];		var errorLog = [];
	for (var i=0; i<serviceIds.length; i++) {		for (var i=0; i<serviceIds.length; i++) {
	try {		try {
	CommonInterface.callWebservice('Workflow - Stop Process Instance', {		CommonInterface.callWebservice('Workflow - Stop Process Instance', {
Line 14:		Line 14:
	errorLog.push(serviceIds[i] + ' ' + err);		errorLog.push(serviceIds[i] + ' ' + err);
	}		}
	}		}
	return errorLog;		return errorLog;

	The webservice used here is "Workflow - Stop Process Instance" and that webservice is defined like this:		The webservice used here is "Workflow - Stop Process Instance" and that webservice is defined like this:

Smtxwiki: Created page with "When you have a large amount of stuck tickets, you can use the following javascript script to close multiple at once. Use the serviceIds array to set all tickets ids const serviceIds = [1234, 1235, 1236]; var errorLog = []; for (var i=0; i
2023-05-09T16:26:34Z

Created page with "When you have a large amount of stuck tickets, you can use the following javascript script to close multiple at once. Use the serviceIds array to set all tickets ids const serviceIds = [1234, 1235, 1236]; var errorLog = []; for (var i=0; i<serviceIds.length; i++) { try { CommonInterface.callWebservice('Workflow - Stop Process Instance', { ProcessInstanceId : serviceIds[i], Log : 'Some comment line to explain why you closed the ticket'..."

New page
When you have a large amount of stuck tickets, you can use the following javascript script to close multiple at once. Use the serviceIds array to set all tickets ids

const serviceIds = [1234, 1235, 1236];
var errorLog = [];
for (var i=0; i<serviceIds.length; i++) {
try {
CommonInterface.callWebservice('Workflow - Stop Process Instance', {
ProcessInstanceId : serviceIds[i],
Log : 'Some comment line to explain why you closed the ticket',
HashCheck : 'ExternalProviderKey',
ProviderName : 'ExternalProviderName'
});
} catch (err) {
errorLog.push(serviceIds[i] + ' ' + err);
}
}
return errorLog;

The webservice used here is "Workflow - Stop Process Instance" and that webservice is defined like this:
XSLin:
<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ser="http://smt-x.com/Workflow/">
<xsl:template match='/SSPAdapterCall'>
<soap:Envelope>
<soap:Header />
<soap:Body>
<ser:StopProcessInstance>
<ser:ProcessInstanceId><xsl:value-of select="Field[@Name='ProcessInstanceId']" /></ser:ProcessInstanceId>
<ser:Log><xsl:value-of select="Field[@Name='Log']" /></ser:Log>
<ser:HashCheck><xsl:value-of select="Field[@Name='HashCheck']" /></ser:HashCheck>
<ser:ProviderName><xsl:value-of select="Field[@Name='ProviderName']" /></ser:ProviderName>
</ser:StopProcessInstance>
</soap:Body>
</soap:Envelope>
</xsl:template>
</xsl:stylesheet>

XSL out:
<?xml version='1.0' ?>
<xsl:stylesheet
xmlns:xsl='http://www.w3.org/1999/XSL/Transform'
xmlns:soap="http://www.w3.org/2003/05/soap-envelope"
xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:ssp="http://smt-x.com/Workflow/"
version='1.0'>
<xsl:template match="/">
<SSPAdapterResult>
<xsl:apply-templates select="/soap:Envelope/soap:Body/ssp:StopProcessInstanceResponse"/>
<xsl:apply-templates select="/soap:Envelope/soap:Body/soap:Fault"/>
</SSPAdapterResult>
</xsl:template>
<xsl:template match="/soap:Envelope/soap:Body/ssp:StopProcessInstanceResponse">
<Value>OK</Value>
</xsl:template>
<xsl:template match="/soap:Envelope/soap:Body/soap:Fault">
<Error>code:<xsl:value-of select='soap:faultcode' /><xsl:value-of select='soap:Code/soap:Value' /> - string:<xsl:value-of select='soap:faultstring' /><xsl:value-of select='soap:Reason/soap:Text' /></Error>
</xsl:template>
</xsl:stylesheet>

Type: SOAP
URL: localhost /Workflow/WebService/WorkflowService.asmx
Call Type: Retrieve Single Value
Return Type: Single Value