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

02-06-2019 02:17 AM
Status: Open
Labels (1)
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.


yes please!


Yes, please!!!!


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


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