topic Re: Select by Attributes misses records? in ArcGIS Pro Questions

Select by Attributes misses records?

MattWilkie1 — Tue, 29 Jun 2021 20:57:48 GMT

Has anyone had this happen to them? I'm running Select By Attributes on a feature class to select shape area less than 300, but only a fraction of the records are being selected. This screenshot is after the query has been run. I've verified the selection is New Selection and not Reselect from a previous selection. The table is sorted on Shape_Area. It's clear that 20 of 24 visible rows should be selected, but only 13 actually are. I've pressed [refresh table] at bottom right after running the query. I've replicated these bad results several times, but all in this same session (I haven't yet tried closing Pro and trying again).

The table is a polygon feature class in a file geodatabase. ArcGIS Pro 2.8.1.

Re: Select by Attributes misses records?

MattWilkie1 — Wed, 30 Jun 2021 23:31:57 GMT

Wow. This one is subtle. It's not a bug, exactly, but it sure as heck isn't not-a-bug either.

Prior to the state above I had selected a polygon and used the Explode editing tool. Although I had finished with the tool it was not deactivated. There was no visual indication in the attribute table panel that the edit tool was still active and filtering records non-visually.

Said another way: the table panel was still showing me all records, but the allowable set of records that could be operated on were filtered by the still-active Explode tool, which meant that the Select By Attributes tool only saw the subset left exposed by Explode.

The fix was to deactivate the editing tool by using the back button in the tool panel and then use Select by Attributes again.

How did I figure this out?

Later, when I toggled OFF the layer's editability a temporary notification appeared saying "Active Edit tool is filtering the selection. Deactivate tool to restore the selection". At this point I remembered seeing the notification 15 or so minutes earlier when I started editing.

So the bug here if there is one is that the notification is temporary. Or that it shows at the wrong time. Or that the table panel does not have an indicator of the filtered record status. Or all of the proceeding.

See Esri's page on "active tool is filtering the selection" for more info.

Cross posted https://gis.stackexchange.com/questions/402758/arcgis-pro-select-by-attributes-misses-records/

Re: Select by Attributes misses records?

DanPatterson — Tue, 29 Jun 2021 21:02:08 GMT

NIM000986: SelectByAttribute, doesn't work correctly on Shape.A.. (esri.com)

fresh from the bug list

Re: Select by Attributes misses records?

MattWilkie1 — Tue, 29 Jun 2021 22:02:40 GMT

That bug record says it was fixed in v9.2?

Re: Select by Attributes misses records?

Scott_Harris — Fri, 02 Jul 2021 20:18:40 GMT

Hi @MattWilkie1

In the next release of ArcGIS Pro (2.9), you will be able to perform a query (ex. select by attributes) without an active edit tool filtering the selection. Thanks for the feedback!

-Scott

Re: Select by Attributes misses records?

Lebowski — Fri, 10 Sep 2021 17:28:08 GMT

Hi Scott,

What is the actual fix for the error @MattWilkie1 pointed out? I have tried using his recommendation's but that is not fixed my issue. I keep getting the "Active tool is filtering the selection...." message and I am unable to Edit my annotation.

Thanks

Re: Select by Attributes misses records?

Scott_Harris — Fri, 10 Sep 2021 17:41:37 GMT

@Lebowski

Matt was seeing the active edit tool (in his case Explode) was filtering the selection that Select By Attributes was returning. This is because the Explode tool can only select multipart features. He hit the back button in the modify features pane, which deactivated the Explode tool and then he was able to perform the Select By Attributes without the selection being filtered.

I'm not sure what behavior you're seeing. Can you give me some more specific details? perhaps a screenshot?

Thanks,

Scott

Re: Select by Attributes misses records?

Lebowski — Fri, 10 Sep 2021 17:49:57 GMT

Thank you for replying.

So I am trying to move annotation in my layout using the 'Annotation Tool' in the Modify Pane. I set the annotation layer as only selectable layer and then try selecting the annotation I am trying to move but every time I receive attached error and I am unable to modify the Annotation (moving, change font, etc.)

Please help this is extremely frustrating, I have gone through ton of posts, etc. and nothing is solving the problem. I even created a new Pro document and I am still encountering this issue

Re: Select by Attributes misses records?

Lebowski — Fri, 10 Sep 2021 17:51:38 GMT

I am not sure what or how I supposed to be "deactivating"!?! I have used the back arrow in the modify pane and the escape, but neither has worked.

Re: Select by Attributes misses records?

Lebowski — Fri, 10 Sep 2021 17:57:13 GMT

Furthermore, ever tool I select in the Modify Pane is giving me the same error message

Re: Select by Attributes misses records?

Lebowski — Fri, 10 Sep 2021 18:03:19 GMT

Here is a screenshot of my map, no matter what modify tool I run and keeping getting this error. I am running Pro version 2.8.2

Re: Select by Attributes misses records?

Scott_Harris — Fri, 10 Sep 2021 19:01:54 GMT

To close the loop: I spoke with @Lebowski and they had non-editable annotation, but were running the tool to upgrade the annotation (possibly at the same time), which most likely put a schema lock on the database. Therefore none of the data was editable and the modify tools were filtering the non-editable features from the selection.