除了条件属性也可以通过sql拼接参数去控制
drop table if exists test_20221116 ;
create table test_20221116
(start_date TIMESTAMP,end_date TIMESTAMP);
insert into test_20221116
(start_date,end_date)
select now(),date_add(now(),interval 1 HOUR) ;
insert into test_20221116
(start_date,end_date)
select date_add(now(),interval -1 HOUR),date_add(now(),interval 1 HOUR) ;
insert into test_20221116
(start_date,end_date)
select date_add(now(),interval -1 HOUR),now() ;
select tt.start_date,tt.end_date from
(select t.start_date,t.end_date,
case when end_date<now() then '是' else '否' end as is_finish
from test_20221116 t) tt
where tt.is_finish='否' -- 这里拼接控件的参数;