• {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