Select to view content in your preferred language

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

229
0
04-29-2024 01:06 AM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

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

  1. IDs aren't unique or have nulls
  2. Features with null shapes
  3. 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.