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

---

TQL

Select

Active • Attribute • Color • Distance • Expenses • Floorsize • Global • Height • ID • Iteration • Iterations • 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