Have SQL Queries on Layers Obvious

04-19-2016 03:32 PM
Status: Open
New Contributor II
I would love if there was a feature where, say, in the TOC (table of contents) a layer would be bolded, or italicized, or had an * (asterisk) placed beside it to signify that layer had a definition query against it. This would provided a fast way to know if you’re looking at a complete dataset off the bat.

Adding to that, having an “SQL Manager” where you could access the SQL queries in various layers all at once would be very convenient.

This SQL manager would be very powerful (and extra amazing) if you had the option to apply a query against multiple layers at once – rather than having to update each layer with each modified query.
So. Overall it would be awesome to see:
  1. TOC layers with symbology (bold, italic, * etc.) to signify SQL queries are being applied to that layer.
  2. “SQL Manager” to allow easier management of various layers with SQL queries applied against them. Even better, allow the option to apply SQL queries to various layers at once.
Thank you!
1 Comment

This idea is not for common users but a good idea for advanced GIS users. It can be made by differnet font size or font style. I preffer to add this option in Table Of Content Options but I want to add more than only Definition SQL Query. I want to change font in Table Of Content for these types of layers:

  • Layer with Definition Query
  • Event layer
  • Basemap Layer
  • Data from ArcGIS OnLine
  • Layer from XY-data
  • Route event layer
  • Query layer
  • WMS layer
  • Layer with Joins
  • Time layer