Modifying existing SQL expression disables definition query

Bud — Wed, 08 Feb 2023 20:15:05 GMT

ArcGIS Pro 3.0.3; mobile geodatabase:

Using a standalone table like this:

ASSET_ID    DATE_           CONDITION
--------    ----------      ---------
1           2016-04-01      1
1           2019-03-01      2
1           2022-01-01      3
2           2016-04-01      4
2           2022-01-01      5
3           2022-01-01      6
3           2022-03-01      7
3           2018-03-01      8
3           2013-03-01      9
3           2010-06-01      10
3           2022-03-01      11
3           2022-03-01      11

And using a non-expression builder definition query like this:

--sql comment
OBJECTID IN (3, 5, 11)

...or like this:

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

Both of those definition queries work as-is and are active.

But after creating those definition queries, if I were to modify the SQL by doing something like add a few spaces to the end, or change a 1 to a 2, then the definition query would get disabled.

For example, if I were to change

--sql comment
OBJECTID IN (3, 5, 11)

--sql comment
OBJECTID IN (3, 5, 12)

then that would disable the definition query. That's not the expected result.

Here's a video example of adding spaces to the end of an SQL expression:

(view in My Videos)

Is that a known issue?

Re: Modifying existing SQL expression disables definition query

Bud — Wed, 08 Feb 2023 20:06:08 GMT

Esri Canada Case #03259723 - ArcGIS Pro: Modifying existing definition query disables the query

Esri inc confirmed that this issue is related to the previous bug [BUG-000155660] so we do not need to make a new one.

topic Re: Modifying existing SQL expression disables definition query in ArcGIS Pro Questions

Modifying existing SQL expression disables definition query

Re: Modifying existing SQL expression disables definition query