Update (TQL)

Update TQL queries allow users to set numerical values for specific item in a session of a project. By adding various clauses to an update statement, the query can be made more specific.

Executing an Update Query

TQL Queries can be executed using:

• Query Tool in the Tygron Platform; For creating and testing TQL queries.
• Globals; Executed every calculation.
• Names in Excels; Used for Indicator and Panels and supports more complex queries.
• EditorBuildingEventType:QUERY using the API

List of Update types

Click on the link of specific Select TQL types to see what you can do with them.

Update	Description	Fixed clause amount	Polygon based
ADDRESS	Update specified attribute with provided values for specific Address	1	false
AREA	Update specified attribute with provided values for specific Area	1	false
BUILDING	Update specified attribute with provided values for a specific Building or all buildings intersecting the query polygons	No	true
GLOBAL	Update specified attribute with provided values for Global with specific name	1	false
INDICATOR	Update specified attribute with provided values for specific Indicator	1	false
NEIGHBORHOOD	Update specified attribute with provided values for specific Neighborhood	1	false
NET_FUNCTION	Update specified attribute with provided values for specific Net Function	1	false
NET_LINE	Update specified attribute with provided values for specific Net Line	1	false
NET_LOAD	Update specified attribute with provided values for specific Net Load	1	false
PANEL	Update specified attribute with provided values for specific Panel	1	false
TERRAIN	Update specified attribute with provided values for specific Terrain Type	1	false
ZONE	Update specified attribute with provided values for specific Zone	1	false

---

TQL

Select

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

• 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