Select id (TQL): Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
← Older edit
Frank@tygron.nl (talk | contribs)
Tygron, Tygron_admin, Bureaucrats, Interface administrators, Administrators
46,429 edits
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Select TQL|<onlyinclude>
{{Select TQL|<onlyinclude>
{{Select TQL|tabletype=row|attribute=ID|unit=[[Item ID]]|description=Returns the unique ID of an [[Item]] as an Integer|fixed=No|polygon=false|}}</onlyinclude>
{{Select TQL|tabletype=row|attribute=ID|unit=[[Item ID]]|description=Returns the unique ID of an [[Item]] as an Integer.|fixed=No|polygon=false|}}</onlyinclude>
}}
}}
==Allowed clause parameters==
==Allowed clause parameters==
Line 34: Line 34:
{{article end
{{article end
|notes=
|notes=
* This selection query is particular useful when applying [[Template Panel]]s to obtain the Item ID of an [[item]] a particular [[Panel]] is related to.
* This query is particularly useful for obtaining the Item ID of an item associated with a specific [[Panel]].
|api=* [[Api session query]]
}}
}}


{{TQL nav}}
{{TQL nav}}

Latest revision as of 08:12, 15 July 2026

Select Unit Description Fixed clause amount Polygon based
ID Item ID Returns the unique ID of an Item as an Integer. No false

Allowed clause parameters

Param Value Description Limits search polygon
ADDRESS Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Address with ID. false
AREA Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Area with ID. true
BUILDING Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Building with ID. false
FUNCTION Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Function with ID. false
GLOBAL Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Global with ID. false
GRID Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Grid of Grid Overlay with ID. false
GRID_WITH_ATTRIBUTE Attribute Grid of Grid Overlay with non zero Attribute value. false
GRIDTYPE Grid Type,
X, Y, XA, YA		 Grid of Grid Overlay with specified type. true
INDICATOR Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Indicator with ID. false
ITERATION positive integer Query only executes when the current Iteration matches this value. false
LEVEE Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Levee with ID. false
MEASURE Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Measure with ID. false
NEIGHBORHOOD Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Neighborhood with ID. true
NET_CLUSTER Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Net Cluster with ID. true
NET_FUNCTION Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Net Function with ID. false
NET_LINE Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Net Line with ID. false
NET_LOAD Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Net Load with ID. false
NET_TYPE Net type,
X, Y, XA, YA		 Only Net Items of this Net Type. false
OVERLAY Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Overlay with ID. false
PANEL Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Panel with ID. false
RELATION Relation Changes the context of a selected Item to another related Item. false
RESULTTYPE Result type,
X, Y, XA, YA		 Grid of Grid Overlay with specified Result type. true
SCENARIO Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Scenario with ID. false
STAKEHOLDER Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 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 Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Terrain of Terrain Type with ID. true
ZONE Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Zone with ID. true

Notes

  • This query is particularly useful for obtaining the Item ID of an item associated with a specific Panel.

API Endpoints

TQL
Select
Active • Attribute • Color • Distance • Expenses • Floorsize • Global • Gridarea • Gridavg • Gridmin • Gridmax • Gridvolume • Gridstdev • Height • ID • Iteration • Iterations • Landpolygons • Landsize • Latitude • Length • Levees • Longitude
• Lotpolygons • Lotsize • Name • Net State • Revenue • Score • Sessionstate • State • Target • Token • Topfloor • Units
Update
Address • Area • Building • Global • Indicator • Neighborhood • Net Function • Net Line • Net Load • Panel • Terrain • Zone
Other
Select • Update • Clause


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