X (TQL): Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 57: Line 57:
*[[XK (TQL)]]
*[[XK (TQL)]]
*[[ID (TQL)]]
*[[ID (TQL)]]
*[[Tag#TQL Tags with X and Y Queries|TQL Tags with X and Y Queries]]
|api=*[[Api session query]]
|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 'X' character for its value. Using 'X' automatically creates a TQL statement for every Item ID associated with that Clause Parameter in the project data. These statements are processed as an array, returning a corresponding array of results.

Clause Parameters

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

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 statement

SELECT_NAME_WHERE_NEIGHBORHOOD_IS_X

is expanded into the following comma-separated list:

[ 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 a list of names, separated by comma's, for example:

[ "De Manege", "De Lancaster", "De Landstreken", "De Kruidentuin",  "Golfresidentie" ]