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.

Composition of an Update Query

An Update TQL query provides a means to update an attribute to one or more values for a selection of data of a session. The 'Update' statement is consists of the UPDATE word followed by the context, for example AREA. Next the attribute to update is stated, followed by the word WHERE. Depending on the context, one or more clauses can be added. Clauses are separated with the AND word. All of these parts are separated by an underscore _.

An example of a TQL select statement is: UPDATE_AREA_WATER_LEVEL_M_WHERE_AREA_IS_0. In this example:

• UPDATE is the statement
• AREA is the context
• WATER_LEVEL_M is the attribute
• AREA__IS_0 is the first clause.

This adds or updates the attribute WATER_LEVEL_M for the area with ID 0 to a particular value. The particular value is supplied separately and the way it is supplied depends on the situation in which this statement is executed.

Executing an Update Query

TQL Queries can be executed using:

• Query Tool in the Tygron Platform; For creating and testing TQL queries. Update value can be supplied using the corresponding field.
• Names in Excels; Used for Indicator and Panels and supports more complex queries. The update value is obtained from the Excel cell to which the TQL statement is linked.
• API's query endpoint; Using api/session/query/<TQLQUERY> with an additional parameter for the update value.

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 • 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

Select • Update • Clause