X (TQL): Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Instead of specifying a clause parameter with a particular [[Item ID]], this parameter can also be specific with 'X'. The result of placing an X for a parameter, is that a single TQL statement is by mutliple TQL statement, 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 and the result will be an array of TQL results. | Instead of specifying a clause parameter with a particular [[Item ID]], this parameter can also be specific with 'X'. The result of placing an X for a parameter, is that a single TQL statement is by mutliple TQL statement, 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 and the result will be an array of TQL results. | ||
For example, the statement | For example, the TQL statement | ||
<pre>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X</pre> is internally replaced with | <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> | ||
Its result will be | Its result will be a list of names, separated by comma's, for example: | ||
<pre>"Mayfair", "Soho", "Marylebone", "Hyde Park"</pre> | <pre>"Mayfair", "Soho", "Marylebone", "Hyde Park"</pre> | ||
Revision as of 09:24, 15 May 2026
Instead of specifying a clause parameter with a particular Item ID, this parameter can also be specific with 'X'. The result of placing an X for a parameter, is that a single TQL statement is by mutliple TQL statement, 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 and the result will be an array of TQL results.
For example, 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: