This content has been marked as final.
Show 3 replies
-
1. Re: Can we avoid trimStrings in ORDER BY or use alias instead?
shawkins Dec 8, 2014 12:02 PM (in response to sanjeev.gour)> 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?
-
2. Re: Can we avoid trimStrings in ORDER BY or use alias instead?
sanjeev.gour Dec 9, 2014 9:00 AM (in response to shawkins)Hi Steve-
The translator did not support select expressions, although it could do that. Enabling that solves the issue.
Appreciate your help.
Thanks.
-
3. Re: Can we avoid trimStrings in ORDER BY or use alias instead?
shawkins Dec 9, 2014 9:15 AM (in response to sanjeev.gour)If there is a need for a specific select alias capability, rather than the more general select expression just let us know.