| 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 |
Item ID,
X, Y, XC, YC
XA, YA, XK or YK |
Address with ID |
false
|
| AREA |
Item ID,
X, Y, XC, YC
XA, YA, XK or YK |
Area with ID |
true
|
| BUILDING |
Item 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 |
Item ID,
X, Y, XC, YC
XA, YA, XK or YK |
Function with ID |
false
|
| INDICATOR |
Item ID,
X, Y, XC, YC
XA, YA, XK or YK |
Indicator with ID |
false
|
| NEIGHBORHOOD |
Item ID,
X, Y, XC, YC
XA, YA, XK or YK |
Neighborhood with ID |
true
|
| NET_FUNCTION |
Item ID,
X, Y, XC, YC
XA, YA, XK or YK |
Net Function with ID |
false
|
| NET_LINE |
Item ID,
X, Y, XC, YC
XA, YA, XK or YK |
Net line with ID |
false
|
| OVERLAY |
Item ID,
X, Y, XC, YC
XA, YA, XK or YK |
Overlay with ID |
false
|
| PANEL |
Item ID,
X, Y, XC, YC
XA, YA, XK or YK |
Panel with ID |
false
|
| STAKEHOLDER |
Item 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 |
Item ID,
X, Y, XC, YC
XA, YA, XK or YK |
Terrain of Terrain Type with ID |
true
|
| ZONE |
Item 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.