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.

Attribute

These parameters are related to Attributes.

Grid

These parameters are specifically related to grids.

Item

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

Net

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

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.