QPR ProcessAnalyzer Expression Examples - Revision history

Ollvihe at 16:55, 10 December 2019

2019-12-10T16:55:56Z

← Older revision		Revision as of 16:55, 10 December 2019
Line 448:		Line 448:
	</pre>		</pre>

	[[Category: QPR UI]]		[[Category: QPR ProcessAnalyzer]]

2019-05-02T07:02:25Z

← Older revision		Revision as of 07:02, 2 May 2019
Line 437:		Line 437:
	Conformance analysis		Conformance analysis
	Let("xml", LoadTextFile("C:\\Users\\marhink\\Desktop\\SAP o2c.bpmn"));		Let("xml", LoadTextFile("C:\\Users\\marhink\\Desktop\\SAP o2c.bpmn"));
	Let("cm", ~~ConformanceModelFromXml~~(xml));		Let("cm", DesignModelFromXml(xml));
	Let("vars", OrderByDescending(EventLogById(1).Variations, CaseCount));		Let("vars", OrderByDescending(EventLogById(1).Variations, CaseCount));
	vars.(Let("analysis",AnalyzeConformance(cm)),""+CaseCount+" * "+(CountTop(analysis)==0)+((CountTop(analysis)>0)?" ("+StringJoin("",ReplaceLeafValues(analysis,"i",i[0]==3?i[2]+"->"+i[3]:(i[0]==2?"DNF":"")))+")":"")+": "+StringJoin("->",EventTypes.Name))		vars.(Let("analysis",AnalyzeConformance(cm)),""+CaseCount+" * "+(CountTop(analysis)==0)+((CountTop(analysis)>0)?" ("+StringJoin("",ReplaceLeafValues(analysis,"i",i[0]==3?i[2]+"->"+i[3]:(i[0]==2?"DNF":"")))+")":"")+": "+StringJoin("->",EventTypes.Name))

2018-04-06T11:08:14Z

← Older revision		Revision as of 11:08, 6 April 2018
Line 385:		Line 385:
	</pre>		</pre>

	// Call function objects using given parameters		<pre>
			Call function objects using given parameters
	[Def("", "a", "b", a+b), Def("", "a", "b", a*b)].(_(1,2))		[Def("", "a", "b", a+b), Def("", "a", "b", a*b)].(_(1,2))

	// The sum of all the durations between the first occurrence of "Invoice" and the last occurrence of "Sales Order" event types.		The sum of all the durations between the first occurrence of "Invoice" and the last occurrence of "Sales Order" event types.
	Def("FirstOccurrence", "&condition", _.Events[0].RecursiveFind(NextInCase, condition())[0]);		Def("FirstOccurrence", "&condition", _.Events[0].RecursiveFind(NextInCase, condition())[0]);
	Def("LastOccurrence", "&condition", _.Events[Count(_) - 1].RecursiveFind(PreviousInCase, condition())[0]);		Def("LastOccurrence", "&condition", _.Events[Count(_) - 1].RecursiveFind(PreviousInCase, condition())[0]);

2018-04-06T11:07:35Z

2018-04-06T11:05:59Z

2017-12-20T12:33:07Z

← Older revision		Revision as of 12:33, 20 December 2017
Line 243:		Line 243:
	</pre>		</pre>

	~~Average~~ duration between the first occurrence of event A and last occurrence of event B. Average is calculated only for those cases that contain both events A and B Usecase: How long it takes to receive payment on average?		Cases average duration between the first occurrence of event A and last occurrence of event B. Average is calculated only for those cases that contain both events A and B. Usecase: How long it takes to receive payment on average?
	<pre>		<pre>
	Average(		Average(

2017-12-20T09:01:41Z

← Older revision		Revision as of 09:01, 20 December 2017
Line 209:		Line 209:
	(Count(		(Count(
	Events.Where(		Events.Where(
	Type.Name == ""Invoice Paid""		Type.Name == "Invoice Paid"
	)		)
	) == 0)		) == 0)
Line 228:		Line 228:
	GetAt(0,		GetAt(0,
	Events.Where(		Events.Where(
	Type.Name == ""Invoice Paid""		Type.Name == "Invoice Paid"
	).TimeStamp		).TimeStamp
	)		)
Line 243:		Line 243:
	</pre>		</pre>

	How long it takes to receive payment on average?		Average duration between the first occurrence of event A and last occurrence of event B. Average is calculated only for those cases that contain both events A and B Usecase: How long it takes to receive payment on average?
	<pre>		<pre>
	Average(		Average(
	Sum(		Sum(
	Cases.Events.Where(		Cases.Events.Where(
	Type.Name == ""Payment Received""		Type.Name == "Payment Received"
	).(		).(
	TimeStamp - GetAt(		TimeStamp - GetAt(
	0,		0,
	Case.Events.Where(		Case.Events.Where(
	Type.Name == ""Invoice Sent""		Type.Name == "Invoice Sent"
	)		)
	).TimeStamp		).TimeStamp
Line 271:		Line 271:
	Average(		Average(
	Cases.Let(		Cases.Let(
	""indexes"",		"indexes",
	Box(		Box(
	Events.Type.Name		Events.Type.Name
	).IndexOfSubArray(		).IndexOfSubArray(
	Array(""et2"", ""et3"", ""et4"")		Array("et2", "et3", "et4")
	)		)
	).Where(		).Where(

2017-12-19T15:00:38Z

2017-12-19T12:43:47Z

2017-12-19T10:06:53Z

← Older revision		Revision as of 10:06, 19 December 2017
Line 54:		Line 54:
	EventLogById(1).(StringJoin(", ", OrderByDescending(EventTypes, Name).Name))		EventLogById(1).(StringJoin(", ", OrderByDescending(EventTypes, Name).Name))
	</pre>		</pre>


	List of all the Starter flows in a model from filterId=1:		List of all the Starter flows in a model from filterId=1:
Line 81:		Line 80:
	</pre>		</pre>

	Define new user defined functions:		Define a new user defined functions named "First", which takes the first item in an array:
	<pre>		<pre>
	Def("First", "a", GetAt(0, a));		Def("First", "a", GetAt(0, a));
	~~Def~~(~~"Second", "a", GetAt~~(1, a));		</pre>
			The defined array can be used as follows:
	~~Array(First(a), Second(a))~~		<pre>
			First(Array(1, 2, 3))
			returns: 1
	</pre>		</pre>