Support SQL Comments in Display Filter - Vector Tile Publishing

BrettFrahm — Wed, 23 Nov 2022 18:33:11 GMT

I just found out that if you have SQL comments in your display filter query, that display filter will just not work in your published Vector Tiles. I need to be able to add SQL comments to keep it organized when I'm querying for Unique IDs in a road layer. Currently using ArcGIS Pro 2.9.5, will be testing soon with 3.1.

Ex: For my display filter between 144K - 18K I only want to show highways and county roads (which is handled by "ROUTE_SYS"), but there are certain road segments beyond those road categories I need to show that are relevant so I'm using unique IDs from "ROADSEG_ID".

This query works with vector Tiles

ROUTE_SYS IN ('04', '07', '05', '01', '02', '03', '22', '53', '41')
Or

ROADSEG_ID IN ('0805469A-1938-43E9-A18F-05FDFE2E7B4E',
'D6BE7AA6-D7A7-4BDB-87B6-05A045BE47DA',
'00A91117-6B17-4DDE-A0CC-BF097A8D00DA',
'00A91117-6B17-4DDE-A0CC-BF097A8D00DA',
'F0902E65-1277-4542-8E5F-6759E243FFF7',
'E8799B99-27AF-4743-8C56-F392B04B4557',
'1439D56D-BBCA-464D-BA85-3F763C7F2C77',
'32C5DD3A-00F7-4BC5-A0F9-50740DB4A449',
'E8350270-3BCA-4862-9B4C-328B2E9CC7C9',
'C1520FD3-30AD-4F53-99CE-0C0DFD4061CA',
'9D479888-74DC-4970-91BD-03161FA0AF3A',
'87EA2E09-005C-4A18-A81E-3B8F94B90825',
'BB054E48-2451-4C1A-8295-BB1B3AE47BB1',
'EC581F38-5B84-4BF6-A97F-3341B7B47E59',
'8A97A63F-1A5C-428C-87A4-30B0C189C21C')

but this query I use with comments to organize the segments does not work.

ROUTE_SYS IN ('04', '07', '05', '01', '02', '03', '22', '53', '41')
Or
/*Special Cases for PDF Maps*/
ROADSEG_ID IN (/*Parley Lake Rd/Ln*/'0805469A-1938-43E9-A18F-05FDFE2E7B4E',
'D6BE7AA6-D7A7-4BDB-87B6-05A045BE47DA',
'00A91117-6B17-4DDE-A0CC-BF097A8D00DA',
'00A91117-6B17-4DDE-A0CC-BF097A8D00DA',
'F0902E65-1277-4542-8E5F-6759E243FFF7',
/*Steiger Lake Ln*/ 'E8799B99-27AF-4743-8C56-F392B04B4557',
'1439D56D-BBCA-464D-BA85-3F763C7F2C77',
'32C5DD3A-00F7-4BC5-A0F9-50740DB4A449',
'E8350270-3BCA-4862-9B4C-328B2E9CC7C9',
'C1520FD3-30AD-4F53-99CE-0C0DFD4061CA',
'9D479888-74DC-4970-91BD-03161FA0AF3A',
/*Zachary Ln N*/ '87EA2E09-005C-4A18-A81E-3B8F94B90825',
'BB054E48-2451-4C1A-8295-BB1B3AE47BB1',
'EC581F38-5B84-4BF6-A97F-3341B7B47E59',
'8A97A63F-1A5C-428C-87A4-30B0C189C21C')

Everything validates correctly in pro and functions properly there. If published as vector tiles though, the roads for this scale/display filter just don't work. (Left query with comments, right query without comments)

Re: Support SQL Comments in Display Filter - Vector Tile Publishing

BrettFrahm — Wed, 23 Nov 2022 18:50:20 GMT

Also SQL comments appear to not work in Label classes either for published vector tiles.

idea Support SQL Comments in Display Filter - Vector Tile Publishing in ArcGIS Pro Ideas

Support SQL Comments in Display Filter - Vector Tile Publishing

Re: Support SQL Comments in Display Filter - Vector Tile Publishing