Server-Side Conditional Query and Expression Query

Conditional Query

For the backend database table structure, use the SQL WHERE clause for data query. Only the part after where needs to be written.

Table structure:

Field Name	Type	Description
id	integer	id
objectid	text	Entity id (block objectid naming rule: block id_referenced block definition id1_referenced block definition id2 (may have multiple)_entity id; group objectid naming rule: group id$entity id_entity element index; table naming rule: table id@entity id_entity element index; other entity naming rule: id_entity element index)
layerindex	integer	Layer index
name	text	Entity type value, e.g. "1" for AcDbLine. See "Supported CAD Entity Types" below for specific values
color	int	Color (calculated from RGB, e.g. black is 0x000000, with alpha 0xFF000000, becomes unsigned 0xff000000<<0 result -16777216)
data	blob	Geometry data
s1	text	Linetype
s2	text	Extended dictionary data
s3	text	Coordinate data, varies by entity
s4	text	Character attribute data, varies by entity
s5	text	Character attribute data, varies by entity
n1	float	Color index
n2	float	Linetype scale
n3	float	Line width
n4	float	Transparency
n5	float	Numeric attribute data, varies by entity
n6	float	Numeric attribute data, varies by entity
n7	float	Numeric attribute data, varies by entity
n8	float	Numeric attribute data, varies by entity
n9	float	Numeric attribute data, varies by entity
n10	float	Numeric attribute data, varies by entity
geom	GEOMETRY	Entity bounding rectangle

(For detailed field meanings by entity type, see the documentation below)

Built-in Variables for Render Mode Expressions

Variable	Description	Type	Example
gInColor	Current entity input color	(numeric)	4278255615
gInColorRed	Current entity input color (red component)	(numeric)	255
gInColorGreen	Current entity input color (green component)	(numeric)	255
gInColorBlue	Current entity input color (blue component)	(numeric)	0
gInZoom	Current zoom level	(numeric)	1
println	Debug output function
gOutColor	Output color (color to modify)	(numeric)	4278255615

Built-in Variables for Query Mode Style Expressions

Variable	Description	Type	Example
gInLayerIndex	Current entity layer index	(numeric)	0
gInObjectId	Current entity object ID	(string)	'283' e.g. gInObjectId=='283'
gInEntityObjId	Current entity parent object ID	(string)	'1C' e.g. gInEntityObjId=='1C' takes characters before _ in gInObjectId, e.g. for block when gInObjectId=='283_1', then gInEntityObjId= '283'
gInFeatureType	Current entity type	(string)	'AcDbPolyline' e.g. gInFeatureType=='AcDbPolyline'
gInLayerName	Current entity layer name	(string)	e.g. 'Layer1': gInLayerName=='Layer1'
gInColor	Current entity color	(numeric)	4278255615
gInColorRed	Current entity color (red component)	(numeric)	255
gInColorGreen	Current entity color (green component)	(numeric)	255
gInColorBlue	Current entity color (blue component)	(numeric)	0
gInColorAlpha	Current entity color (alpha component)	(numeric)	0
println	Debug output function
gInExtendMinX	Current entity extent (bottom-right X)	(numeric)	700.10
gInExtendMinY	Current entity extent (bottom-right Y)	(numeric)	10.01
gInExtendMaxX	Current entity extent (top-left X)	(numeric)	800.20
gInExtendMaxY	Current entity extent (top-left Y)	(numeric)	20.02
gInAttrs1	Current entity attribute one value	(string) s1 linetype
gInAttrs2	Current entity attribute two value	(string) s2 extended dictionary data
gInAttrs3	Current entity attribute three value	(string) s3 varies by entity
gInAttrs4	Current entity attribute four value	(string) s4 character attribute data, varies by entity
gInAttrs5	Current entity attribute five value	(string) s5 character attribute data, varies by entity
gInAttrn6	Current entity attribute six value	(numeric) n1 color index
gInAttrn7	Current entity attribute seven value	(numeric) n2 linetype scale
gInAttrn8	Current entity attribute eight value	(numeric) n3 line width
gInAttrn9	Current entity attribute nine value	(numeric) n4 transparency
gInAttrn10	Current entity attribute ten value	(numeric) n5 numeric attribute data, varies by entity
gInAttrn11	Current entity attribute 11 value	(numeric) n6 varies by entity
gInAttrn12	Current entity attribute 12 value	(numeric) n7 varies by entity
gInAttrn13	Current entity attribute 13 value	(numeric) n8 varies by entity
gInAttrn14	Current entity attribute 14 value	(numeric) n9 varies by entity
gInAttrn15	Current entity attribute 15 value	(numeric) n10 varies by entity
gInCoordX	Current entity X coordinate array	(numeric array)	[10,20...] gInCoordX[0]=10
gInCoordY	Current entity Y coordinate array	(numeric array)	[10,20...] gInCoordY[0]=10
gInCoordZ	Current entity Z coordinate array	(numeric array)	[10,20...] gInCoordZ[0]=10
gInCoordCount	Current entity coordinate count	(numeric)	2
gOutColorRed	Return color (red component) (modify current entity color)	(numeric)	255, e.g. gOutColorRed := 255; means all levels red component 255; can also be array, e.g. gOutColorRed[0] := 122;gOutColorRed[5] := 200; means levels 1-4 red 122, level 5+ red 200
gOutColorGreen	Return color (green component) (modify current entity color)	(numeric)	255, same usage as above
gOutColorBlue	Return color (blue component) (modify current entity color)	(numeric)	255, same usage as above
gOutColorAlpha	Return color (alpha component) (modify current entity color)	(numeric)	255, same usage as above
gOutLineWidth	Return line width value (modify current entity line width)	(numeric)	3, same usage as above
gOutVisible	Return visibility (modify current entity visibility)	(numeric)	1 or 0, same usage as above
gOutReturn	0 exclude from selection set; 1 include in selection set

Query Data Expression

Same as above

Supported CAD Entity Types

Class Name	Description	Type Value
AcDbLine	Line	1
AcDbPolyline	Polyline	2
AcDb2dPolyline	2D polyline	3
AcDb3dPolyline	3D polyline	4
AcDbSpline	Spline	5
AcDbArc	Arc	6
AcDbCircle	Circle	7
AcDbEllipse	Ellipse	8
AcDbCurve	Curve	9
AcDbBlockReference	Block reference	10
AcDbHatch	Hatch	11
AcDbMText	Multiline text	12
AcDbText	Single-line text	13
AcDbShape	Shape entity	14
AcDbRasterImage	Raster image	15
AcDbWipeout	Wipeout entity	16
AcDb2LineAngularDimension	Angular dimension [two lines]	17
AcDb3PointAngularDimension	Angular dimension [three points]	18
AcDbAlignedDimension	Aligned dimension	19
AcDbArcDimension	Arc dimension	20
AcDbDiametricDimension	Diameter dimension	21
AcDbOrdinateDimension	Ordinate dimension	22
AcDbRadialDimension	Radius dimension	23
AcDbRadialDimensionLarge	Radius polyline dimension	24
AcDbRotatedDimension	Rotated dimension	25
AcDbAttributeDefinition	Attribute definition	26
AcDbAttribute	Block attribute	27
AcDbTable	Table	28
AcDbMLeader	Leader dimension	29
AcDbRegion	Region	30
AcDbPolyFaceMesh	Polyface mesh entity	31
AcDbPolygonMesh	Polygon mesh	32
AcDbSurface	Surface	33
AcDb3dSolid	3D solid	34
AcDbFace	3D face	35
AcDbSolid	Solid entity	36

Query Return Fields

