QPR ProcessAnalyzer Objects in Expression Language - Revision history

Ollvihe: /* Model */

2026-06-04T10:09:15Z

Model

← Older revision		Revision as of 10:09, 4 June 2026
Line 418:		Line 418:
	There are the following parameters:		There are the following parameters:
	# '''Parameters''': Dictionary parameters given to the Cortex Agents REST API query (https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-rest-api). There is a special handling for the following parameters:		# '''Parameters''': Dictionary parameters given to the Cortex Agents REST API query (https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-rest-api). There is a special handling for the following parameters:
	#* '''model''': Defines the name of the LLM to use for the operation. If not defined, the [[PA_Configuration_database_table#:~:text=DefaultCortexAgentsModelName\|DefaultCortexAgentsModelName]]system setting.		#* '''model''': Defines the name of the LLM to use for the operation. If not defined, the [[PA_Configuration_database_table#:~:text=DefaultCortexAgentsModelName\|DefaultCortexAgentsModelName]] system setting applies.
	#* '''_tools''': Additional tool_spec of type "cortex_analyst_text_to_sql" will be added to this value with a reference to the generated semantic model.		#* '''_tools''': Additional tool_spec of type "cortex_analyst_text_to_sql" will be added to this value with a reference to the generated semantic model.
	#* '''_tool_resources''': Generated semantic model is added as an additional resource.		#* '''_tool_resources''': Generated semantic model is added as an additional resource.

Ollvihe: /* Model */

2026-06-04T10:08:12Z

Model

← Older revision		Revision as of 10:08, 4 June 2026
Line 414:		Line 414:
	\|\|CortexAgentsQuery		\|\|CortexAgentsQuery
	\|\|		\|\|
	\|\|Creates a Snowflake Cortex semantic model (see ''GetSemanticModel'' function) for the process mining model and makes a natural language query on it using Snowflake Cortex Agents. More information: https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents.		\|\|Creates a Snowflake Cortex semantic model (see the ''GetSemanticModel'' function) for the process mining model and makes a natural language query on it using Snowflake Cortex Agents. More information: https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents.

	There are the following parameters:		There are the following parameters:
	# '''Parameters''': Dictionary parameters given to the Cortex Agents REST API query (https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-rest-api). There is a special handling for the following parameters:		# '''Parameters''': Dictionary parameters given to the Cortex Agents REST API query (https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-rest-api). There is a special handling for the following parameters:
	#* '''model''': ~~If not defined, uses~~ the ~~default Cortex Agents model~~ name ~~configured into~~ the ~~database, or if that is~~ not defined, ~~uses "llama3.1-70b"~~.		#* '''model''': Defines the name of the LLM to use for the operation. If not defined, the [[PA_Configuration_database_table#:~:text=DefaultCortexAgentsModelName\|DefaultCortexAgentsModelName]]system setting.
	#* '''_tools''': Additional tool_spec of type "cortex_analyst_text_to_sql" will be added to this value with a reference to the generated semantic model.		#* '''_tools''': Additional tool_spec of type "cortex_analyst_text_to_sql" will be added to this value with a reference to the generated semantic model.
	#* '''_tool_resources''': Generated semantic model is added as an additional resource.		#* '''_tool_resources''': Generated semantic model is added as an additional resource.

Ollvihe: /* Model */

2026-06-02T13:47:42Z

Model

← Older revision		Revision as of 13:47, 2 June 2026
Line 286:		Line 286:
	Example:		Example:
	<pre>		<pre>
	let newFilter = modelById(1).CreateFilter(#{		let newFilter = modelById(1).CreateFilter(#{
	"Name": "My Filter",		"Name": "My Filter",
	"Rules": #{		"Rules": #{
Line 300:		Line 300:
	"PublishMode": "Public"		"PublishMode": "Public"
	});		});
	}
	</pre>		</pre>
	\|-		\|-

MarHink: /* Script */

2026-06-02T13:18:15Z

Script

← Older revision		Revision as of 13:18, 2 June 2026
Line 1,039:		Line 1,039:
	\|\|LastRunStart (DateTime)		\|\|LastRunStart (DateTime)
	\|\|Timestamp of the last completed script run start time. Null if the Script hasn't been run yet.		\|\|Timestamp of the last completed script run start time. Null if the Script hasn't been run yet.
			\|-
			\|McpPrimitiveType (String)
			\|Returns one of the following values depending on which type of MCP primitive the script supports:

			* Tool
			* Prompt
			* ResourceNull value means that the script does not support any MCP primitive type.
	\|-		\|-
	\|\|Name (String)		\|\|Name (String)

