idea Application wide setting / option to switch between "Clause" and "SQL" mode for expressions in ArcGIS Pro Ideas

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

MarcoBoeringa — Wed, 06 Feb 2019 10:17:44 GMT

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.

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

MattWilkie1 — Tue, 29 Jun 2021 20:44:53 GMT

yes please!

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

PeggyCorey — Tue, 18 Jul 2023 15:46:59 GMT

Yes, please!!!!

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

PhilipPenn1 — Wed, 16 Aug 2023 17:04:25 GMT

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

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

JuanJoséAlonsoGamo — Thu, 21 Sep 2023 09:53:52 GMT

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

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

MitchellDrennan — Tue, 26 Mar 2024 21:53:53 GMT

Yes please!

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

TS4 — Fri, 07 Jun 2024 03:32:51 GMT

@PhilipPenn1agreed about the extra cumulative clicks. It's certainly not user-friendly to people with serious RSI and other physical issues that have difficulties switching back and forth between mouse and keyboard constantly. Modern GIS obviously requires some degree of mouse usage, but this software seems to have been written by people antagonistic to keyboards.

Re: Application wide setting / option to switch between "Clause" and "SQL" mode for expressions - Status changed to: Under Consideration

TanuHoque — Thu, 11 Jul 2024 21:33:06 GMT

Re: Application wide setting / option to switch between "Clause" and "SQL" mode for expressions - Status changed to: In Product Plan

TanuHoque — Fri, 06 Dec 2024 18:46:14 GMT

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

MarcoBoeringa — Tue, 20 May 2025 20:52:49 GMT

@TanuHoque

Is this really implemented in Pro 3.5, or is this still "In Product Plan" and will be implemented in 3.6, because I do not see such an option to switch between "Clause" and "SQL" mode application wide in Pro 3.5?

I assume it will be available somewhere in the "Project/Options", but in Pro 3.5, there still isn't such a setting as far as I can see it.

Or am I missing something obvious?

Re: Application wide setting / option to switch between "Clause" and "SQL" mode for expressions - Status changed to: Implemented

TanuHoque — Tue, 20 May 2025 21:48:54 GMT

Implemented in ArcGIS Pro 3.5

The option is available in the backstage settings under 'Map and Scene' tab.

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

TanuHoque — Tue, 20 May 2025 21:49:56 GMT

@MarcoBoeringa

yes, it is implemented in 3.5. please check out the option in the backstage settings. I have added a screenshot in my last comment above.

thank you

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

MarcoBoeringa — Wed, 21 May 2025 06:12:48 GMT

@TanuHoque

Thanks, I overlooked the setting, and hadn't really expected it to reside in the "Map and Scene" section of the Options. I expected this somewhere in "General"/"Geoprocessing" or maybe "User Interface".

But at least I am glad to see it implemented!

Now I need to get a horrid bug in Pro 3.4+ fixed that has plagued and totally blocked my workflow ever since the Pro 3.4 upgrade, and forced me to stick to Pro 3.3 to get anything done, so I will unfortunately not be able to take advantage of it anytime soon...