Clause (TQL): Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
(Minor text and styling improvements)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
A TQL query statement consists of a command, either [[Select (TQL)|Select]] or Update, and a list of clauses. The clauses provide further specification of the query statement, or a refinement, spatially or property wise.
A [[TQL]] query statement consists of a command, either [[Select (TQL)|Select]] or [[Update (TQL)|Update]], and a list of clauses. The clauses provide further specification of the query statement, or a refinement, spatially or property wise.


A clause consists of a clause parameter and a clause value, where currently the only supported operator between the parameter and value is ''IS''.
A clause consists of a clause parameter and a clause value, where currently the only supported operator between the parameter and value is ''IS''.


====Spatial====
===Spatial===
These parameters can be used to limit the search polygon, that is used to query [[building]]s.
These parameters can be used to limit the search polygon that is used to query [[Building]]s.
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{: Area (TQL Param)}}
{{: Area (TQL Param)}}
Line 24: Line 24:
}}
}}


====Attribute====
===Attribute===
These parameters are related to attributes.
These parameters are related to [[Attribute]]s.
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{: Attribute (TQL Param)}}
{{: Attribute (TQL Param)}}
Line 34: Line 34:
}}
}}


====Grid====
===Grid===
These parameters are specifically related to grids.
These parameters are specifically related to grids.
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{Param TQL|suppresscategory=true|allowselflinks=true|
Line 47: Line 47:
}}
}}


====Item====
===Item===
These parameter can be used to consider only a specific [[item]] of that kind.
These parameter can be used to consider only a specific [[Item]] of that kind.
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{: Address (TQL Param)}}
{{: Address (TQL Param)}}
Line 68: Line 68:
}}
}}


====Net====
===Net===
These parameter are specific to [[network]] related [[item]]s. Some can also be used to limit the selected [[Building]]s.
These parameter are specific to [[Network]] related [[Item]]s. Some can also be used to limit the selected [[Building]]s.
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{: Net line (TQL Param)}}
{{: Net line (TQL Param)}}
Line 78: Line 78:
}}
}}


