Select active (TQL)

Select	Unit	Description	Fixed clause amount	Polygon based
ACTIVE	boolean	Returns whether an Item is active in this Simulation.	1	false

Allowed clause parameters

Param	Value	Description	Limits search polygon
AREA	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Area with ID.	true
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_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
SCENARIO	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Scenario with ID.	false

Examples

• SELECT_ACTIVE_WHERE_AREA_IS_5

Returns whether the Area with Item ID 5 is considered active; I.e. the area has an ACTIVE Attribute that has a value that is larger than 0.

• SELECT_ACTIVE_WHERE_NET_TYPE_IS_ELECTRICITY

Returns whether the Net Setting ELECTRICITY_ACTIVE is considered active; I.e. the setting has a value of true.

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