Have SQL Queries on Layers Obvious

NellHogan — Tue, 23 Jul 2024 16:22:05 GMT

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:

TOC layers with symbology (bold, italic, * etc.) to signify SQL queries are being applied to that layer.
“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!

Re: Have SQL Queries on Layers Obvious

IngmarAlbinson — Wed, 20 Apr 2016 06:07:27 GMT

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

idea Have SQL Queries on Layers Obvious in ArcGIS Pro Ideas

Have SQL Queries on Layers Obvious

Re: Have SQL Queries on Layers Obvious