YA (TQL) - Revision history

Frank@tygron.nl: /* Example */

2026-05-20T13:13:42Z

Example

← Older revision		Revision as of 13:13, 20 May 2026
Line 20:		Line 20:
	The TQL statement to obtain the names of the monumental Buildings is:		The TQL statement to obtain the names of the monumental Buildings is:
	<pre>SELECT_NAME_WHERE_BUILDING_IS_YA_MONUMENTAL</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_YA_MONUMENTAL</pre>
	which internally is replaced with a list of TQL ~~statements~~, separated by a comma:		which internally is replaced with a list of TQL statement arrays, separated by a comma:
	<pre>[SELECT_NAME_WHERE_BUILDING_IS_1], [SELECT_NAME_WHERE_BUILDING_IS_2], [SELECT_NAME_WHERE_BUILDING_IS_4]</pre>		<pre>[SELECT_NAME_WHERE_BUILDING_IS_1], [SELECT_NAME_WHERE_BUILDING_IS_2], [SELECT_NAME_WHERE_BUILDING_IS_4]</pre>
	Its result will be a list of arrays with names, separated by a comma:		Its result will be a list of arrays with names, separated by a comma:

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

2026-05-19T14:54:10Z

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

	The result of using 'XA' 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 specified attribute.		The result of using 'XA' 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 specified attribute.

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

2026-05-19T12:55:58Z

Clause Parameters

← Older revision		Revision as of 12:55, 19 May 2026
Line 35:		Line 35:
	\|notes=*The following variants on YA exist:		\|notes=*The following variants on YA exist:
	**YCA: A combination between [[YC (TQL)\|YC]] and [[YA (TQL)\|YA]].		**YCA: A combination between [[YC (TQL)\|YC]] and [[YA (TQL)\|YA]].
	**YCK: A combination between [[YC (TQL)\|YC]] and [[YK (TQL)\|YK]].
	\|seealso=		\|seealso=
	*[[XA (TQL)]]		*[[XA (TQL)]]

Frank@tygron.nl at 12:55, 19 May 2026

2026-05-19T12:55:48Z

← Older revision		Revision as of 12:55, 19 May 2026
Line 33:		Line 33:

	{{article end		{{article end
	\|notes=		\|notes=*The following variants on YA exist:
			**YCA: A combination between [[YC (TQL)\|YC]] and [[YA (TQL)\|YA]].
			**YCK: A combination between [[YC (TQL)\|YC]] and [[YK (TQL)\|YK]].
	\|seealso=		\|seealso=
	*[[XA (TQL)]]		*[[XA (TQL)]]

Frank@tygron.nl at 11:48, 19 May 2026

2026-05-19T11:48:59Z

← Older revision		Revision as of 11:48, 19 May 2026
Line 21:		Line 21:
	<pre>SELECT_NAME_WHERE_BUILDING_IS_YA_MONUMENTAL</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_YA_MONUMENTAL</pre>
	which internally is replaced with a list of TQL statements, separated by a comma:		which internally is replaced with a list of TQL statements, separated by a comma:
	<pre>SELECT_NAME_WHERE_BUILDING_IS_1, SELECT_NAME_WHERE_BUILDING_IS_2, SELECT_NAME_WHERE_BUILDING_IS_4</pre>		<pre>[SELECT_NAME_WHERE_BUILDING_IS_1], [SELECT_NAME_WHERE_BUILDING_IS_2], [SELECT_NAME_WHERE_BUILDING_IS_4]</pre>
	Its result will be a list of arrays with names, separated by a comma:		Its result will be a list of arrays with names, separated by a comma:
	<pre>["Kerklaan 40"], ["Achterweg 7"], ["Kerklaan 61"]</pre>		<pre>["Kerklaan 40"], ["Achterweg 7"], ["Kerklaan 61"]</pre>

Frank@tygron.nl at 15:01, 15 May 2026

2026-05-15T15:01:40Z

← Older revision		Revision as of 15:01, 15 May 2026
Line 20:		Line 20:
	The TQL statement to obtain the names of the monumental Buildings is:		The TQL statement to obtain the names of the monumental Buildings is:
	<pre>SELECT_NAME_WHERE_BUILDING_IS_YA_MONUMENTAL</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_YA_MONUMENTAL</pre>
	which internally is replaced with a list of TQL statements, separated by a comma,		which internally is replaced with a list of TQL statements, separated by a comma:
	<pre>SELECT_NAME_WHERE_BUILDING_IS_1, SELECT_NAME_WHERE_BUILDING_IS_2, SELECT_NAME_WHERE_BUILDING_IS_4</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_1, SELECT_NAME_WHERE_BUILDING_IS_2, SELECT_NAME_WHERE_BUILDING_IS_4</pre>
	Its result will be a list of arrays with names, separated by a comma:		Its result will be a list of arrays with names, separated by a comma:

Frank@tygron.nl: /* Example */

2026-05-15T15:01:14Z

Example

← Older revision		Revision as of 15:01, 15 May 2026
Line 22:		Line 22:
	which internally is replaced with a list of TQL statements, separated by a comma,		which internally is replaced with a list of TQL statements, separated by a comma,
	<pre>SELECT_NAME_WHERE_BUILDING_IS_1, SELECT_NAME_WHERE_BUILDING_IS_2, SELECT_NAME_WHERE_BUILDING_IS_4</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_1, SELECT_NAME_WHERE_BUILDING_IS_2, SELECT_NAME_WHERE_BUILDING_IS_4</pre>
	Its result will be a list of names, separated by comma's:		Its result will be a list of arrays with names, separated by a comma:
	<pre>["Kerklaan 40"], ["Achterweg 7"], ["Kerklaan 61"]</pre>		<pre>["Kerklaan 40"], ["Achterweg 7"], ["Kerklaan 61"]</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_YA_MONUMENTAL_AND_NAME_IS_MONUMENTAL</pre>		<pre>SELECT_ATTRIBUTE_WHERE_BUILDING_IS_YA_MONUMENTAL_AND_NAME_IS_MONUMENTAL</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>[1.0], [-3.5], [2.0]</pre>		<pre>[1.0], [-3.5], [2.0]</pre>

Frank@tygron.nl: /* Example */

2026-05-15T14:59:21Z

Example

← Older revision		Revision as of 14:59, 15 May 2026
Line 20:		Line 20:
	The TQL statement to obtain the names of the monumental Buildings is:		The TQL statement to obtain the names of the monumental Buildings is:
	<pre>SELECT_NAME_WHERE_BUILDING_IS_YA_MONUMENTAL</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_YA_MONUMENTAL</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 a comma,
	<pre>SELECT_NAME_WHERE_BUILDING_IS_1, SELECT_NAME_WHERE_BUILDING_IS_2, SELECT_NAME_WHERE_BUILDING_IS_4</pre>		<pre>SELECT_NAME_WHERE_BUILDING_IS_1, SELECT_NAME_WHERE_BUILDING_IS_2, SELECT_NAME_WHERE_BUILDING_IS_4</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:

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

2026-05-15T14:58:57Z

← Older revision		Revision as of 14:58, 15 May 2026
Line 3:		Line 3:
	The result of using 'XA' 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 specified attribute.		The result of using 'XA' 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 specified attribute.

	Internally, the resulting TQL statements are placed in ~~a single~~ array; Similarly the result will be an array of TQL ~~results~~.		Internally, the resulting TQL statements are placed in an array of arrays; Similarly the result will be an array of TQL result arrays.

	==Example==		==Example==

Frank@tygron.nl: Created page with "The 'YA' clause value is a variation on the 'Y' clause value. The characters 'YA' should be followed by an underscore and the name of an Attribute; for example '''YA_MONUMENTAL'''. Also see the example below. The result of using 'XA' 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..."

2026-05-15T14:58:21Z

Created page with "The 'YA' clause value is a variation on the 'Y' clause value. The characters 'YA' should be followed by an underscore and the name of an Attribute; for example '''YA_MONUMENTAL'''. Also see the example below. The result of using 'XA' 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..."

New page

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

The result of using 'XA' 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 specified attribute.

Internally, the resulting TQL statements are placed in a single array; Similarly the result will be an array of TQL results.

==Example==
Consider the following (simplified) Building data of a project:
<pre>
[
{ "id" : 0, "name" : "Lindelaan 3", "attributes": { "MONUMENTAL" : [0.0], "MEASURED_M2" : [200.0] } },
{ "id" : 1, "name" : "Kerklaan 40", "attributes": { "MONUMENTAL" : [1.0] } },
{ "id" : 2, "name" : "Achterweg 7", "attributes": { "MONUMENTAL" : [-3.5] } },
{ "id" : 3, "name" : "Achterweg 9", "attributes": { },
{ "id" : 4, "name" : "Kerklaan 61", "attributes": { "MONUMENTAL" : [2.0]}
{ "id" : 5, "name" : "Duiker 1235", "attributes": { "CULVERT_DIAMETER" : [1.0]},
]
</pre>

The TQL statement to obtain the names of the monumental Buildings is:
<pre>SELECT_NAME_WHERE_BUILDING_IS_YA_MONUMENTAL</pre>
which internally is replaced with a list of TQL statements, separated by comma's,
<pre>SELECT_NAME_WHERE_BUILDING_IS_1, SELECT_NAME_WHERE_BUILDING_IS_2, SELECT_NAME_WHERE_BUILDING_IS_4</pre>
Its result will be a list of names, separated by comma's:
<pre>["Kerklaan 40"], ["Achterweg 7"], ["Kerklaan 61"]</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_YA_MONUMENTAL_AND_NAME_IS_MONUMENTAL</pre>
Its result will be a list of values, separated by comma's:
<pre>[1.0], [-3.5], [2.0]</pre>

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

{{article end
|notes=
|seealso=
*[[XA (TQL)]]
*[[Y (TQL)]]
*[[YK (TQL)]]
*[[YC (TQL)]]

}}

{{TQL param nav}}