View source for XK (TQL)

The XK clause value is a variation on the [[XA (TQL)|XA]]] clause value. The characters 'XK' should be followed by an underscore and the name of a [[Key]]. See the [[#Example|example ]]below. 

This Key is used to obtain the name of an Attribute, given a Grid Overlay. This Grid Overlay is obtained from the same TQL statement, which should contain one of the following clause parameters: 
* [[Grid (TQL Param)]]
* [[Grid with attribute (TQL Param)]] 
* [[Gridtype (TQL Param)]]

The result of using 'XK' 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. Items are only taken into account of they contain the attribute specified for the indicated key.

Internally, the resulting TQL statements are placed in a single array; Similarly the result will be an array of TQL results.



==Example==
Consider the following (simplified) Neighborhood data of a project:
<pre>
[ 
 { "id" : 0, "name" : "De Manege" },
 { "id" : 1, "name" : "De Lancaster" }, 
 { "id" : 2, "name" : "De Lancaster" }, 
 { "id" : 3, "name" : "De Kruidentuin" },
 { "id" : 4, "name" : "Golfresidentie" } 
]
</pre>

The TQL statement 
<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>
Its result will be a list of names, separated by comma's, for example:
<pre>"De Manege", "De Lancaster", "Marylebone", "Hyde Park"</pre>

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

{{article end
|notes=*In case no Grid is specified by any of the other clauses of the original TQL statement, the result will be 0 generated TQL statements; an empty array.
|seealso=
*[[Y (TQL)]]
*[[XA (TQL)]]
*[[XC (TQL)]]
*[[XK (TQL)]]

}}


{{TQL param nav}}