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

375
2
12-06-2022 07:51 AM
Status: Open
Labels (1)
Bud
by
Notable Contributor

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 .

Bud_0-1670341706162.png

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

Could that behavior be changed?

Thanks.

 

Related: Optionally disable SQL expression autocomplete

2 Comments
Bud
by

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:

Bud_0-1677007900580.png

 

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.

Bud
by

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"