Update (TQL) - Revision history

Frank@tygron.nl: /* Composition of an Update Query */

2026-06-09T09:39:53Z

Composition of an Update Query

← Older revision		Revision as of 09:39, 9 June 2026
Line 5:		Line 5:
	The 'Update' statement is consists of the <code>UPDATE</code> word followed by the context, for example <code>AREA</code>. Next the [[attribute]] to update is stated, followed by the word <code>WHERE</code>. Depending on the context, one or more [[Clause (TQL)\|clause]]s can be added. Clauses are separated with the <code>AND</code> word. All of these parts are separated by an underscore <code>_</code>.		The 'Update' statement is consists of the <code>UPDATE</code> word followed by the context, for example <code>AREA</code>. Next the [[attribute]] to update is stated, followed by the word <code>WHERE</code>. Depending on the context, one or more [[Clause (TQL)\|clause]]s can be added. Clauses are separated with the <code>AND</code> word. All of these parts are separated by an underscore <code>_</code>.

	An example of a TQL ~~select~~ statement is: <code>UPDATE_AREA_WATER_LEVEL_M_WHERE_AREA_IS_0</code>. In this example:		An example of a TQL Update statement is: <code>UPDATE_AREA_WATER_LEVEL_M_WHERE_AREA_IS_0</code>. In this example:
	* <code>UPDATE</code> is the statement		* <code>UPDATE</code> is the statement
	* <code>AREA</code> is the context		* <code>AREA</code> is the context

Frank@tygron.nl: /* List of TQL Update types */

2026-06-09T09:39:24Z

List of TQL Update types

