数据集里面的replace函数改写

image.png

如图所示,要怎么修改

WITH ORG(

  SELECT

    TRUEUNIT

  FROM

    CT_ORG_SOURCE

    WHERE (1=1)

      ${if(len(orgId) = 0,"","and FSEQ= " + orgId)}

)

select

  t.*

from

(SELECT

  SOURCEUNIT,

PROVINCENAME,

round(sum(nvl(INCOME,0))/10000,2) as LJAMOUNT

FROM

 CT_BI_INCOME

where FYEAR = to_char(sysdate,'yyyy')

${if(len(orgId) = 0,""," and SOURCEUNIT in ('" +  REPLACE(pv5,",","','") + "')")}

GROUP BY 

  SOURCEUNIT,

PROVINCENAME

)t

left join  CT_ORG_SOURCE s on s.TRUEUNIT = t.SOURCEUNIT

order by s.FSEQ

 

FineReport 帆软用户3wVHI1seJv 发布于 2023-4-14 11:41
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共1回答
最佳回答
0
Z4u3z1Lv6专家互助
发布于2023-4-14 11:45

WITH ORG(

  SELECT

    TRUEUNIT

  FROM

    CT_ORG_SOURCE

    WHERE (1=1)

      ${if(len(orgId) = 0,"","and FSEQ= " + orgId)}

)

select

  t.*

from

(SELECT

  SOURCEUNIT,

PROVINCENAME,

round(sum(nvl(INCOME,0))/10000,2) as LJAMOUNT

FROM

 CT_BI_INCOME

where FYEAR = to_char(sysdate,'yyyy')

${if(len(orgId) = 0,""," and SOURCEUNIT in (SELECT TRUEUNIT FROM ORG)")}

GROUP BY 

  SOURCEUNIT,

PROVINCENAME

)t

left join  CT_ORG_SOURCE s on s.TRUEUNIT = t.SOURCEUNIT

order by s.FSEQ

  • 1关注人数
  • 513浏览人数
  • 最后回答于:2023-4-14 11:45
    请选择关闭问题的原因
    确定 取消
    返回顶部