Generic Functions in QPR ProcessAnalyzer - Revision history

TeeHiet: TK-62005

2026-02-06T13:44:41Z

TK-62005

@@ Line 1,602: / Line 1,602: @@
 </pre>
 |-
-|ToBpmn
+||ToBpmn
-|Parameters dictionary
+||Parameters dictionary
-|Generates XML formatted BPMN model based on given configuration.
+||Generates an XML formatted BPMN model based on given configuration. Performed in two steps:
 |-
 ||ToSqlDataFrame

TeeHiet: TK-62005

2026-02-06T13:19:01Z

TK-62005

← Older revision		Revision as of 13:19, 6 February 2026
Line 1,601:		Line 1,601:
	);		);
	</pre>		</pre>
			\|-
			\|ToBpmn
			\|Parameters dictionary
			\|Generates XML formatted BPMN model based on given configuration.
	\|-		\|-
	\|\|ToSqlDataFrame		\|\|ToSqlDataFrame

Ollvihe: /* Aggregation functions */

2025-12-04T09:30:14Z

Aggregation functions

Ollvihe: /* Aggregation functions */

2025-12-04T09:29:41Z

Aggregation functions

← Older revision		Revision as of 09:29, 4 December 2025
Line 1:		Line 1:
	== Aggregation functions ==		== Aggregation functions ==
	Following aggregation functions are available:		Following aggregation functions are available:
	* '''Average''': Average of the items (sum of items divided by count of items). Can be used for numbers, [[~~QPR_ProcessAnalyzer_Objects_in_Expression_Language~~#DateTime\|DateTimes]] and [[~~QPR_ProcessAnalyzer_Objects_in_Expression_Language~~#TimeSpan\|Timespans]].		* '''Average''': Average of the items (sum of items divided by count of items). Can be used for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[Generic_Objects_in_Expression_Language#TimeSpan\|Timespans]].
	* '''Count''': Number of items. Can be used for any type of data.		* '''Count''': Number of items. Can be used for any type of data.
	* '''Median''': Median, i.e. the middle value of the sorted data. If there are even number of items, the average of the two middle items. Can be used for numbers, [[~~QPR_ProcessAnalyzer_Objects_in_Expression_Language~~#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TimeSpan\|Timespans]].		* '''Median''': Median, i.e. the middle value of the sorted data. If there are even number of items, the average of the two middle items. Can be used for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TimeSpan\|Timespans]].
	* '''Min''': Lowest/first value in the data. Can be used for data that can be sorted.		* '''Min''': Lowest/first value in the data. Can be used for data that can be sorted.
	* '''Max''': Highest/last value in the data. Can be used for data that can be sorted.		* '''Max''': Highest/last value in the data. Can be used for data that can be sorted.
	*'''Percentile''': Percentile value. Can be used for numbers, [[~~QPR_ProcessAnalyzer_Objects_in_Expression_Language~~#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TimeSpan\|Timespans]].		*'''Percentile''': Percentile value. Can be used for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TimeSpan\|Timespans]].
	*'''Stdev''': Sample standard deviation. Can be calculated for numbers, [[~~QPR_ProcessAnalyzer_Objects_in_Expression_Language~~#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TimeSpan\|Timespans]].		*'''Stdev''': Sample standard deviation. Can be calculated for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TimeSpan\|Timespans]].
	*'''Stdevp''': Population standard deviation. Can be calculated for numbers, [[~~QPR_ProcessAnalyzer_Objects_in_Expression_Language~~#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TimeSpan\|Timespans]].		*'''Stdevp''': Population standard deviation. Can be calculated for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TimeSpan\|Timespans]].
	* '''Sum''': Sum of the items. Can be used for numbers and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TimeSpan\|Timespans]].		* '''Sum''': Sum of the items. Can be used for numbers and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TimeSpan\|Timespans]].
	* '''StringJoin''': Joins array of strings together. The first parameter is a string that is placed between the joined strings.		* '''StringJoin''': Joins array of strings together. The first parameter is a string that is placed between the joined strings.

Ollvihe: /* Snowflake connection functions */

2025-11-26T02:18:04Z

Snowflake connection functions

← Older revision		Revision as of 02:18, 26 November 2025
Line 1,544:		Line 1,544:
	# '''Procedure name''': Name of the called stored procedure.		# '''Procedure name''': Name of the called stored procedure.
	# '''Procedure parameters''': Dictionary of parameters passed to the stored procedure. Note: If the parameter name starts with an underscore (_), it's not be passed to the procedure call.		# '''Procedure parameters''': Dictionary of parameters passed to the stored procedure. Note: If the parameter name starts with an underscore (_), it's not be passed to the procedure call.
	# '''Additional parameters''': Dictionary of additional parameters affecting how the stored procedure is called. Supports parameter '''HasTabularResult''' (default ''false'') which need to be ''true'' when the stored procedure is expected to return a tabular result, and ''false'' when a scalar result~~. Note: When using the HasTabularResult=true, Snowflake ODBC driver version needs to be at least 3.1.0 (due to bug fix in the driver)~~.		# '''Additional parameters''': Dictionary of additional parameters affecting how the stored procedure is called. Supports parameter '''HasTabularResult''' (default ''false'') which need to be ''true'' when the stored procedure is expected to return a tabular result, and ''false'' when a scalar result.

	Security note: All QPR ProcessAnalyzer users can use the CallStoredProcedure function and call Snowflake stored procedures that are in the schema configured to the [[PA_Configuration_database_table#General_Settings\|Snowflake connection string]]. Create only stored procedures to that schema, that are safe for any user to run.		Security note: All QPR ProcessAnalyzer users can use the CallStoredProcedure function and call Snowflake stored procedures that are in the schema configured to the [[PA_Configuration_database_table#General_Settings\|Snowflake connection string]]. Create only stored procedures to that schema, that are safe for any user to run.

Ollvihe: /* Miscellaneous functions */

2025-05-10T13:27:27Z

Miscellaneous functions

@@ Line 1,034: / Line 1,034: @@
 Variable("x") * 2;
 Returns: 10
 </pre>
 |-

Ollvihe: /* Data source connectors */

2025-05-10T13:25:29Z

Data source connectors

← Older revision		Revision as of 13:25, 10 May 2025
Line 510:		Line 510:
	<pre>		<pre>
	CallWebService(#{		CallWebService(#{
	"Address": "https://processanalyzer.onqpr.com/qprpa/api/importfile?~~importMode=datatable&~~fileType=csv&objectId=123&append=true&csvTimeFormat=yyyy-MM-dd%20HH%3Amm%3Ass,fff",		"Address": "https://processanalyzer.onqpr.com/qprpa/api/importfile?fileType=csv&objectId=123&append=true&csvTimeFormat=yyyy-MM-dd%20HH%3Amm%3Ass,fff",
	"Method": "POST",		"Method": "POST",
	"Body": DatatableById(321).SqlDataFrame.Collect().ToCsv(),		"Body": DatatableById(321).SqlDataFrame.Collect().ToCsv(),

Ollvihe: /* Data source connectors */

2025-04-09T17:47:43Z

Data source connectors

← Older revision		Revision as of 17:47, 9 April 2025
Line 443:		Line 443:
	*'''Address''' (string): Url address to connect to.		*'''Address''' (string): Url address to connect to.
	*'''Method''' (string): Http method to use, as one of the following: GET (default), POST, PUT, DELETE.		*'''Method''' (string): Http method to use, as one of the following: GET (default), POST, PUT, DELETE.
	*'''Body''' (string/dictionary/array): The http request body. ~~In case~~ the request content type is application/json, dictionary/array can be used directly without string conversion.		*'''Body''' (string/dictionary/array): The http request body. If the request content type is ''application/json'', dictionary and array can be used directly without string conversion. The body is supported for methods POST, PUT, and DELETE.
	*'''Content-Type''' (string): Defines the Content-Type http request header. If content type is application/x-www-form-urlencoded, form url encoding is applied for the request body.		*'''Content-Type''' (string): Defines the Content-Type http request header. If content type is application/x-www-form-urlencoded, form url encoding is applied for the request body.
	*'''Timeout''' (integer): Time to wait before the request times out, in case no response is received earlier. Defined as integer in milliseconds. By default 60000 milliseconds.		*'''Timeout''' (integer): Time to wait before the request times out, in case no response is received earlier. Defined as integer in milliseconds. By default 60000 milliseconds.

Ollvihe at 09:38, 27 March 2025

2025-03-27T09:38:13Z

← Older revision		Revision as of 09:38, 27 March 2025
Line 1,091:		Line 1,091:
	</pre>		</pre>
	\|-		\|-
	\|\|SetSecret		\|\|<span id="SetSecret">SetSecret</span>
	\|\|		\|\|
	# Secret type (string)		# Secret type (string)

Ollvihe at 09:30, 27 March 2025

2025-03-27T09:30:21Z

← Older revision		Revision as of 09:30, 27 March 2025
Line 1,096:		Line 1,096:
	# Secret name (string)		# Secret name (string)
	# Secret value (string)		# Secret value (string)
	\|\|Sets a global [[Storing_Secrets_for_Scripts#Setting_and_listing_secrets\|secret]] ~~which~~ can be used ~~in all projects~~ in the system. Parameters are the same as for the project-specific [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#SetSecret\|SetSecret]] function. Setting secret value to '''null''' will remove the secret. ~~This~~ function requires the global '''ManageProject''' permission.		\|\|Sets a global [[Storing_Secrets_for_Scripts#Setting_and_listing_secrets\|secret]] that can be used by any project in the system. Parameters for the function call are the same as for the project-specific [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#SetSecret\|SetSecret]] function. Setting a secret value to '''null''' will remove the secret. Calling this function requires the global '''ManageProject''' permission.

	Example:		Example: Set a SAP password that can be used by any project and script in the system:
	<pre>		<pre>
	SetSecret("sap", "MySapPassword", "I l0ve 5AP!")		SetSecret("sap", "MySapPassword", "I l0ve 5AP!")

← Older revision		Revision as of 09:30, 4 December 2025
Line 1:		Line 1:
	== Aggregation functions ==		== Aggregation functions ==
	Following aggregation functions are available:		Following aggregation functions are available:
	* '''Average''': Average of the items (sum of items divided by count of items). Can be used for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[Generic_Objects_in_Expression_Language#~~TimeSpan~~\|Timespans]].		* '''Average''': Average of the items (sum of items divided by count of items). Can be used for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[Generic_Objects_in_Expression_Language#Timespan\|Timespans]].
	* '''Count''': Number of items. Can be used for any type of data.		* '''Count''': Number of items. Can be used for any type of data.
	* '''Median''': Median, i.e. the middle value of the sorted data. If there are even number of items, the average of the two middle items. Can be used for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#~~TimeSpan~~\|Timespans]].		* '''Median''': Median, i.e. the middle value of the sorted data. If there are even number of items, the average of the two middle items. Can be used for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Timespan\|Timespans]].
	* '''Min''': Lowest/first value in the data. Can be used for data that can be sorted.		* '''Min''': Lowest/first value in the data. Can be used for data that can be sorted.
	* '''Max''': Highest/last value in the data. Can be used for data that can be sorted.		* '''Max''': Highest/last value in the data. Can be used for data that can be sorted.
	*'''Percentile''': Percentile value. Can be used for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#~~TimeSpan~~\|Timespans]].		*'''Percentile''': Percentile value. Can be used for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Timespan\|Timespans]].
	*'''Stdev''': Sample standard deviation. Can be calculated for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#~~TimeSpan~~\|Timespans]].		*'''Stdev''': Sample standard deviation. Can be calculated for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Timespan\|Timespans]].
	*'''Stdevp''': Population standard deviation. Can be calculated for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#~~TimeSpan~~\|Timespans]].		*'''Stdevp''': Population standard deviation. Can be calculated for numbers, [[Generic_Objects_in_Expression_Language#DateTime\|DateTimes]] and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Timespan\|Timespans]].
	* '''Sum''': Sum of the items. Can be used for numbers and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#~~TimeSpan~~\|Timespans]].		* '''Sum''': Sum of the items. Can be used for numbers and [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Timespan\|Timespans]].
	* '''StringJoin''': Joins array of strings together. The first parameter is a string that is placed between the joined strings.		* '''StringJoin''': Joins array of strings together. The first parameter is a string that is placed between the joined strings.
	*'''Var''': Sample variance. Can be used for numbers.		*'''Var''': Sample variance. Can be used for numbers.