Update (TQL): Difference between revisions
Jump to navigation
Jump to search
(Created page with "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 {{software}}; For creating and testing TQL queries. * Globals; Executed every calculation. * Names in Excels;...") |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| 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=== | ||
Click on the link of specific Select TQL types to see what you can do with them. | Click on the link of specific Select TQL types to see what you can do with them. | ||
{{Update TQL|suppresscategory=true|allowselflinks=true|list=true| | {{Update TQL|suppresscategory=true|allowselflinks=true|list=true| | ||
{{: Update address attribute (TQL)}} | |||
{{: Update area attribute (TQL)}} | |||
{{: Update building attribute (TQL)}} | |||
{{: Update global attribute (TQL)}} | |||
{{: Update indicator attribute (TQL)}} | |||
{{: Update neighborhood attribute (TQL)}} | |||
{{: Update net function attribute (TQL)}} | |||
{{: Update net line attribute (TQL)}} | |||
{{: Update net load attribute (TQL)}} | |||
{{: Update panel attribute (TQL)}} | |||
{{: Update terrain attribute (TQL)}} | |||
{{: Update zone attribute (TQL)}} | |||
}} | }} | ||
{{TQL nav}} | {{TQL nav}} | ||
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 |