Select color (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
45,137 edits
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{{Select TQL|<onlyinclude>
{{Select TQL|<onlyinclude>
{{Select TQL|tabletype=row|attribute=COLOR|unit=[[Color#HEX_format|HEX Color]]|description=Returns the value of the Color of an [[Item]] in HEX format|fixed=1|polygon=false|}}</onlyinclude>
{{Select TQL|tabletype=row|attribute=COLOR|unit=[[Color#HEX_format|HEX Color]]|description=Returns the value of the Color of an [[Item]] in [[Color#HEX format|HEX format]]|fixed=1|polygon=false|}}</onlyinclude>
}}
}}
==Allowed clause parameters==
==Allowed clause parameters==
Line 31: Line 31:
|notes=
|notes=
* [[Function (TQL Param)]] and [[Building (TQL Param)]] return the color of their first [[Category]].
* [[Function (TQL Param)]] and [[Building (TQL Param)]] return the color of their first [[Category]].
|api=* [[Api session query]]
}}
}}
{{TQL nav}}
{{TQL nav}}

Latest revision as of 12:32, 6 July 2026

Select Unit Description Fixed clause amount Polygon based
COLOR HEX Color Returns the value of the Color of an Item in HEX format 1 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
CATEGORY Category,
X, Y, XA, YA		 Category with this value.
Buildings of this Category.		 false
FUNCTION Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Function with ID false
INDICATOR Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Indicator with ID false
NEIGHBORHOOD Integer (Item ID),
ID, X, Y, XC, YC,
XA, YA, XK or YK		 Neighborhood 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
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
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
STAKEHOLDERTYPE Stakeholder Type Stakeholder Type with this value.
Only include Plots that are owned by this type of 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

Examples

  • SELECT_COLOR_WHERE_AREA_IS_5
Returns the HEX Color of the COLOR Attribute of the Area with Item ID 5.
  • SELECT_COLOR_WHERE_STAKEHOLDER_IS_3
Returns the HEX Color of the color parameter of the Stakeholder with Item ID 3.
  • SELECT_COLOR_WHERE_STAKEHOLDERTYPE_IS_MUNICIPALITY
Returns the HEX Color of the default color of the Stakeholder Type MUNICIPALITY.

Notes

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_color_(TQL)&oldid=88905"