topic Re: Bug in Definition Query dialog of layer properties in Pro 2.0.1? in ArcGIS Pro Questions

Bug in Definition Query dialog of layer properties in Pro 2.0.1?

MarcoBoeringa — Sun, 03 Sep 2017 08:10:05 GMT

Can someone confirm this?

I am running into a major issue where it seems Pro is omitting pairs of single quotes ('') in the display of the Definition Query in layer properties. Look at the attached image, and notice that at the location of the black arrow, no single quotes are visible.

The query clause should look like this (which is valid SQL):

(osm_covered IS NULL OR osm_covered IN ('','no'))

but instead reads like this:

(osm_covered IS NULL OR osm_covered IN (,'no'))

Hence, the query does not evaluate: if I click Verify the SQL expression is valid, the dialog displays an error stating the SQL is invalid. Note that with Clause Mode, I see the same issue, the consecutive single quotes are omitted and don't display in the Clause Mode display of the query.

The issue only seems to be limited to the dialog itself, because if I save the layer to *.lyrx layer file, and examine its contents using a text editor, the SQL Definition Query looks OK. Also, the layer properly displays in the map, which is only possible if internally in the layer object, the SQL is valid:

Re: Bug in Definition Query dialog of layer properties in Pro 2.0.1?

DanPatterson_Retired — Sun, 03 Sep 2017 09:03:01 GMT

escalate to tech support

I presume that you ruled out double-quoting the single quotes? ie (" ' ' ", 'no')

Re: Bug in Definition Query dialog of layer properties in Pro 2.0.1?

MarcoBoeringa — Sun, 03 Sep 2017 09:10:22 GMT

Yes, I just send an e-mail to the support desk of the Dutch branch of ESRI, with a reference to this thread.

I will post again when I get an answer of them. Could well be an already registered bug.

As to your suggestion: double quoting the single quotes is not the same as the clause I need. Double quoting the single quotes will test for the existence of a string with a contents of two consecutive single quotes. My clause should test for an empty string (which is not always the same as NULL in software systems, hence I test for this in the SQL).

Re: Bug in Definition Query dialog of layer properties in Pro 2.0.1?

MarcoBoeringa — Sat, 03 Mar 2018 15:18:33 GMT

This bug is still not fixed in 2.1.2. Can someone of ESRI inc. give an update? Was this ever logged at ESRI inc. as a bug?

It is sometimes difficult to get more information through the local ESRI distributors.

See the difference in the display of the Definition Query in ArcGIS Pro versus ArcMap in attached images:

ArcGIS Pro 2.1.2:

ArcMap 10.6:

Re: Bug in Definition Query dialog of layer properties in Pro 2.0.1?

DanPatterson_Retired — Sat, 03 Mar 2018 18:51:15 GMT

seems wrong, but did you try two double- quotes?