- {date_diff_sort} 为关键字
"order": "{date_diff_sort},sort_id"
- column 为数据库列,通常为创建时间
"field": {
"sort": {
"createTime": {
"column": "create_time",
"dateDiffMinute": 30
}
},
}
- 生成后执行的SQL语句,注意TIMESTAMPDIFF
select null rownum,pin_yin,user_id,null user_name,null sys_id,null role_id,null dep_id,sex,real_name,telephone,id_card,user_status,is_hide_phone,create_time,head_icon,
'00000000000000000' push_name from bo_user
order by (case when TIMESTAMPDIFF(MINUTE,create_time,CURRENT_DATE())<5 then 0 else 1 end),sort_id
limit 1,18;
文档更新时间: 2022-08-20 14:01 作者:admin