idea SQL Expression: Typing a period shouldn't autocomplete a word in ArcGIS Pro Ideas

SQL Expression: Typing a period shouldn't autocomplete a word

Bud — Fri, 24 Feb 2023 15:29:58 GMT

In an SQL expression, when typing something like b.asset_id :

When typing the letter b , then typing a period . , the period triggers it to autocomplete the b to BETWEEN .

That's not what I wanted. I wanted to type b.asset_id , not BETWEEN.

Could that behavior be changed?

Thanks.

Re: SQL Expression Autocomplete: Typing a period shouldn't autocomplete a word

Bud — Tue, 05 Dec 2023 19:07:25 GMT

Here's an example of a working subquery (has a correlated subquery with a table alias: b ).

roadinsptable.objectid IN (
     SELECT objectid
       FROM roadinsptable b
      WHERE b.asset_id = roadinsptable.asset_id
   ORDER BY date_ DESC, condition DESC
      LIMIT 1
            )

Source: One-to-first joins: Control what related record is used

Data:

Video of me trying to write b.asset_id, but it auto-completes b. to BEFORE or BETWEEN (depending on the scenario), which isn't what I want.

(view in My Videos)

Re: SQL Expression Autocomplete: Typing a period shouldn't autocomplete a word

Bud — Tue, 05 Dec 2023 19:07:51 GMT

Esri Canada Case #03271348 - SQL Expression: Typing a period or space after a table alias autocompletes to BEFORE or BETWEEN keywords
"After discussing with some colleagues, we decided that an enhancement request is best suited for this:
ENH-000156091: Add the option to disable autocomplete when writing SQL queries in ArcGIS Pro"