Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: WilanPL on July 03, 2018, 11:38:22 AM

Title: [OCM/WCM] Sql in order_by section.
Post by: WilanPL on July 03, 2018, 11:38:22 AM

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

Title: Re: [OCM/WCM] Sql in order_by section.
Post by: cavagnaro on July 03, 2018, 01:28:57 PM

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]