Update (TQL)
Revision as of 10:30, 28 February 2023 by Frank@tygron.nl (talk | contribs)
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
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.
- API's query endpoint; Using
api/session/query/<TQLQUERY>
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 |