You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT
dp.pro_no,
dp.sname,
faa.sum_allotment_money,
dp.apply_format,
dp.project_type,
dp.bus_manager,
dd1.sname as exe_dept,
dd2.sname as dept_name,
dp.exe_manager,
dp.self_unit,
DATE_FORMAT( dp.allocate_time, '%Y-%m-%d' ) AS allocate_time,
kh.sname AS kh_sname,
cn.sname AS cn_sname,
mk.sname AS mk_sname
FROM
(select project_id,exe_dept_id,bus_dept_id,sum(allotment_money) as sum_allotment_money ,create_date from fact_accountentry_allocation
where is_flag='1' and allocation_type='10162014'
<#if isNotEmpty(select_startTime)>
AND DATE_FORMAT( create_date, '%Y-%m-%d' ) >= '${select_startTime}'
</#if>
<#if isNotEmpty(select_endTime)>
AND DATE_FORMAT( create_date, '%Y-%m-%d' ) <= '${select_endTime}'
</#if>
GROUP BY project_id,exe_dept_id,bus_dept_id ) faa
LEFT JOIN dimzip_project dp on faa.project_id=dp.aid and dp.is_current='1'
LEFT JOIN dimzip_dept dd1 on dd1.aid=faa.exe_dept_id and dd1.start_time <= faa.create_date and dd1.end_time>= faa.create_date
LEFT JOIN dimzip_dept dd2 on dd2.aid=faa.bus_dept_id and dd2.start_time <= faa.create_date and dd2.end_time>= faa.create_date
LEFT JOIN dimzip_tenant kh ON kh.aid = dp.client_id AND kh.start_time <= dp.allocate_time AND kh.end_time >= dp.allocate_time
LEFT JOIN dimzip_channel cn ON cn.aid = dp.channel_id AND cn.start_time <= dp.allocate_time AND cn.end_time >= dp.allocate_time
LEFT JOIN dimzip_market mk ON mk.aid = dp.market_id AND mk.start_time <= dp.allocate_time AND mk.end_time >= dp.allocate_time
版本号:
1.6.6
问题描述:
同时设置了报表参数查询和报表字段中的查询,报表字段的下拉多选未生效
错误日志&截图:
重现步骤:
SELECT
dp.pro_no,
dp.sname,
faa.sum_allotment_money,
dp.apply_format,
dp.project_type,
dp.bus_manager,
dd1.sname as exe_dept,
dd2.sname as dept_name,
dp.exe_manager,
dp.self_unit,
DATE_FORMAT( dp.allocate_time, '%Y-%m-%d' ) AS allocate_time,
kh.sname AS kh_sname,
cn.sname AS cn_sname,
mk.sname AS mk_sname
FROM
(select project_id,exe_dept_id,bus_dept_id,sum(allotment_money) as sum_allotment_money ,create_date from fact_accountentry_allocation
where is_flag='1' and allocation_type='10162014'
<#if isNotEmpty(select_startTime)>
AND DATE_FORMAT( create_date, '%Y-%m-%d' ) >= '${select_startTime}'
</#if>
<#if isNotEmpty(select_endTime)>
AND DATE_FORMAT( create_date, '%Y-%m-%d' ) <= '${select_endTime}'
</#if>
GROUP BY project_id,exe_dept_id,bus_dept_id ) faa
ORDER BY dp.allocate_time desc
友情提示(为了提高issue处理效率):
The text was updated successfully, but these errors were encountered: