如何替换现有工龄表单为司龄

【适用版本】8.8

【解决方案】

数据集路径:用户账号/administrator账号:开发平台-数据集配置

新增数据集配置,选择自定义sql

select a.fjoincompanyyears as 司龄,a.FPERSONID as 人员, c.fname_l2 as 行政组织,c.fid as 行政组织编码,(case when (a.fjoincompanyyears >0 and a.fjoincompanyyears<=1) then '0~1' when (a.fjoincompanyyears >1 and a.fjoincompanyyears<=3) then '1~3' when (a.fjoincompanyyears >3 and a.fjoincompanyyears<=5) then '3~5' when (a.fjoincompanyyears >5 and a.fjoincompanyyears<=10) then '5~10' when (a.fjoincompanyyears >10 and a.fjoincompanyyears<=20) then '10~20'else '20以上' end) as 范围,(case when (a.fjoincompanyyears >0 and a.fjoincompanyyears<=1) then '1' when (a.fjoincompanyyears >1 and a.fjoincompanyyears<=3) then '2' when (a.fjoincompanyyears >3 and a.fjoincompanyyears<=