How to sort a character field which contains integer values?

Question

I have a character field named employee's id. In which we enter the employee id's like 102,103,1021,..,because it is a character field it shows like 102,1021,103,.. But i want to display like 102,103,1021,... How can i sort the charcter field.?

Prakash · Answer

The below SQL to Sort character field as int,

select *  from table_name order by cast(employees_id as int) asc

But in python the same code _order = "cast(employees_id as int) asc"  is not support.

Solution to override _generate_order_by method in python,

def _generate_order_by(self, order_spec, query):
my_order = "cast(employees_id as int) asc"
if order_spec:
return super(class_name, self)._generate_order_by(order_spec, query) + ", " + my_order
return " order by " + my_order

Refer the link

Це запитання позначене

Enjoying the discussion? Don't just read, join in!