这里有个坑，数据库是postgre，用liquibase创建视图有问题，现在删除手动创建就没有其他问题

-- 设置120分有问题，720分钟没有问题

问题在中答案中。。。。。。

drop view v_test_user;
create view  v_test_user as  with latest_user_status as 
(
    select current_user_id, max(report_time) max_report_time
    from device_log
    where report_time + interval '120 min' > now() and lat is not null and lng is not null
    group by current_user_id
)
select device_log.current_user_id AS user_id, device_log.report_time, device_log.lat, device_log.lng,  device_log.azimuth_angle, 
device_log.device_status,  base_user.first_name  AS user_name,base_user.phone,base_user.department,base_user.user_type,device_log.device_id
from   latest_user_status
inner join device_log
on         device_log.current_user_id = latest_user_status.current_user_id
and        device_log.report_time = latest_user_status.max_report_time
inner join base_user on latest_user_status.current_user_id = base_user.id;