X (TQL): Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Instead of specifying a clause parameter with a particular [[Item ID]], | Instead of specifying a clause parameter with a particular [[Item ID]], it is possible to use the 'X' character for its value. The result of using 'X' 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. 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) Neighborhood data of a project: | |||
<pre> | |||
[ | |||
{ "id" : 0, "name" : "De Manege" }, | |||
{ "id" : 1, "name" : "De Lancaster" }, | |||
{ "id" : 2, "name" : "De Landstreken" }, | |||
{ "id" : 3, "name" : "De Kruidentuin" }, | |||
{ "id" : 4, "name" : "Golfresidentie" } | |||
] | |||
</pre> | |||
The TQL statement | |||
<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with a list of TQL statements, separated by comma's, | <pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with a list of TQL statements, separated by comma's, | ||
<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_5</pre> | <pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_5</pre> | ||
| Line 12: | Line 24: | ||
{{article end | {{article end | ||
|seealso= | |seealso= | ||
*[[Y (TQL)]] | |||
*[[XA (TQL)]] | *[[XA (TQL)]] | ||
*[[XC (TQL)]] | *[[XC (TQL)]] | ||
*[[XK (TQL)]] | *[[XK (TQL)]] | ||
}} | }} | ||
{{TQL param nav}} | |||
Latest revision as of 12:38, 15 May 2026
Instead of specifying a clause parameter with a particular Item ID, it is possible to use the 'X' character for its value. The result of using 'X' 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. 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) 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_X
is internally replaced with a list of TQL statements, separated by comma's,
SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3, SELECT_NAME_WHERE_NEIGHBORHOOD_IS_5
Its result will be a list of names, separated by comma's, for example:
"Mayfair", "Soho", "Marylebone", "Hyde Park"
Clause Parameters
The X value can be used in the following TQL Clause parameters: