Application wide setting / option to switch between "Clause" and "SQL" mode for expressions

1469
5
02-06-2019 02:17 AM
Status: Open
Labels (1)
MarcoBoeringa
MVP Regular Contributor

As a new feature in ArcGIS Pro, Pro supports "Clause" mode for SQL expression type parameters in tools and other parts of the interface like the Definition Query of layers, and even defaults to using "Clause" mode.

However, for advanced users with SQL knowledge, that may wish to exclusively use SQL mode, there is no option at all to switch the default from "Clause" to "SQL", meaning the user needs to manually switch each time an expression is displayed in the user interface.

It would be highly desirable to have an application wide setting via the "Options / customize" dialog of Pro to allow users to switch to "SQL" mode exclusively throughout the entire application.

5 Comments
MattWilkie1

yes please!

PeggyCorey

Yes, please!!!!

PhilipPenn1

So many cumulative extra clicks...please, ESRI -- an application-wide "Default to SQL Mode in Select By Attributes Dialog" checkbox. Your users will love you.

Thanks in advance

JuanJoséAlonsoGamo

Is very uncomfortable that in an application made for PROffesionals a clause graphic selector has come as the default option. At least, provided that ArcMap SQL mode is what users are used to, it has not been preserved as customizable.

Please include it, thanks

MitchellDrennan

Yes please!