Select (TQL) - Revision history

Maxim@tygron.com: /* List of Select types */

2025-12-09T09:32:13Z

List of Select types

← Older revision		Revision as of 09:32, 9 December 2025
Line 36:		Line 36:
	{{: Select landpolygons (TQL)}}		{{: Select landpolygons (TQL)}}
	{{: Select landsize (TQL)}}		{{: Select landsize (TQL)}}
			{{: Select latitude (TQL)}}
	{{: Select length (TQL)}}		{{: Select length (TQL)}}
	{{: Select levees (TQL)}}		{{: Select levees (TQL)}}
			{{: Select longitude (TQL)}}
	{{: Select lotpolygons (TQL)}}		{{: Select lotpolygons (TQL)}}
	{{: Select lotsize (TQL)}}		{{: Select lotsize (TQL)}}

Maxim@tygron.com: /* List of Select types */

2024-11-14T14:46:52Z

List of Select types

← Older revision		Revision as of 14:46, 14 November 2024
Line 32:		Line 32:
	{{: Select gridvolume (TQL)}}		{{: Select gridvolume (TQL)}}
	{{: Select gridstdev (TQL)}}		{{: Select gridstdev (TQL)}}
			{{: Select iteration (TQL)}}
			{{: Select iterations (TQL)}}
	{{: Select landpolygons (TQL)}}		{{: Select landpolygons (TQL)}}
	{{: Select landsize (TQL)}}		{{: Select landsize (TQL)}}

Maxim@tygron.com: /* List of Select types */

2024-09-03T12:13:11Z

List of Select types

← Older revision		Revision as of 12:13, 3 September 2024
Line 29:		Line 29:
	{{: Select gridmin (TQL)}}		{{: Select gridmin (TQL)}}
	{{: Select gridmax (TQL)}}		{{: Select gridmax (TQL)}}
			{{: Select gridarea (TQL)}}
	{{: Select gridvolume (TQL)}}		{{: Select gridvolume (TQL)}}
	{{: Select gridstdev (TQL)}}		{{: Select gridstdev (TQL)}}

Rudolf@tygron.nl at 06:57, 22 December 2023

2023-12-22T06:57:06Z

← Older revision		Revision as of 06:57, 22 December 2023
Line 3:		Line 3:
	===Composition of a Select Query===		===Composition of a Select Query===
	A Select TQL query always start using the <code>SELECT</code> statement for [[TQL]] provides a means of obtaining data of a [[session]].		A Select TQL query always start using the <code>SELECT</code> statement for [[TQL]] provides a means of obtaining data of a [[session]].
	The 'Select' statement is consists of the <code>SELECT</code> word followed by a selection type and the word <code>WHERE</code>. Depending on the selection type one or more [[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 'Select' statement is consists of the <code>SELECT</code> word followed by a selection type and the word <code>WHERE</code>. Depending on the selection type 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>SELECT_LOTSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_STAKEHOLDERTYPE_IS_MUNICIPALITY</code>. In this example, <code>SELECT_LOTSIZE_WHERE</code> is the statement. <code>CATEGORY_IS_SOCIAL</code> is the first clause, and <code>STAKEHOLDERTYPE_IS_MUNICIPALITY</code> is the second clause. It would return all the land area taken up with social housing, which is also owned by a municipal [[stakeholder]].		An example of a TQL select statement is: <code>SELECT_LOTSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_STAKEHOLDERTYPE_IS_MUNICIPALITY</code>. In this example, <code>SELECT_LOTSIZE_WHERE</code> is the statement. <code>CATEGORY_IS_SOCIAL</code> is the first clause, and <code>STAKEHOLDERTYPE_IS_MUNICIPALITY</code> is the second clause. It would return all the land area taken up with social housing, which is also owned by a municipal [[stakeholder]].

Frank@tygron.nl: /* Executing a Select Query */

2023-02-28T09:46:16Z

Executing a Select Query

← Older revision		Revision as of 09:46, 28 February 2023
Line 12:		Line 12:
	* [[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 Select types===		===List of Select types===

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

2023-02-17T14:19:47Z

List of Select types

← Older revision		Revision as of 14:19, 17 February 2023
Line 15:		Line 15:

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

Frank@tygron.nl at 14:17, 17 February 2023

2023-02-17T14:17:43Z

← Older revision		Revision as of 14:17, 17 February 2023
Line 1:		Line 1:
	Select TQL queries allow users to obtain specific numerical, textual or polygonal information from the data in a [[session]] of a [[project]]. By adding various clauses to a selection statement, the query can be made more specific.		Select TQL queries allow users to obtain specific numerical, textual or polygonal information from the data in a [[session]] of a [[project]]. By adding various clauses to a selection statement, the query can be made more specific.

			===Composition of a Select Query===
			A Select TQL query always start using the <code>SELECT</code> statement for [[TQL]] provides a means of obtaining data of a [[session]].
			The 'Select' statement is consists of the <code>SELECT</code> word followed by a selection type and the word <code>WHERE</code>. Depending on the selection type one or more [[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>SELECT_LOTSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_STAKEHOLDERTYPE_IS_MUNICIPALITY</code>. In this example, <code>SELECT_LOTSIZE_WHERE</code> is the statement. <code>CATEGORY_IS_SOCIAL</code> is the first clause, and <code>STAKEHOLDERTYPE_IS_MUNICIPALITY</code> is the second clause. It would return all the land area taken up with social housing, which is also owned by a municipal [[stakeholder]].

			===Executing a Select 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.
Line 6:		Line 13:
	* [[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]]		* <code>EditorBuildingEventType:QUERY</code> using the [[API]]

	~~===Composition of a Select Query===~~
	~~A Select TQL query always start using the <code>SELECT</code> statement for [[TQL]] provides a means of obtaining data of a [[session]].~~
	The 'Select' statement is consists of the <code>SELECT</code> word followed by a selection type and the word <code>WHERE</code>. Depending on the selection type one or more [[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>SELECT_LOTSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_STAKEHOLDERTYPE_IS_MUNICIPALITY</code>. In this example, <code>SELECT_LOTSIZE_WHERE</code> is the statement. <code>CATEGORY_IS_SOCIAL</code> is the first clause, and <code>STAKEHOLDERTYPE_IS_MUNICIPALITY</code> is the second clause. It would return all the land area taken up with social housing, which is also owned by a municipal [[stakeholder]].

	===List of Select types===		===List of Select types===

Frank@tygron.nl at 14:17, 17 February 2023

2023-02-17T14:17:07Z

← Older revision		Revision as of 14:17, 17 February 2023
Line 7:		Line 7:
	* <code>EditorBuildingEventType:QUERY</code> using the [[API]]		* <code>EditorBuildingEventType:QUERY</code> using the [[API]]

			===Composition of a Select Query===
	A Select TQL query always start using the <code>SELECT</code> statement for [[TQL]] provides a means of obtaining data of a [[session]].		A Select TQL query always start using the <code>SELECT</code> statement for [[TQL]] provides a means of obtaining data of a [[session]].
	The 'Select' statement is consists of the <code>SELECT</code> word followed by a selection type and the word <code>WHERE</code>. Depending on the selection type one or more [[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 'Select' statement is consists of the <code>SELECT</code> word followed by a selection type and the word <code>WHERE</code>. Depending on the selection type one or more [[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>.
Line 12:		Line 13:
	An example of a TQL select statement is: <code>SELECT_LOTSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_STAKEHOLDERTYPE_IS_MUNICIPALITY</code>. In this example, <code>SELECT_LOTSIZE_WHERE</code> is the statement. <code>CATEGORY_IS_SOCIAL</code> is the first clause, and <code>STAKEHOLDERTYPE_IS_MUNICIPALITY</code> is the second clause. It would return all the land area taken up with social housing, which is also owned by a municipal [[stakeholder]].		An example of a TQL select statement is: <code>SELECT_LOTSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_STAKEHOLDERTYPE_IS_MUNICIPALITY</code>. In this example, <code>SELECT_LOTSIZE_WHERE</code> is the statement. <code>CATEGORY_IS_SOCIAL</code> is the first clause, and <code>STAKEHOLDERTYPE_IS_MUNICIPALITY</code> is the second clause. It would return all the land area taken up with social housing, which is also owned by a municipal [[stakeholder]].

			===List of Select types===
	{{Select TQL\|suppresscategory=true\|allowselflinks=true\|list=true\|		{{Select TQL\|suppresscategory=true\|allowselflinks=true\|list=true\|
	{{: Select active (TQL)}}		{{: Select active (TQL)}}

Frank@tygron.nl at 14:15, 17 February 2023

2023-02-17T14:15:50Z

← Older revision		Revision as of 14:15, 17 February 2023
Line 5:		Line 5:
	* [[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.
	* [[EditorBuildingEventType]]:QUERY using the [[API]]		* <code>EditorBuildingEventType:QUERY</code> using the [[API]]

	A Select TQL query always start using the <code>SELECT</code> statement for [[TQL]] provides a means of obtaining data of a [[session]].		A Select TQL query always start using the <code>SELECT</code> statement for [[TQL]] provides a means of obtaining data of a [[session]].

Frank@tygron.nl at 14:15, 17 February 2023

2023-02-17T14:15:12Z

← Older revision		Revision as of 14:15, 17 February 2023
Line 4:		Line 4:
	* [[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.		* [[Global]]s; Executed every calculation.
	* [[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.
	* [[EditorBuildingEventType]]:QUERY using the [[API]]		* [[EditorBuildingEventType]]:QUERY using the [[API]]