← Older revision		Revision as of 09:39, 9 June 2026
Line 20:		Line 20:

	===List of TQL Update types===		===List of TQL Update types===
	Click on the link of specific ~~Select~~ TQL types to see what you can do with them.		Click on the link of specific TQL Update types to see what you can do with them.
	{{Update TQL\|suppresscategory=true\|allowselflinks=true\|list=true\|		{{Update TQL\|suppresscategory=true\|allowselflinks=true\|list=true\|
	{{: Update address attribute (TQL)}}		{{: Update address attribute (TQL)}}

Frank@tygron.nl: /* List of Update types */

2026-06-09T09:39:04Z

List of Update types

← Older revision		Revision as of 09:39, 9 June 2026
Line 19:		Line 19:
	* [[API]]'s query endpoint; Using <code>api/session/query/<TQLQUERY></code> with an additional parameter for the update value.		* [[API]]'s query endpoint; Using <code>api/session/query/<TQLQUERY></code> with an additional parameter for the update value.

	===List of Update types===		===List of TQL Update types===
	Click on the link of specific Select TQL types to see what you can do with them.		Click on the link of specific Select TQL types to see what you can do with them.
	{{Update TQL\|suppresscategory=true\|allowselflinks=true\|list=true\|		{{Update TQL\|suppresscategory=true\|allowselflinks=true\|list=true\|

Frank@tygron.nl: /* Composition of an Update Query======Composition of a Select Query */

2026-05-20T12:44:56Z

Composition of an Update Query======Composition of a Select Query

← Older revision		Revision as of 12:44, 20 May 2026
Line 1:		Line 1:
	Update TQL queries allow users to set numerical values for specific [[item]] in a [[session]] of a [[project]]. By adding various clauses to an update statement, the query can be made more specific.		Update TQL queries allow users to set numerical values for specific [[item]] in a [[session]] of a [[project]]. By adding various clauses to an update statement, the query can be made more specific.

	===Composition of an Update ~~Query======Composition of a Select~~ Query===		===Composition of an Update Query===
	An Update TQL query provides a means to update an attribute to one or more values for a selection of data of a [[session]].		An Update TQL query provides a means to update an attribute to one or more values for a selection of data of a [[session]].
	The 'Update' statement is consists of the <code>UPDATE</code> word followed by the context, for example <code>AREA</code>. Next the [[attribute]] to update is stated, followed by the word <code>WHERE</code>. Depending on the context, one or more [[Clause (TQL)\|clause]]s can be added. Clauses are separated with the <code>AND</code> word. All of these parts are separated by an underscore <code>_</code>.		The 'Update' statement is consists of the <code>UPDATE</code> word followed by the context, for example <code>AREA</code>. Next the [[attribute]] to update is stated, followed by the word <code>WHERE</code>. Depending on the context, one or more [[Clause (TQL)\|clause]]s can be added. Clauses are separated with the <code>AND</code> word. All of these parts are separated by an underscore <code>_</code>.

Frank@tygron.nl: /* Executing an Update Query */

2026-05-20T12:42:24Z

Executing an Update Query

← Older revision		Revision as of 12:42, 20 May 2026
Line 15:		Line 15:
	===Executing an Update Query===		===Executing an Update Query===
	TQL Queries can be executed using:		TQL Queries can be executed using:
	* [[Query Tool]] in the {{software}}; For creating and testing TQL queries.		* [[Query Tool]] in the {{software}}; For creating and testing TQL queries. Update value can be supplied using the corresponding field.
	* [[Excel Indicator#Naming Cells\|Names in Excel]]s; Used for [[Indicator]] and [[Panel]]s and supports more complex queries.		* [[Excel Indicator#Naming Cells\|Names in Excel]]s; Used for [[Indicator]] and [[Panel]]s and supports more complex queries. The update value is obtained from the Excel cell to which the TQL statement is [[TQL (Excel)\|linked]].
	* [[API]]'s query endpoint; Using <code>api/session/query/<TQLQUERY></code>		* [[API]]'s query endpoint; Using <code>api/session/query/<TQLQUERY></code> with an additional parameter for the update value.

	===List of Update types===		===List of Update types===

Frank@tygron.nl: /* Composition of an Update Query======Composition of a Select Query */

2026-05-20T12:40:17Z

Composition of an Update Query======Composition of a Select Query

← Older revision		Revision as of 12:40, 20 May 2026
Line 11:		Line 11:
	* <code>AREA__IS_0</code> is the first clause.		* <code>AREA__IS_0</code> is the first clause.

	This adds or updates the attribute WATER_LEVEL_M for the area with ID 0 to a particular value. The particular value is supplied separately and the way it is supplied depends on the ~~context~~ in which this statement is executed.		This adds or updates the attribute WATER_LEVEL_M for the area with ID 0 to a particular value. The particular value is supplied separately and the way it is supplied depends on the situation in which this statement is executed.

	===Executing an Update Query===		===Executing an Update Query===

Frank@tygron.nl: /* Composition of an Update Query */

2026-05-20T12:40:03Z

Composition of an Update Query

← Older revision		Revision as of 12:40, 20 May 2026
Line 1:		Line 1:
	Update TQL queries allow users to set numerical values for specific [[item]] in a [[session]] of a [[project]]. By adding various clauses to an update statement, the query can be made more specific.		Update TQL queries allow users to set numerical values for specific [[item]] in a [[session]] of a [[project]]. By adding various clauses to an update statement, the query can be made more specific.

	===Composition of an Update Query===		===Composition of an Update Query======Composition of a Select Query===
			An Update TQL query provides a means to update an attribute to one or more values for a selection of data of a [[session]].
			The 'Update' statement is consists of the <code>UPDATE</code> word followed by the context, for example <code>AREA</code>. Next the [[attribute]] to update is stated, followed by the word <code>WHERE</code>. Depending on the context, one or more [[Clause (TQL)\|clause]]s can be added. Clauses are separated with the <code>AND</code> word. All of these parts are separated by an underscore <code>_</code>.

			An example of a TQL select statement is: <code>UPDATE_AREA_WATER_LEVEL_M_WHERE_AREA_IS_0</code>. In this example:
			* <code>UPDATE</code> is the statement
			* <code>AREA</code> is the context
			* <code>WATER_LEVEL_M</code> is the attribute
			* <code>AREA__IS_0</code> is the first clause.

			This adds or updates the attribute WATER_LEVEL_M for the area with ID 0 to a particular value. The particular value is supplied separately and the way it is supplied depends on the context in which this statement is executed.

	===Executing an Update Query===		===Executing an Update Query===

Frank@tygron.nl: /* Executing an Update Query */

2026-05-20T12:26:07Z

Executing an Update Query

← Older revision		Revision as of 12:26, 20 May 2026
Line 6:		Line 6:
	TQL Queries can be executed using:		TQL Queries can be executed using:
	* [[Query Tool]] in the {{software}}; For creating and testing TQL queries.		* [[Query Tool]] in the {{software}}; For creating and testing TQL queries.
	* [[Global]]s; Executed every calculation.
	* [[Excel Indicator#Naming Cells\|Names in Excel]]s; Used for [[Indicator]] and [[Panel]]s and supports more complex queries.		* [[Excel Indicator#Naming Cells\|Names in Excel]]s; Used for [[Indicator]] and [[Panel]]s and supports more complex queries.
	* [[API]]'s query endpoint; Using <code>api/session/query/<TQLQUERY></code>		* [[API]]'s query endpoint; Using <code>api/session/query/<TQLQUERY></code>

Frank@tygron.nl at 10:30, 28 February 2023

2023-02-28T10:30:52Z

← Older revision		Revision as of 10:30, 28 February 2023
Line 8:		Line 8:
	* [[Global]]s; Executed every calculation.		* [[Global]]s; Executed every calculation.
	* [[Excel Indicator#Naming Cells\|Names in Excel]]s; Used for [[Indicator]] and [[Panel]]s and supports more complex queries.		* [[Excel Indicator#Naming Cells\|Names in Excel]]s; Used for [[Indicator]] and [[Panel]]s and supports more complex queries.
	* <code>~~EditorBuildingEventType:QUERY~~</code> ~~using the [[API]]~~		* [[API]]'s query endpoint; Using <code>api/session/query/<TQLQUERY></code>

	===List of Update types===		===List of Update types===

Frank@tygron.nl: /* List of Update types */

2023-02-17T14:32:22Z

List of Update types

@@ Line 14: / Line 14: @@
 {{Update TQL|suppresscategory=true|allowselflinks=true|list=true|
 {{: Update address attribute (TQL)}}
 }}
 {{TQL nav}}