Update (TQL): Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 8: | Line 8: | ||
* [[Global]]s; Executed every calculation. | * [[Global]]s; Executed every calculation. | ||
* [[Excel Indicator#Naming Cells|Names in Excel]]s; Used for [[Indicator]] and [[Panel]]s and supports more complex queries. | * [[Excel Indicator#Naming Cells|Names in Excel]]s; Used for [[Indicator]] and [[Panel]]s and supports more complex queries. | ||
* <code> | * [[API]]'s query endpoint; Using <code>api/session/query/<TQLQUERY></code> | ||
===List of Update types=== | ===List of Update types=== | ||
Latest revision as of 10:30, 28 February 2023
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 |