TeeHiet: TK-64701

2026-05-27T10:43:56Z

TK-64701

← Older revision		Revision as of 10:43, 27 May 2026
Line 1,058:		Line 1,058:
	* '''Stopping''': Script has been requested to be stopped, but it's still running. In this status, neither start nor stop can be called for the script. When the script eventually stops, its status changes to ''Ready''.		* '''Stopping''': Script has been requested to be stopped, but it's still running. In this status, neither start nor stop can be called for the script. When the script eventually stops, its status changes to ''Ready''.
	\|-		\|-
	\|\|CanBeUsedAsMcpTool		\|\|CanBeUsedAsMcpTool (Boolean)
	\|\|A boolean value determining whether this script can be used as a MCP tool or not.		\|\|A boolean value determining whether this script can be used as a MCP tool or not.
	\|-		\|-

TeeHiet: TK-64701

2026-05-27T10:43:11Z

TK-64701

← Older revision		Revision as of 10:43, 27 May 2026
Line 1,057:		Line 1,057:
	* '''Running''': Script is running. In this status, the script can be stopped (changing the status to ''Stopping''). Calling stop just requests a script to stop, and the actual stopping occurs some time later.		* '''Running''': Script is running. In this status, the script can be stopped (changing the status to ''Stopping''). Calling stop just requests a script to stop, and the actual stopping occurs some time later.
	* '''Stopping''': Script has been requested to be stopped, but it's still running. In this status, neither start nor stop can be called for the script. When the script eventually stops, its status changes to ''Ready''.		* '''Stopping''': Script has been requested to be stopped, but it's still running. In this status, neither start nor stop can be called for the script. When the script eventually stops, its status changes to ''Ready''.
			\|-
			\|\|CanBeUsedAsMcpTool
			\|\|A boolean value determining whether this script can be used as a MCP tool or not.
			\|-
			\|\|CanBeUsedAsMcpPrompt (Boolean)
			\|\|A boolean value determining whether this script can be used as a MCP prompt or not.
			\|-
			\|\|CanBeUsedAsMcpResource (Boolean)
			\|\|A boolean value determining whether this script can be used as a MCP resource or not.
	\|}		\|}

Ollvihe: /* Project */

2026-05-05T11:35:49Z

Project

← Older revision		Revision as of 11:35, 5 May 2026
Line 856:		Line 856:
	Example:		Example:
	<pre>		<pre>
	ProjectById(123).ModelByName("My Model 1")		ProjectById(123).ModelByName("My Model 1");
	</pre>		</pre>
	\|-		\|-

Ollvihe: /* Project */

2026-05-05T11:35:18Z

Project

← Older revision		Revision as of 11:35, 5 May 2026
Line 808:		Line 808:
	Example:		Example:
	<pre>		<pre>
	ProjectById(123).DatatableByName("MyDatatable1")		ProjectById(123).DatatableByName("MyDatatable1");
	</pre>		</pre>

Ollvihe: /* Project */

2026-05-05T11:34:24Z

Project

← Older revision		Revision as of 11:34, 5 May 2026
Line 781:		Line 781:
	* '''Configuration''' (Dictionary): Script json configuration.		* '''Configuration''' (Dictionary): Script json configuration.

	The function returns the created script object. ~~To call~~ the function, requires ''ManageScripts'' permission for the project, and additionally ~~for SQL scripts,~~ ''RunScripts'' for SQL scripts.		The function returns the created script object. Using the function requires ''ManageScripts'' permission for the project, and additionally ''RunScripts'' for SQL scripts.

	Example: Create an expression script:		Example: Create an expression script:

Ollvihe: /* Project */

2026-05-05T11:33:34Z

Project

← Older revision		Revision as of 11:33, 5 May 2026
Line 779:		Line 779:
	* '''Language''' (String): Language of the script. Options: ''Expression'' (default), or ''SQL''.		* '''Language''' (String): Language of the script. Options: ''Expression'' (default), or ''SQL''.
	* '''Code''' (String): Script code.		* '''Code''' (String): Script code.
			* '''Configuration''' (Dictionary): Script json configuration.

	The function returns the created script object. To call the function, requires ''ManageScripts'' permission for the project, and additionally for SQL scripts, ''RunScripts'' for SQL scripts.		The function returns the created script object. To call the function, requires ''ManageScripts'' permission for the project, and additionally for SQL scripts, ''RunScripts'' for SQL scripts.