数据集sql书写问题

数据集获取参数，请教各位大佬，这个sql要如何书写才可以在数据集中获取到框选起来的参数呢？

${if(p1 = "jd","

SELECT

"+ IF(SELECT DISTINCT dome FROM asd WHERE sales = '"+sales+"' = 'gn',"

SUM(

CASE

WHEN '"+aa+"' = '789' THEN 11

WHEN '"+aa+"' = '456' THEN 22

END

) bb

","

SUM(

CASE

WHEN '"+aa+"' = '789' THEN 33

WHEN '"+aa+"' = '456' THEN 44

END

) bb

)+"

FROM

asd

WHERE

dome IN ('"+sales+"')

and year = '"+ year +"'

"," ")}

FineReport CYJXJ 发布于 6 天前

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

snrtuemcLv8专家互助
发布于6 天前

${if(p1 = "jd","

SELECT

"+ IF(sql("数据库连接名","SELECT DISTINCT dome FROM asd WHERE sales = '"+sales+"'",1,1)= 'gn',"

SUM(

CASE

WHEN '"+aa+"' = '789' THEN 11

WHEN '"+aa+"' = '456' THEN 22

END

) bb

","

SUM(

CASE

WHEN '"+aa+"' = '789' THEN 33

WHEN '"+aa+"' = '456' THEN 44

END

) bb

)+"

FROM

asd

WHERE

dome IN ('"+sales+"')

and year = '"+ year +"'

"," ")}

ScyalcireLv7高级互助
发布于6 天前（编辑于 6 天前）

重新试下

${if(p1 = "jd","
SELECT
"+ IF(sql("demo","SELECT DISTINCT dome FROM asd WHERE sales = '"+sales+"'",1,1)= 'gn',"
SUM(
      CASE 
WHEN '"+aa+"' = '789' THEN 11
          WHEN '"+aa+"' = '456' THEN 22
      END
  ) bb
","
  SUM(
      CASE 
          WHEN '"+aa+"' = '789' THEN 33 
          WHEN '"+aa+"' = '456' THEN 44 
      END
  ) bb
"
)+"
FROM
asd
WHERE
dome IN ('"+sales+"')
  and year = '"+ year +"' 
 "," ")}

举报收起评论(7)

CYJXJ(提问者) 您好，需要的是修改这一句" IF(SELECT DISTINCT dome FROM asd WHERE sales = '"+sales+"' = 'gn'"使可以在这一句中"sales"获取到参数，别的不变，数据集预览的时候，可以有三个参数：aa, sales, year三个参数

2025-06-24 08:54