Y (TQL): Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Instead of specifying a clause parameter with a particular Item ID, it is possible to use the 'Y' character for its value. Using 'Y' as a clause value automatically creates multiple TQL statements—one for each Item ID associated with that parameter in the project data. Internally, the resulting TQL statements and their results are stored as arrays of arrays. | Instead of specifying a clause parameter with a particular Item ID, it is possible to use the 'Y' character for its value. Using 'Y' as a clause value automatically creates multiple TQL statements—one for each Item ID associated with that parameter in the project data. Internally, the resulting TQL statements and their results are stored as arrays of arrays. | ||
==Clause Parameters== | |||
The Y value can be used in the following TQL Clause parameters: | |||
<div style="column-count:3"> | |||
*[[Address (TQL Param)]] | |||
*[[Area (TQL Param)]] | |||
*[[Building (TQL Param)]] | |||
*[[Category (TQL Param)]] | |||
*[[Function (TQL Param)]] | |||
*[[Global (TQL Param)]] | |||
*[[Grid (TQL Param)]] | |||
*[[Gridtype (TQL Param)]] | |||
*[[Index (TQL Param)]] | |||
*[[Indicator (TQL Param)]] | |||
*[[Layertype (TQL Param)]] | |||
*[[Levee (TQL Param)]] | |||
*[[Map (TQL Param)]] | |||
*[[Measure (TQL Param)]] | |||
*[[Neighborhood (TQL Param)]] | |||
*[[Net line (TQL Param)]] | |||
*[[Net type (TQL Param)]] | |||
*[[Net function (TQL Param)]] | |||
*[[Net load (TQL Param)]] | |||
*[[Net cluster (TQL Param)]] | |||
*[[Overlay (TQL Param)]] | |||
*[[Panel (TQL Param)]] | |||
*[[Stakeholder (TQL Param)]] | |||
*[[Terrain (TQL Param)]] | |||
*[[Timeframe (TQL Param)]] | |||
*[[Zone (TQL Param)]] | |||
</div> | |||
==Example== | ==Example== | ||
| Line 15: | Line 46: | ||
The TQL statement | The TQL statement | ||
<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_Y</pre> is internally replaced with a list of TQL statement arrays, separated by commas, | <pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_Y</pre> is internally replaced with a list of TQL statement arrays, separated by commas, | ||
<pre> [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0 ], [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_1 ], [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2 ], [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3 ] , [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_4 ]</pre> | <pre>[ [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0 ], [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_1 ], [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2 ], [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3 ] , [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_4 ] ]</pre> | ||
Its result will be an array of name arrays, separated by commas, for example: | Its result will be an array of name arrays, separated by commas, for example: | ||
<pre>["De Manege"], ["De Lancaster"], ["De Landstreken"], ["De Kruidentuin"], ["Golfresidentie"]</pre> | <pre>[ ["De Manege"], ["De Lancaster"], ["De Landstreken"], ["De Kruidentuin"], ["Golfresidentie"] ]</pre> | ||
{{article end | {{article end | ||
|notes= | |notes= | ||
|seealso= | |seealso= | ||
*[[X (TQL)]] | *[[X (TQL)]] | ||
| Line 31: | Line 58: | ||
*[[YK (TQL)]] | *[[YK (TQL)]] | ||
*[[ID (TQL)]] | *[[ID (TQL)]] | ||
|api=*[[Api session | *[[Tag#TQL Tags with X and Y Queries|TQL Tags with X and Y Queries]] | ||
|api=*[[Api session query]] | |||
}} | }} | ||
{{TQL param nav}} | {{TQL param nav}} | ||
Latest revision as of 08:35, 12 November 2026
Instead of specifying a clause parameter with a particular Item ID, it is possible to use the 'Y' character for its value. Using 'Y' as a clause value automatically creates multiple TQL statements—one for each Item ID associated with that parameter in the project data. Internally, the resulting TQL statements and their results are stored as arrays of arrays.
Clause Parameters
The Y value can be used in the following TQL Clause parameters:
- Address (TQL Param)
- Area (TQL Param)
- Building (TQL Param)
- Category (TQL Param)
- Function (TQL Param)
- Global (TQL Param)
- Grid (TQL Param)
- Gridtype (TQL Param)
- Index (TQL Param)
- Indicator (TQL Param)
- Layertype (TQL Param)
- Levee (TQL Param)
- Map (TQL Param)
- Measure (TQL Param)
- Neighborhood (TQL Param)
- Net line (TQL Param)
- Net type (TQL Param)
- Net function (TQL Param)
- Net load (TQL Param)
- Net cluster (TQL Param)
- Overlay (TQL Param)
- Panel (TQL Param)
- Stakeholder (TQL Param)
- Terrain (TQL Param)
- Timeframe (TQL Param)
- Zone (TQL Param)
Example
Consider the following (simplified) Neighborhood data of a project:
[
{ "id" : 0, "name" : "De Manege" },
{ "id" : 1, "name" : "De Lancaster" },
{ "id" : 2, "name" : "De Landstreken" },
{ "id" : 3, "name" : "De Kruidentuin" },
{ "id" : 4, "name" : "Golfresidentie" }
]
The TQL statement
SELECT_NAME_WHERE_NEIGHBORHOOD_IS_Y
is internally replaced with a list of TQL statement arrays, separated by commas,
[ [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0 ], [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_1 ], [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2 ], [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3 ] , [ SELECT_NAME_WHERE_NEIGHBORHOOD_IS_4 ] ]
Its result will be an array of name arrays, separated by commas, for example:
[ ["De Manege"], ["De Lancaster"], ["De Landstreken"], ["De Kruidentuin"], ["Golfresidentie"] ]
See also
API Endpoints