[OCM/WCM] Sql in order_by section.

[WilanPL]

Is it possible to use SQL expressions in the order_by section?
I am asking because I am looking for an idea to sort records by the values of the text field. This field contains such values: 30_60, 60_100, 100_150, 150+.
I will be grateful for any suggestions.

i use Genesys Administrator 8.1.309.02

[cavagnaro]

I have used something like this:


[font=Arial][size=0pt][/size][/font][code]
order by
(select
case column_userdata_2
when 4 then 1
when 1 then 2
when 2 then 3
Else 4
End
)
[/code][font=Arial][size=0pt][/size][/font]