-
-
13671698267 数据老手Lv5
发表于2020-12-7 15:40
悬赏1
已解决
其中分公司是二级，人寿/养老等是一级，勾选框组需要展示为分公司然后作为筛选项显示？
这种需求应该怎么处理，需要怎么做的呢？
最近看过此主题的会员
13671698267 发表于 2020-12-16 20:42
ENT03
LEFT(item.id,5)='ENT03'
关贴总结：
用节点过滤的方式可做
LEFT(item.id,5)='ENT03'
<#=if(len(@date1)=0|len(@sln)=0,(ardb("select A2 as A2 from ( select sum(a.M_VALUE) as B2,b.ENT_LV2_CODE as A2,row_number() over ( order by sum(a.M_VALUE) desc nulls last) as A2_sortn from F_F_GRP02_XYWJZ a, F_D_ENTS b where a.D_ENT=b.D_CODE and D_KPI='KPI0227' group by b.ENT_LV2_CODE) a where (A2_sortn<=5)").join("|")), (ardb("select A2 as A2 from ( select sum(a.M_VALUE) as B2,b.ENT_LV2_CODE as A2,row_number() over ( order by sum(a.M_VALUE) desc nulls last) as A2_sortn from F_F_GRP02_XYWJZ a, F_D_ENTS b where a.D_ENT=b.D_CODE and D_KPI='KPI0227' and substr(a.D_YMD,1,6)='"+@date1+"' and a.D_ATT4='"+@sln+"' group by b.ENT_LV2_CODE) a where (A2_sortn<=5)").join("|")))#>
感谢楼主分享
5个回答
本帖最后由 xxxl 于 2020-12-7 16:03 编辑
您是要做选择勾选框里的某个数据，表格根据该数据进行过滤吗？
还是说想要勾选框上的数据会根据一定条件改变展现的数据？
-
13671698267 数据老手Lv5
ENT03
LEFT(item.id,5)='ENT03'
<#=if(len(@date1)=0|len(@sln)=0,(ardb("select A2 as A2 from ( select sum(a.M_VALUE) as B2,b.ENT_LV2_CODE as A2,row_number() over ( order by sum(a.M_VALUE) desc nulls last) as A2_sortn from F_F_GRP02_XYWJZ a, F_D_ENTS b where a.D_ENT=b.D_CODE and D_KPI='KPI0227' group by b.ENT_LV2_CODE) a where (A2_sortn<=5)").join("|")), (ardb("select A2 as A2 from ( select sum(a.M_VALUE) as B2,b.ENT_LV2_CODE as A2,row_number() over ( order by sum(a.M_VALUE) desc nulls last) as A2_sortn from F_F_GRP02_XYWJZ a, F_D_ENTS b where a.D_ENT=b.D_CODE and D_KPI='KPI0227' and substr(a.D_YMD,1,6)='"+@date1+"' and a.D_ATT4='"+@sln+"' group by b.ENT_LV2_CODE) a where (A2_sortn<=5)").join("|")))#>
本帖最后由 xxxl 于 2021-1-6 09:54 编辑
13671698267 发表于 2020-12-16 20:42
ENT03
LEFT(item.id,5)='ENT03'
关贴总结：
用节点过滤的方式可做
LEFT(item.id,5)='ENT03'
<#=if(len(@date1)=0|len(@sln)=0,(ardb("select A2 as A2 from ( select sum(a.M_VALUE) as B2,b.ENT_LV2_CODE as A2,row_number() over ( order by sum(a.M_VALUE) desc nulls last) as A2_sortn from F_F_GRP02_XYWJZ a, F_D_ENTS b where a.D_ENT=b.D_CODE and D_KPI='KPI0227' group by b.ENT_LV2_CODE) a where (A2_sortn<=5)").join("|")), (ardb("select A2 as A2 from ( select sum(a.M_VALUE) as B2,b.ENT_LV2_CODE as A2,row_number() over ( order by sum(a.M_VALUE) desc nulls last) as A2_sortn from F_F_GRP02_XYWJZ a, F_D_ENTS b where a.D_ENT=b.D_CODE and D_KPI='KPI0227' and substr(a.D_YMD,1,6)='"+@date1+"' and a.D_ATT4='"+@sln+"' group by b.ENT_LV2_CODE) a where (A2_sortn<=5)").join("|")))#>
感谢楼主分享
