fnc12/sqlite_orm

Invalid order by order

liwei1024 opened this issue · 4 comments

`multi_order_by(
order_by(strftime("%Y-%m-%d",&ClientModel::date)).desc()
...

multi_order_by(
order_by(strsub(&ClientModel::date,0,11)).desc()
...`

I want to implement such a statement
select * from table_name ORDER BY strftime("%Y-%m-%d",date) desc, other desc limit 10
or
select * from table_name ORDER BY substr(date,0,11) desc, other desc limit 10

fnc12 commented

@liwei1024 what are steps to reproduce, what is your actual behavior and what is expected behavior?

fnc12 commented

@liwei1024 are you here?

fnc12 commented

closing due to inactivity