X (TQL)

From Tygron Support wiki
Revision as of 09:22, 15 May 2026 by Frank@tygron.nl (talk | contribs) (Created page with "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 <pre>SELECT_NAME_W...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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

SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X

is internally replaced with

SELECT_NAME_WHERE_NEIGHBORHOOD_IS_0<br>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_2<br>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_3<br>SELECT_NAME_WHERE_NEIGHBORHOOD_IS_5

Its result will be an list of name, seperated by comma's, for example:

"Mayfair", "Soho", "Marylebone", "Hyde Park"

Clause Parameters

The X value can be used in the following TQL Clause parameters: