YK (TQL) - Revision history

Frank@tygron.nl: /* Example */

2026-05-20T13:14:17Z

Example

← Older revision		Revision as of 13:14, 20 May 2026
Line 28:		Line 28:
	The TQL statement to obtain the names of the Culverts used by the Water Overlay is:		The TQL statement to obtain the names of the Culverts used by the Water Overlay is:
	<pre>SELECT_NAME_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6</pre>
	which internally is replaced with a list of TQL ~~statements~~, separated by comma's,		which internally is replaced with a list of TQL statement arrays, separated by comma's,
	<pre>[SELECT_NAME_WHERE_BUILDING_IS_0_AND_GRID_IS_6], [SELECT_NAME_WHERE_BUILDING_IS_2_AND_GRID_IS_6], [SELECT_NAME_WHERE_BUILDING_IS_5_AND_GRID_IS_6]</pre>		<pre>[SELECT_NAME_WHERE_BUILDING_IS_0_AND_GRID_IS_6], [SELECT_NAME_WHERE_BUILDING_IS_2_AND_GRID_IS_6], [SELECT_NAME_WHERE_BUILDING_IS_5_AND_GRID_IS_6]</pre>
	Its result will be a list of arrays of names, separated by a comma:		Its result will be a list of arrays of names, separated by a comma:

Frank@tygron.nl at 14:54, 19 May 2026

2026-05-19T14:54:17Z

← Older revision		Revision as of 14:54, 19 May 2026
Line 1:		Line 1:
	The 'YK' clause value is a variation on the [[YA (TQL)\|'YA']] clause value. The characters 'YK' should be followed by an underscore and the name of a [[Key]]; for example '''YK_CULVERT_DIAMETER'''~~. Also see the [[#Example\|example ]]below~~.		The 'YK' clause value is a variation on the [[YA (TQL)\|'YA']] clause value. The characters 'YK' should be followed by an underscore and the name of a [[Key]]; for example '''YK_CULVERT_DIAMETER'''.

	This Key is used to obtain the name of an Attribute, given a Grid Overlay. This Grid Overlay is obtained from the same TQL statement, which should contain one of the following clause parameters:		This Key is used to obtain the name of an Attribute, given a Grid Overlay. This Grid Overlay is obtained from the same TQL statement, which should contain one of the following clause parameters:

Frank@tygron.nl at 14:51, 19 May 2026

2026-05-19T14:51:54Z

← Older revision		Revision as of 14:51, 19 May 2026
Line 34:		Line 34:
	Similarly, the TQL statement to obtain the culvert Diameters of the Culverts used by the water Overlay is:		Similarly, the TQL statement to obtain the culvert Diameters of the Culverts used by the water Overlay is:
	<pre>SELECT_ATTRIBUTE_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6_AND_KEY_IS_CULVERT_DIAMETER</pre>		<pre>SELECT_ATTRIBUTE_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6_AND_KEY_IS_CULVERT_DIAMETER</pre>
	Its result will be ~~a list~~ of arrays ~~of values~~, separated by a comma:		Its result will be an array of value arrays, separated by a comma:
	<pre>[0.2], [1.0], [2.0]</pre>		<pre>[0.2], [1.0], [2.0]</pre>

Frank@tygron.nl: /* Clause Parameters */

2026-05-19T12:56:16Z

Clause Parameters

← Older revision		Revision as of 12:56, 19 May 2026
Line 42:		Line 42:
	{{article end		{{article end
	\|notes=*In case no Grid is specified by any of the other clauses of the original TQL statement, the result will be 0 generated TQL statements; an empty array.		\|notes=*In case no Grid is specified by any of the other clauses of the original TQL statement, the result will be 0 generated TQL statements; an empty array.
			*The following variants on YA exist:
			**YCK: A combination between [[YC (TQL)\|YC]] and [[YK (TQL)\|YK]].
	\|seealso=		\|seealso=
	*[[XK (TQL)]]		*[[XK (TQL)]]

Frank@tygron.nl: /* Example */

2026-05-19T11:49:29Z

Example

← Older revision		Revision as of 11:49, 19 May 2026
Line 29:		Line 29:
	<pre>SELECT_NAME_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6</pre>
	which internally is replaced with a list of TQL statements, separated by comma's,		which internally is replaced with a list of TQL statements, separated by comma's,
	<pre>SELECT_NAME_WHERE_BUILDING_IS_0_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_2_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_5_AND_GRID_IS_6</pre>		<pre>[SELECT_NAME_WHERE_BUILDING_IS_0_AND_GRID_IS_6], [SELECT_NAME_WHERE_BUILDING_IS_2_AND_GRID_IS_6], [SELECT_NAME_WHERE_BUILDING_IS_5_AND_GRID_IS_6]</pre>
	Its result will be a list of arrays of names, separated by a comma:		Its result will be a list of arrays of names, separated by a comma:
	<pre>["Duiker A"], ["Duiker B"], ["Duiker M"]</pre>		<pre>["Duiker A"], ["Duiker B"], ["Duiker M"]</pre>

Frank@tygron.nl: /* Example */

2026-05-15T15:00:49Z

Example

← Older revision		Revision as of 15:00, 15 May 2026
Line 30:		Line 30:
	which internally is replaced with a list of TQL statements, separated by comma's,		which internally is replaced with a list of TQL statements, separated by comma's,
	<pre>SELECT_NAME_WHERE_BUILDING_IS_0_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_2_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_5_AND_GRID_IS_6</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_0_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_2_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_5_AND_GRID_IS_6</pre>
	Its result will be a list of names, separated by comma's:		Its result will be a list of arrays of names, separated by a comma:
	<pre>["Duiker A"], ["Duiker B"], ["Duiker M"]</pre>		<pre>["Duiker A"], ["Duiker B"], ["Duiker M"]</pre>
	Similarly, the TQL statement to obtain the culvert Diameters of the Culverts used by the water Overlay is:		Similarly, the TQL statement to obtain the culvert Diameters of the Culverts used by the water Overlay is:
	<pre>SELECT_ATTRIBUTE_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6_AND_KEY_IS_CULVERT_DIAMETER</pre>		<pre>SELECT_ATTRIBUTE_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6_AND_KEY_IS_CULVERT_DIAMETER</pre>
	Its result will be a list of values, separated by comma's:		Its result will be a list of arrays of values, separated by a comma:
	<pre>[0.2], [1.0], [2.0]</pre>		<pre>[0.2], [1.0], [2.0]</pre>

Frank@tygron.nl at 14:35, 15 May 2026

2026-05-15T14:35:50Z

← Older revision		Revision as of 14:35, 15 May 2026
Line 6:		Line 6:
	* [[Gridtype (TQL Param)]]		* [[Gridtype (TQL Param)]]

	The result of using 'YK' for the clause value, is the automatic creation of multiple TQL statements, one with each Item ID for that Clause Parameter that can be found in the project data. Items are only taken into account of they ~~contain~~ the attribute specified ~~for~~ the ~~indicated key~~.		The result of using 'YK' for the clause value, is the automatic creation of multiple TQL statements, one with each Item ID for that Clause Parameter that can be found in the project data. Items are only taken into account of they have a non-zero value for the attribute specified by the Grid Overlay [[Key]].

	Internally, the resulting TQL statements are placed an array of arrays; Similarly the result will be an array of TQL result arrays.		Internally, the resulting TQL statements are placed an array of arrays; Similarly the result will be an array of TQL result arrays.

Frank@tygron.nl at 14:34, 15 May 2026

2026-05-15T14:34:22Z

← Older revision		Revision as of 14:34, 15 May 2026
Line 1:		Line 1:
	The YK clause value is a variation on the [[YA (TQL)\|YA]] clause value. The characters 'YK' should be followed by an underscore and the name of a [[Key]]; for example '''YK_CULVERT_DIAMETER'''. Also see the [[#Example\|example ]]below.		The 'YK' clause value is a variation on the [[YA (TQL)\|'YA']] clause value. The characters 'YK' should be followed by an underscore and the name of a [[Key]]; for example '''YK_CULVERT_DIAMETER'''. Also see the [[#Example\|example ]]below.

	This Key is used to obtain the name of an Attribute, given a Grid Overlay. This Grid Overlay is obtained from the same TQL statement, which should contain one of the following clause parameters:		This Key is used to obtain the name of an Attribute, given a Grid Overlay. This Grid Overlay is obtained from the same TQL statement, which should contain one of the following clause parameters:

Frank@tygron.nl at 14:32, 15 May 2026

2026-05-15T14:32:03Z

← Older revision		Revision as of 14:32, 15 May 2026
Line 31:		Line 31:
	<pre>SELECT_NAME_WHERE_BUILDING_IS_0_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_2_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_5_AND_GRID_IS_6</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_0_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_2_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_5_AND_GRID_IS_6</pre>
	Its result will be a list of names, separated by comma's:		Its result will be a list of names, separated by comma's:
	<pre>"Duiker A", "Duiker B", "Duiker M"</pre>		<pre>["Duiker A"], ["Duiker B"], ["Duiker M"]</pre>
	Similarly, the TQL statement to obtain the culvert Diameters of the Culverts used by the water Overlay is:		Similarly, the TQL statement to obtain the culvert Diameters of the Culverts used by the water Overlay is:
	<pre>SELECT_ATTRIBUTE_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6_AND_KEY_IS_CULVERT_DIAMETER</pre>		<pre>SELECT_ATTRIBUTE_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6_AND_KEY_IS_CULVERT_DIAMETER</pre>
	Its result will be a list of values, separated by comma's:		Its result will be a list of values, separated by comma's:
	<pre>0.2, 1.0, 2.0</pre>		<pre>[0.2], [1.0], [2.0]</pre>

	==Clause Parameters==		==Clause Parameters==

Frank@tygron.nl: Created page with "The YK clause value is a variation on the YA clause value. The characters 'YK' should be followed by an underscore and the name of a Key; for example '''YK_CULVERT_DIAMETER'''. Also see the example below. This Key is used to obtain the name of an Attribute, given a Grid Overlay. This Grid Overlay is obtained from the same TQL statement, which should contain one of the following clause parameters: * Grid (TQL Param) * Grid with attri..."

2026-05-15T14:30:48Z

Created page with "The YK clause value is a variation on the YA clause value. The characters 'YK' should be followed by an underscore and the name of a Key; for example '''YK_CULVERT_DIAMETER'''. Also see the example below. This Key is used to obtain the name of an Attribute, given a Grid Overlay. This Grid Overlay is obtained from the same TQL statement, which should contain one of the following clause parameters: * Grid (TQL Param) * Grid with attri..."

New page

The YK clause value is a variation on the [[YA (TQL)|YA]] clause value. The characters 'YK' should be followed by an underscore and the name of a [[Key]]; for example '''YK_CULVERT_DIAMETER'''. Also see the [[#Example|example ]]below.

This Key is used to obtain the name of an Attribute, given a Grid Overlay. This Grid Overlay is obtained from the same TQL statement, which should contain one of the following clause parameters:
* [[Grid (TQL Param)]]
* [[Grid with attribute (TQL Param)]]
* [[Gridtype (TQL Param)]]

The result of using 'YK' for the clause value, is the automatic creation of multiple TQL statements, one with each Item ID for that Clause Parameter that can be found in the project data. Items are only taken into account of they contain the attribute specified for the indicated key.

Internally, the resulting TQL statements are placed an array of arrays; Similarly the result will be an array of TQL result arrays.

==Example==
Consider the following (simplified) Building data of a project:
<pre>
[
{ "id" : 0, "name" : "Duiker A", "attributes": { "CULVERT_DIAMETER" : [1.0], "MEASURED_DIAM" : [0.2] } },
{ "id" : 1, "name" : "Kerklaan", "attributes": { "MONUMENTAL_HOUSE" : [1.0] } },
{ "id" : 2, "name" : "Duiker B", "attributes": { "CULVERT_DIAMETER" : [0.5], "MEASURED_DIAM" : [1.0], } },
{ "id" : 3, "name" : "Duiker C", "attributes": { "CULVERT_DIAMETER" : [1.0] } },
{ "id" : 4, "name" : "Duiker K", "attributes": { "CULVERT_DIAMETER" : [2.0], "MEASURED_DIAM" : [0.0] } }
{ "id" : 5, "name" : "Duiker M", "attributes": { "CULVERT_DIAMETER" : [0.0], "MEASURED_DIAM" : [2.0] } },
]
</pre>

And the Grid Overlay in the same project:
<pre>{ "id" : 6, "name" : "Water Overlay", "type" : "RAINFALL" , "keys": { "CULVERT_DIAMETER" : "MEASURED_DIAM" } }</pre>

The TQL statement to obtain the names of the Culverts used by the Water Overlay is:
<pre>SELECT_NAME_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6</pre>
which internally is replaced with a list of TQL statements, separated by comma's,
<pre>SELECT_NAME_WHERE_BUILDING_IS_0_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_2_AND_GRID_IS_6, SELECT_NAME_WHERE_BUILDING_IS_5_AND_GRID_IS_6</pre>
Its result will be a list of names, separated by comma's:
<pre>"Duiker A", "Duiker B", "Duiker M"</pre>
Similarly, the TQL statement to obtain the culvert Diameters of the Culverts used by the water Overlay is:
<pre>SELECT_ATTRIBUTE_WHERE_BUILDING_IS_YK_CULVERT_DIAMETER_AND_GRID_IS_6_AND_KEY_IS_CULVERT_DIAMETER</pre>
Its result will be a list of values, separated by comma's:
<pre>0.2, 1.0, 2.0</pre>

==Clause Parameters==
The YK value can be used in the following TQL Clause parameters:

{{article end
|notes=*In case no Grid is specified by any of the other clauses of the original TQL statement, the result will be 0 generated TQL statements; an empty array.
|seealso=
*[[XK (TQL)]]
*[[Y (TQL)]]
*[[YA (TQL)]]
*[[YC (TQL)]]

}}

{{TQL param nav}}