Field Name	Description
objectid	Entity unique id, unchanged after map update
layerindex	Layer index
name	Entity type
geojson	Coordinates in WKT Mercator format
envelop	Bounding rectangle (WKT Mercator format)
bounds	Bounding rectangle (CAD coordinates) ([minx,miny,maxx, maxy])
isEnvelop	Whether query uses actual extent or bounding box (for point selection with many points, returns by extent)
color	Entity color
linetype	Linetype
linetypeScale	Linetype scale
lineWidth	Line width
alpha	Transparency
xdata	Extended data
points	Coordinate sequence
indices	Point index sequence
thickness	Thickness
area	Area
isclosed	Whether closed
polyType	Polyline type
center	Circle center point
radius	Circle radius
startAngle	Arc start angle
endAngle	Arc end angle
rotate	Rotation angle
positon	Position
normal	Normal vector
elevation	Elevation
length	Length
location	Location
contents	Text content (multiline text includes style content)
height	Text height
width	Text width
textHeight	Text height
text	Text content
actualHeight	Multiline text actual height
actualWidth	Multiline text actual width
bulge	Bulge
origin	Origin
u	u in uv
v	v in uv
size	Size
isFit	Whether fitted
fitTol	Fit tolerance
degree	Degree
horzMode	Horizontal alignment mode
majorAxis	Axis
data3d	3D entity material property data

Field Meanings by Entity Type

s1 linetype (string); s2 extended dictionary data (string);

n1 color index; n2 linetype scale; n3 line width; n4 transparency;

Class Name	Class Description	Type Value	s3(string)	s4(string)	s5(string)	n5	n6	n7	n8	n9	n10
AcDbLine	Line	1	points			thickness	length
AcDbPolyline	Polyline	2	points	bulge	data3d	area	isclosed	linetypeScale	thickness	elevation
AcDb2dPolyline	2D polyline	3	points			area	isclosed	polyType	thickness	elevation
AcDb3dPolyline	3D polyline	4	points			area	isclosed	polyType
AcDbSpline	Spline	5	points			area	isclosed	isFit	fitTol	degree
AcDbArc	Arc	6	center			area	isclosed	radius	startAngle	endAngle	thickness
AcDbCircle	Circle	7	center			area	isclosed	radius	thickness
AcDbEllipse	Ellipse	8	center	majorAxis		area	isclosed	radius	startAngle	endAngle
AcDbCurve	Curve	9				area	isclosed
AcDbBlockReference	Block reference	10	positon	attributeDef	blockname	rotate	scaleX	scaleY	scaleZ
AcDbHatch	Hatch	11	points	patternName		elevation	patternAngle	patternScale
AcDbMText	Multiline text	12	location	contents	text	height	width	rotate	textHeight	actualHeight	actualWidth
AcDbText	Single-line text	13	location	text		height	rotate	horzMode
AcDbShape	Shape entity	14	positon	normal		rotate	size
AcDbRasterImage	Raster image	15	origin
AcDbWipeout	Wipeout entity	16
AcDb2LineAngularDimension	Angular dim [two lines]	17
AcDb3PointAngularDimension	Angular dim [three points]	18
AcDbAlignedDimension	Aligned dimension	19
AcDbArcDimension	Arc dimension	20
AcDbDiametricDimension	Diameter dimension	21
AcDbOrdinateDimension	Ordinate dimension	22
AcDbRadialDimension	Radius dimension	23
AcDbRadialDimensionLarge	Radius polyline dim	24
AcDbRotatedDimension	Rotated dimension	25
AcDbAttributeDefinition	Attribute definition	26	location	text	contents	height	rotate	horzMode
AcDbAttribute	Block attribute	27	location	text	contents	height	rotate	horzMode
AcDbTable	Table	28	positon	attributeDef	contents	rotate	scaleX	scaleY	scaleZ
AcDbMLeader	Leader dimension	29	location	contents	text	height	width	rotate	textHeight	actualHeight	actualWidth
AcDbRegion	Region	30	points	indices	data3d	area	perimeter
AcDbPolyFaceMesh	Polyface mesh	31	points	indices	data3d
AcDbPolygonMesh	Polygon mesh	32	points	indices	data3d
AcDbSurface	Surface	33	points	indices	data3d
AcDb3dSolid	3D solid	34	points	indices	data3d
AcDbFace	3D face	35	points	indices	data3d
AcDbSolid	Solid entity	36	points			thickness	length	isclosed

