QPR ProcessAnalyzer Objects in Expression Language - Revision history

Ollvihe: /* Model */

2026-04-29T11:57:14Z

Model

← Older revision		Revision as of 11:57, 29 April 2026
Line 115:		Line 115:
	\|-		\|-
	\|\|AllFilters (Filter*)		\|\|AllFilters (Filter*)
	\|\|Returns an array of all [[#Filter\|filters]] in the model ~~where~~ the user has access to. In addition to the ''Filters'' property, ''AllFilters'' also returns private filters of other users. The ''ManageViews'' permission is required to use this property.		\|\|Returns an array of all [[#Filter\|filters]] in the model the user has access to. In addition to the ''Filters'' property, ''AllFilters'' also returns private filters of other users. The ''ManageViews'' permission is required to use this property - otherwise error is given.
	\|-		\|-
	\|\|Calendars (BusinessCalendar*)		\|\|Calendars (BusinessCalendar*)

TeeHiet: TK-64041

2026-04-27T11:23:58Z

TK-64041

← Older revision		Revision as of 11:23, 27 April 2026
Line 964:		Line 964:
	\|\|Code (String)		\|\|Code (String)
	\|\|Script code.		\|\|Script code.
			\|-
			\|\|Configuration (Dictionary)
			\|\|Script's configuration.
	\|-		\|-
	\|\|CreatedBy (User)		\|\|CreatedBy (User)

Ollvihe at 08:21, 9 April 2026

2026-04-09T08:21:34Z

← Older revision		Revision as of 08:21, 9 April 2026
Line 694:		Line 694:
	\|\|		\|\|
	\|\|		\|\|
	Creates an object representing connection to QPR MEA (QPR Suite) Web Service. The parameter is a dictionary ~~supporting parameter~~ '''ConnectionStringKey''' which defines the MEA connection string secret name in the same project.		Creates an object representing connection to QPR MEA (QPR Suite) Web Service. The function parameter is a dictionary containing the property '''ConnectionStringKey''' which defines the MEA connection string secret name in the same project. When the connection object has been created, MEA Web Service [[QPR_MEA_Integration\|queries and other operations]] can be executed using it.

	Example: create connection:		Example: create connection:
Line 701:		Line 701:
	</pre>		</pre>

	Example: ~~[[QPR_MEA_Integration\|~~use connection]]:		Example: use connection:
	<pre>		<pre>
	let results = connection.QueryObjects("[PG.785401983.683494101]", "name, typename");		let results = connection.QueryObjects("[PG.785401983.683494101]", "name, typename");

Ollvihe: /* Project */

2026-04-08T23:21:12Z

Project

← Older revision		Revision as of 23:21, 8 April 2026
Line 694:		Line 694:
	\|\|		\|\|
	\|\|		\|\|
	Creates an object representing connection to QPR MEA (QPR Suite) Web Service. The parameter is a dictionary supporting parameter '''ConnectionStringKey''' which defines the secret name ~~for~~ the ~~MEA connection string~~.		Creates an object representing connection to QPR MEA (QPR Suite) Web Service. The parameter is a dictionary supporting parameter '''ConnectionStringKey''' which defines the MEA connection string secret name in the same project.

	Example to create ~~the~~ connection:		Example: create connection:
	<pre>		<pre>
	let connection = ProjectByName("MyProject").CreateMeaConnection( #{"ConnectionStringKey": "MyMeaConnection"} );		let connection = ProjectByName("MyProject").CreateMeaConnection( #{"ConnectionStringKey": "MyMeaConnection"} );
	</pre>		</pre>

	Example [[QPR_MEA_Integration\|to use ~~the~~ connection]]:		Example: [[QPR_MEA_Integration\|use connection]]:
	<pre>		<pre>
	let results = connection.QueryObjects("[PG.785401983.683494101]", "name, typename");		let results = connection.QueryObjects("[PG.785401983.683494101]", "name, typename");

Ollvihe: /* Project */

2026-04-08T23:20:07Z

Project

← Older revision		Revision as of 23:20, 8 April 2026
Line 694:		Line 694:
	\|\|		\|\|
	\|\|		\|\|
	Creates an object representing connection to QPR MEA (QPR Suite) Web Service. The parameter is a dictionary supporting parameter '''ConnectionStringKey''' which defines the secret name for the MEA connection string~~. More information [[QPR_MEA_Integration\|how to use the connection]]~~.		Creates an object representing connection to QPR MEA (QPR Suite) Web Service. The parameter is a dictionary supporting parameter '''ConnectionStringKey''' which defines the secret name for the MEA connection string.

	Example to create the connection:		Example to create the connection:
Line 701:		Line 701:
	</pre>		</pre>

	Example to use the connection:		Example [[QPR_MEA_Integration\|to use the connection]]:
	<pre>		<pre>
	let results = connection.QueryObjects("[PG.785401983.683494101]", "name, typename");		let results = connection.QueryObjects("[PG.785401983.683494101]", "name, typename");

Ollvihe: /* Project */

2026-04-08T23:19:13Z

Project

← Older revision		Revision as of 23:19, 8 April 2026
Line 694:		Line 694:
	\|\|		\|\|
	\|\|		\|\|
	Creates an object representing connection to QPR MEA (QPR Suite) Web Service. The parameter is ~~an optional~~ dictionary ~~specifying connection parameters. Supported parameters are:~~		Creates an object representing connection to QPR MEA (QPR Suite) Web Service. The parameter is a dictionary supporting parameter '''ConnectionStringKey''' which defines the secret name for the MEA connection string. More information [[QPR_MEA_Integration\|how to use the connection]].
	* '''ConnectionStringKey'''~~: If given, this string will be used to connect to~~ the ~~target cluster using ODBC.~~
	~~1. The actual value of~~ the ~~used QPR~~ MEA connection string ~~(#2603041520319#) is stored into~~ the ~~secure value store using "QprMea" item type~~.

	Example to create the connection:		Example to create the connection:
	<pre>		<pre>
	let ~~connectionObject~~ = ProjectByName("MyProject")		let connection = ProjectByName("MyProject").CreateMeaConnection( #{"ConnectionStringKey": "MyMeaConnection"} );
	.CreateMeaConnection( #{"ConnectionStringKey": "MyMeaConnection"} );
	</pre>		</pre>

	Example to use the connection:		Example to use the connection:
	<pre>		<pre>
	~~connectionObject~~.QueryObjects(		let results = connection.QueryObjects("[PG.785401983.683494101]", "name, typename");
	"[PG.785401983.683494101]",
	"name, typename"
	);
	</pre>		</pre>
	\|-		\|-

Ollvihe: /* Project */

2026-04-08T12:43:28Z

Project

← Older revision		Revision as of 12:43, 8 April 2026
Line 881:		Line 881:
	Parameters:		Parameters:
	# '''Type''' (string): Secret type which is one of the following:		# '''Type''' (string): Secret type which is one of the following:
	#* "externaldatatableconnection": ODBC connection string ~~used by a datatable~~ (e.g., ~~connection string~~ to ~~Snowflake~~ or ~~SQL Server database~~)		#* "externaldatatableconnection": Snowflake ODBC connection string for datatables.
	#* "~~odbc~~": ~~ODBC~~ connection string (e.g., to extract data, or load a model ~~directly~~)		#* "odbc": ODBC connection string (e.g., to extract data in scripts, or load an in-memory model).
	#* "sap": SAP password		#* "oledb": OleDB connection string (e.g., to extract data in scripts, or load an in-memory model).
	#* "salesforce": Salesforce password		#* "sap": SAP password.
			#* "salesforce": Salesforce password.
			#* "sql": SQL Server connection string.
			#* "qprmea": QPR MEA connection string.
	# '''Name''' (string): Secret name, used to refer to the secret in the commands.		# '''Name''' (string): Secret name, used to refer to the secret in the commands.
	# '''Value''' (string): Secret value which contains the confidential information.		# '''Value''' (string): Secret value which contains the confidential information.

Ollvihe: /* Project */

2026-04-08T12:35:06Z

Project

@@ Line 694: / Line 694: @@
 ||
 ||
-Creates an object representing connection to QPR MEA Web Service.
+Creates an object representing connection to QPR MEA (QPR Suite) Web Service. The parameter is an optional dictionary specifying connection parameters. Supported parameters are:
+* '''ConnectionStringKey''': If given, this string will be used to connect to the target cluster using ODBC.
 . The actual value of the used QPR MEA connection string (#2603041520319#) is stored into the secure value store using "QprMea" item type.
-{"url": "https://<hostname>/QPR/Portal/QPR.Isapi.dll/wsforward/MainService.svc/webHttp", "logOnName": "...", "password": "..."}
+Example to create the connection:
 |-
 ||CreateModel (Model)

Ollvihe: /* Project */

2026-04-08T09:49:30Z

Project

@@ Line 694: / Line 694: @@
 ||
 ||
 |-
 ||CreateModel (Model)

Ollvihe: /* Project */

2026-04-08T09:40:46Z

Project

← Older revision		Revision as of 09:40, 8 April 2026
Line 690:		Line 690:
	});		});
	</pre>		</pre>
			\|-
			\|\|CreateMeaConnection
			\|\|
			\|\|
	\|-		\|-
	\|\|CreateModel (Model)		\|\|CreateModel (Model)

← Older revision		Revision as of 11:23, 27 April 2026
Line 964:		Line 964:
	\|\|Code (String)		\|\|Code (String)
	\|\|Script code.		\|\|Script code.
			\|-
			\|\|Configuration (Dictionary)
			\|\|Script's configuration.
	\|-		\|-
	\|\|CreatedBy (User)		\|\|CreatedBy (User)