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.