Built-in Style Functions

// gRed(inColor) get red component
	function_t(
				"gRed",
				"var color := inColor % 256					;				"
				"color															",
				"inColor");

	// gGreen(inColor) get green component
	function_t(
				"gGreen",
				"var color := inColor% (256 * 256) / 256;				       "
				"color															",
				"inColor");

	// gBlue(inColor) get blue component
	function_t(
				"gBlue",
				"var color := inColor % (256 * 256 * 256) / 256 / 256	;	   "
				"color															",
				"inColor");

	// gFilterGrey(r, g, b) greyscale filter (average of r,g,b)
	function_t(
				"gFilterGrey",
				"var grey := round(( clrRed +  clrGreen + clrBlue) / 3);"
				"var color := grey + grey * 256 + grey * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterGreyMin(r, g, b) greyscale filter (min of r,g,b)
	function_t(
				"gFilterGreyMin",
				"var grey := round(min(clrRed,clrGreen,clrBlue);"
				"var color := grey + grey * 256 + grey * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterGreyMax(r, g, b) greyscale filter (max of r,g,b)
	function_t(
				"gFilterGreyMax",
				"var grey := round(max(clrRed,clrGreen,clrBlue);"
				"var color := grey + grey * 256 + grey * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterWeight(r, g, b) greyscale filter (weighted average)
	function_t(
				"gFilterWeight",
				"var grey := round(0.3 * clrRed + 0.59 * clrGreen + 0.11 * clrBlue);"
				"var color := grey + grey * 256 + grey * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterBlackWhite(r, g, b) black & white filter
	function_t(
				"gFilterBlackWhite",
				"var grey := round(( clrRed +  clrGreen + clrBlue) / 3);        "
				"var color := if(grey >= 100, 16777215, 0);				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterOpposite(r, g, b) invert filter
	function_t(
				"gFilterOpposite",
				"var red := round(255 - clrRed);"
				"var green := round(255 - clrGreen);"
				"var blue := round(255 - clrBlue);"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterMaxAvg(r, g, b) desaturate: average of max(r,g,b) values
	function_t(
				"gFilterMaxAvg",
				"var grey := round((max(clrRed,clrGreen,clrBlue) + min(clrRed,clrGreen,clrBlue))/2);"
				"var color := grey + grey * 256 + grey * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterRed(r, g, b) red-only filter
	function_t(
				"gFilterRed",
				"var red := clrRed;"
				"var green := 0;"
				"var blue := 0;"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterGreen(r, g, b) green-only filter
	function_t(
				"gFilterGreen",
				"var red := 0;"
				"var green := clrGreen;"
				"var blue := 0;"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterBlue(r, g, b) blue-only filter
	function_t(
				"gFilterBlue",
				"var red := 0;"
				"var green := 0;"
				"var blue := clrBlue;"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterRemoveRed(r, g, b) remove red
	function_t(
				"gFilterRemoveRed",
				"var red := 0;"
				"var green := clrGreen;"
				"var blue := clrBlue;"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterRemoveGreen(r, g, b) remove green
	function_t(
				"gFilterRemoveGreen",
				"var red := clrRed;"
				"var green := 0;"
				"var blue := clrBlue;"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterRemoveBlue(r, g, b) remove blue
	function_t(
				"gFilterRemoveBlue",
				"var red := clrRed;"
				"var green := clrGreen;"
				"var blue := 0;"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterOld(r, g, b) vintage filter
	function_t(
				"gFilterOld",
				"var red := round(0.393 * clrRed + 0.769 * clrGreen + 0.189 * clrBlue);"
				"var green := round(0.349 * clrRed + 0.686 * clrGreen + 0.168 * clrBlue);"
				"var blue := round(0.272 * clrRed + 0.534 * clrGreen + 0.131 * clrBlue);"
				"red := min(red, 255);"
				"green := min(green, 255);"
				"blue := min(blue, 255);"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterFusion(r, g, b) fusion filter
	function_t(
				"gFilterFusion",
				"var red := round(clrRed * 128 / (clrGreen + clrBlue + 1);"
				"var green := round(clrGreen * 128 / (clrRed + clrBlue + 1);"
				"var blue := round(clrBlue * 128 / (clrGreen + clrRed + 1);"
				"red := min(red, 255);"
				"green := min(green, 255);"
				"blue := min(blue, 255);"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterFrozen(r, g, b) frozen filter
	function_t(
				"gFilterFrozen",
				"var red := round((clrRed - clrGreen -clrBlue) * 3 /2);"
				"var green := round((clrGreen - clrRed -clrBlue) * 3 /2);"
				"var blue := round( (clrBlue - clrGreen - clrRed) * 3 /2);"
				"red := min(red, 255);"
				"green := min(green, 255);"
				"blue := min(blue, 255);"
				"red := max(red, 0);"
				"green := max(green, 0);"
				"blue := max(blue, 0);"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterComic(r, g, b) comic filter
	function_t(
				"gFilterComic",
				"var red := round(abs(clrGreen - clrBlue + clrGreen + clrRed) * clrRed / 256);"
				"var green := round(abs(clrBlue -clrGreen + clrBlue + clrRed) * clrRed / 256);"
				"var blue := round(abs(clrBlue -clrGreen + clrBlue + clrRed) * clrGreen / 256);"
				"red := min(red, 255);"
				"green := min(green, 255);"
				"blue := min(blue, 255);"
				"red := max(red, 0);"
				"green := max(green, 0);"
				"blue := max(blue, 0);"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterBrown(r, g, b) sepia filter
	function_t(
				"gFilterBrown",
				"var red := round(clrRed * 0.393 + clrGreen * 0.769 + clrBlue * 0.189);"
				"var green := round(clrRed * 0.349 + clrGreen * 0.686 + clrBlue * 0.168);"
				"var blue := round(clrRed * 0.272 + clrGreen * 0.534 + clrBlue * 0.131);"
				"red := min(red, 255);"
				"green := min(green, 255);"
				"blue := min(blue, 255);"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterBlueTheme(r, g, b) blue theme filter
	function_t(
				"gFilterBlueTheme",
				"var red := round(clrRed * 0.7);"
				"var green := round(clrGreen * 0.7);"
				"var blue := clrBlue;"
				"blue := max(100, blue);"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterRedTheme(r, g, b) red theme filter
	function_t(
				"gFilterRedTheme",
				"var red := clrRed;"
				"var green := round(clrGreen * 0.7);"
				"var blue := round(clrBlue * 0.7);"
				"red := max(100, red);"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterGreenTheme(r, g, b) green theme filter
	function_t(
				"gFilterGreenTheme",
				"var red := round(clrRed * 0.7);"
				"var green := clrGreen;"
				"var blue := round(clrBlue * 0.7);"
				"green := max(100, green);"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue");

	// gFilterCustomTheme(r, g, b, maxr, maxg, maxb) custom theme filter
	function_t(
				"gFilterCustomTheme",
				"var red := if(maxr > 1, max(maxr, clrRed), round(clrRed * maxr);"
				"var green := if(maxg > 1, max(maxg, clrGreen), round(clrGreen * maxg);"
				"var blue := if(maxb > 1, max(maxb, clrBlue), round(clrBlue * maxb);"
				"var color := blue + green * 256 + red * 256 * 256;				"
				"color															",
				"clrRed", "clrGreen", "clrBlue", "maxr", "maxg", "maxb");