Select attribute (TQL)

Select	Unit	Description	Fixed clause amount	Polygon based
ATTRIBUTE	decimal	Returns the Attribute value of an Item found in the first valid clause parameter.	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
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
INDEX	positive integer, X, Y, XA, YA	Allows to specify which value in an Attribute' s value array to select.	false
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
KEY	String	Select Attribute based on Overlay Key value.	false
MAP	Map Type, X, Y, XA, YA	Only Items present in this Map Type.	true
MEASURE	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Measure with ID.	false
NAME	String	Select Attribute or Global with specified name.	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
TERRAIN	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Terrain of Terrain Type with ID.	true
TIMEFRAME	timeframe, X, Y, XA, YA	Specifies which Timeframe to select when processing a particular Grid.	false
ZONE	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Zone with ID.	true

Notes

• The name of the attribute should be specified by either:
  • The Name (TQL Param)
  • The Key (TQL Param) in combination with any of the Overlay parameters for specifying the holder of the Key: Grid (TQL Param), Grid with attribute (TQL Param), Gridtype (TQL Param) or Overlay (TQL Param)

API Endpoints

• Api session query

---

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