写成参数,然后BI仪表板参数。将需要的特定的分钟的参数传入SQL即可。
下面是我之前用过的类似的传小时参数的写法(Postgresql)。思路差不多,供参考
where 0=0
${if(len(avi_yield_starttime) = 0,""," and startdate >= cast('" +avi_yield_starttime + "' as date)+ INTERVAL '"+avi_yield_start_hour+" HOUR'")}
${if(len(avi_yield_endtime) = 0,""," and startdate <= cast('" +avi_yield_endtime + "' as date)+ INTERVAL '"+avi_yield_end_hour+" HOUR'")}