Y (TQL): Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
No edit summary
(One intermediate revision by the same user not shown)
Line 13: Line 13:
{{article end
{{article end
|seealso=
|seealso=
*[[XA (TQL)]]
*[[X (TQL)]]
*[[XC (TQL)]]
*[[YA (TQL)]]
*[[XK (TQL)]]
*[[YC (TQL)]]
*[[Y (TQL)]]
*[[YK (TQL)]]


}}
}}




{{TQL nav}}
{{TQL param nav}}

Revision as of 12:14, 15 May 2026

Instead of specifying a clause parameter with a particular Item ID, it is possible to use the 'Y' character for its value. The result of using 'Y' 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 an array of arrays; Similarly the result will be an array of TQL result arrays.

Example

The TQL statement

SELECT_NAME_WHERE_NEIGHBORHOOD_IS_Y

is internally replaced with a list of TQL statement arrays, 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 Y value can be used in the following TQL Clause parameters: