AnsweredAssumed Answered

How to sort dynamic text from table attribute?

Question asked by mattias_j on Mar 4, 2019
Latest reply on Mar 5, 2019 by tbole-esristaff

I'm adding street names to a layout by using dynamic text from table attributes. It kind of works, but I want the streets names to be sorted ascending by name. Is that possible? I tried to use a custom SQL expression where I added ORDER BY, the expression is valid but when applying that expression my text disappear. Removing the ORDER BY part brings my text back but obviously not sorted the way I want.

 

A work around could be to permanently reorder all the features in the table by some script, but that's not the solution I'm looking for.

Outcomes