X (TQL): Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
Line 18: Line 18:
Its result will be a list of names, separated by comma's, for example:
Its result will be a list of names, separated by comma's, for example:
<pre>[ "De Manege", "De Lancaster", "De Landstreken", "De Kruidentuin",  "Golfresidentie" ]</pre>
<pre>[ "De Manege", "De Lancaster", "De Landstreken", "De Kruidentuin",  "Golfresidentie" ]</pre>
==Clause Parameters==
The X value can be used in the following TQL Clause parameters:


{{article end
{{article end

Revision as of 13:33, 3 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.

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" ]

Notes

  • The result of an X-queries are array of values without the brackets when the Setting TQL_PANEL_BRACKETED is set to 'false'.

See also

API Endpoints