Y (TQL)

Instead of specifying a clause parameter with a particular Item ID, this parameter can also be specific with 'Y'. The result of placing an Y for a clause parameter's value, is that a single TQL statement is replaced by mutliple unique TQL statements, with each one an Item ID that can be found in the project data, for that Clause Parameter. Internally, the resulting TQL statements are placed in an array of arrays and the result will be an array of TQL result arrays.

For 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:

See also

• XA (TQL)
• XC (TQL)
• XK (TQL)
• Y (TQL)

---

TQL

Select

Active • Attribute • Color • Distance • Expenses • Floorsize • Global • Height • ID • Iteration • Iterations • Gridavg • Gridmin • Gridmax • Gridvolume • Gridstdev • Landpolygons • Landsize • Latitude • Length • Levees • Longitude

• Lotpolygons • Lotsize • Name • Net State • Revenue • Sessionstate • State • Target • Token • Topfloor • Units

Update

Address • Area • Building • Global • Indicator • Neighborhood • Net Function • Net Line • Net Load • Panel • Terrain • Zone

Other

Update • Clause