> Is there a way by which we can control where trimStrings applies or if we can hint it to use the alias?
The only time we would not be using the alias for an ordering is if it is the ordering is unrelated or if the translator does not support select expressions nor inline views. What capabilities does your translator have?
The translator did not support select expressions, although it could do that. Enabling that solves the issue.
Appreciate your help.
If there is a need for a specific select alias capability, rather than the more general select expression just let us know.