Select id (TQL)

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
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

• 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