Query Layers – Indicate number of rows excluded from underlying query at bottom of attribute table

Bud — Mon, 29 Apr 2024 08:06:59 GMT

There are scenarios where query layers silently exclude rows from the underlying SQL query:

IDs aren't unique or have nulls
Features with null shapes
Other?

If Pro is going to automatically exclude rows, it should at least tell us about it. Could a message at the bottom of the attribute table tell us how many rows were excluded? Or if not a count, then warning that some rows were excluded?

The message could be similar to the message that's displayed when a join is one-to-many and so there are duplicate rows in the attribute table.

idea Query Layers – Indicate number of rows excluded from underlying query at bottom of attribute table in ArcGIS Pro Ideas

Query Layers – Indicate number of rows excluded from underlying query at bottom of attribute table