====Property====
===Property===
These parameters are mostly related to [[building]] properties to filter on, but also include properties related to and shared with other items, such as [[Stakeholder]]s.
These parameters are mostly related to [[Building]] properties to filter on, but also include properties related to and shared with other items, such as [[Stakeholder]]s.
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{Param TQL|suppresscategory=true|allowselflinks=true|
{{: Category (TQL Param)}}
{{: Category (TQL Param)}}

Latest revision as of 07:05, 22 December 2023

A TQL query statement consists of a command, either Select or Update, and a list of clauses. The clauses provide further specification of the query statement, or a refinement, spatially or property wise.

A clause consists of a clause parameter and a clause value, where currently the only supported operator between the parameter and value is IS.

Spatial

These parameters can be used to limit the search polygon that is used to query Buildings.

Param Type Description Limits search polygon
AREA Item ID Area with ID true
AREA_WITH_ATTRIBUTE Attribute Area with non zero Attribute value true
BUFFER decimal Buffer the limiting search polygon with this value. true
GRIDVALUE decimal Only include Grid Overlay cells that have a value equal to the one specified true
LAYERTYPE Layer Only include Buildings and Terrains that are part of this layer true
MAP Map Type Only items present in this Map Type true
MAXGRIDVALUE decimal Only include Grid Overlay cells that have a value smaller than the one specified true
MINGRIDVALUE decimal Only include Grid Overlay cells that have a value larger than or equal to the one specified true
NEIGHBORHOOD Item ID Neighborhood with ID true
NEIGHBORHOOD_WITH_ATTRIBUTE Attribute Neighborhood with non zero Attribute value true
STAKEHOLDER Item ID Stakeholder with ID
Only include Plots that are owned by the stakeholder with this ID
Only include Items that are related to this stakeholder		 true
STAKEHOLDERTYPE Stakeholder Type Stakeholder Type with this value
Only include Plots that are owned by this type of stakeholder		 true
TERRAIN Item ID Terrain of Terrain Type with ID true
TERRAIN_WITH_ATTRIBUTE Attribute Terrain is of Terrain Type with non zero Attribute value true
ZONE Item ID Zone with ID true
ZONE_WITH_ATTRIBUTE Attribute Zone with non zero Attribute value true

Attribute

These parameters are related to Attributes.

Param Type Description Limits search polygon
ATTRIBUTE Attribute The attribute used for Buildings to obtain a value. false
ATTRIBUTE_MAX decimal Only include Buildings that have an attribute value larger than or equal to this value. false
ATTRIBUTE_MAX decimal Only include Buildings that have an attribute value smaller than this value. false
ATTRIBUTE_MULT Attribute Multiply the calculated value with the value of this attribute for a Building false
INDEX positive integer Allows to specify which value in an attribute' s value array to select. false

Grid

These parameters are specifically related to grids.

Param Type Description Limits search polygon
GRID Item ID Grid of Grid Overlay with ID false
GRID_WITH_ATTRIBUTE Attribute Grid of Grid Overlay with non zero Attribute value false
GRIDTYPE Overlay type Grid of Grid Overlay with specified type true
GRIDVALUE decimal Only include Grid Overlay cells that have a value equal to the one specified true
MINGRIDVALUE decimal Only include Grid Overlay cells that have a value larger than or equal to the one specified true
MAXGRIDVALUE decimal Only include Grid Overlay cells that have a value smaller than the one specified true
OVERLAY Item ID Overlay with ID false
TIMEFRAME timeframe Specifies which timeframe to select when processing a particular Grid false

Item

These parameter can be used to consider only a specific Item of that kind.

Param Type Description Limits search polygon
ADDRESS Item ID Address with ID false
AREA Item ID Area with ID true
BUILDING Item ID Building with ID false
FUNCTION Item ID Function with ID false
GLOBAL Item ID Global with ID false
GRID Item ID Grid of Grid Overlay with ID false
INDICATOR Item ID Indicator with ID false
LEVEE Item ID Levee with ID false
MEASURE Item ID Measure with ID false
NEIGHBORHOOD Item ID Neighborhood with ID true
OVERLAY Item ID Overlay with ID false
PANEL Item ID Panel with ID false
RELATION Relation Allows to convert a specific selected item to an other item it is related to. false
STAKEHOLDER Item ID Stakeholder with ID
Only include Plots that are owned by the stakeholder with this ID
Only include Items that are related to this stakeholder		 true
TERRAIN Item ID Terrain of Terrain Type with ID true
ZONE Item ID Zone with ID true

Net

These parameter are specific to Network related Items. Some can also be used to limit the selected Buildings.

Param Type Description Limits search polygon
NET_LINE Item ID Net line with ID false
NET_TYPE Net type Only net items of this net type false
NET_FUNCTION Item ID Net Function with ID false
NET_LOAD Item ID Net Load with ID false
NET_CLUSTER Item ID Net Cluster with ID true

Property

These parameters are mostly related to Building properties to filter on, but also include properties related to and shared with other items, such as Stakeholders.

Param Type Description Limits search polygon
CATEGORY Category Category with this value
Buildings of this category		 false
CATEGORYMULT Item ID Multiply the calculated value with this Category Value of a Building false
FUNCTIONMULT Item ID Multiply the calculated value with this Function Value of a Building false
LAYERTYPE Layer Only include Buildings and Terrains that are part of this layer true
MAP Map Type Only items present in this Map Type true
NAME String Only a specific name false
RESIDENCE boolean When true, consider only Buildings that are residences false
ROAD_SYSTEM boolean When true, consider only Buildings that are part of the road system false
STAKEHOLDERTYPE Stakeholder Type Stakeholder Type with this value
Only include Plots that are owned by this type of stakeholder		 true
STATE Timestate Only include Buildings and Measures that are in this timestate false
TERM Client Word
Server Word		 Client/Server word with name. false
TQL Clause parameters
Spatial
Area • Area with attribute • Buffer • Layertype • Map • Neighborhood • Neighborhood with attribute • Terrain • Terrain with attribute • Zone • Zone with attribute
Attribute
Attribute • Attribute max • Attribute min • Attribute mult • Index
Grid
Grid • Grid with attribute • Gridtype • Gridvalue • Maxgridvalue • Mingridvalue • Overlay • Timeframe
Item
Address • Building • Function • Global • Indicator • Levee • Measure • Panel • Relation • Stakeholder
Net
Net line • Net type • Net function • Net load • Net cluster
Property
Category • Categorymult • Functionmult • Layertype • Map • Name • Residence • Road system • Stakeholdertype • State • Term
Other
Select • Update


Retrieved from "https://support.tygron.com/w/index.php?title=Clause_(TQL)&oldid=56964"