数据集判断 - 我的帆软

数据集判断

${if(REGEXP_REPLACE("'"+rq+"', '[^周]', '')='周'","SELECT * FROM PC_S_TPJSYSCRSJ WHERE RQ >=(SELECT MIN(rq) FROM PC_SYS_DATE_POSTMARK WHERE zrq='"+rq+"'AND RQ <='+(SELECT MAX(rq) FROM PC_SYS_DATE_POSTMARK WHERE zrq='"+rq+"' ORDER BY rq",

if(REGEXP_REPLACE("'"+rq+"', '[^季]', '')='季'", "SELECT * FROM PC_S_TPJSYSCRSJ WHERE RQ >=(SELECT MIN(rq) FROM PC_SYS_DATE_POSTMARK WHERE jrq='"+rq+"' AND RQ <='(SELECT MAX(rq) FROM PC_SYS_DATE_POSTMARK WHERE jrq='"+rq+"' ORDER BY rq", "SELECT * FROM PC_S_TPJSYSCRSJ WHERE RQ =TO_DATE('"+rq+"','yyyy-MM-dd')"))))}

FineReport jXwn8ONc 发布于 2024-8-10 16:36 （编辑于 2024-8-10 17:47）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共2回答

最佳回答

华莉星宸Lv7高级互助
发布于2024-8-10 17:44（编辑于 2024-8-10 18:24）

试试这个

${if(find("周",rq)>0,"SELECT * FROM PC_S_TPJSYSCRSJ WHERE RQ >=(SELECT MIN(rq) FROM PC_SYS_DATE_POSTMARK WHERE zrq='"+rq+"'AND RQ <=(SELECT MAX(rq) FROM PC_SYS_DATE_POSTMARK WHERE zrq='"+rq+"' ORDER BY rq))",if(find("季",rq)>0,"SELECT * FROM PC_S_TPJSYSCRSJ WHERE RQ >=(SELECT MIN(rq) FROM PC_SYS_DATE_POSTMARK WHERE jrq='"+rq+"' AND RQ <=(SELECT MAX(rq) FROM PC_SYS_DATE_POSTMARK WHERE jrq='"+rq+"' ORDER BY rq))","SELECT * FROM PC_S_TPJSYSCRSJ WHERE RQ =TO_DATE('"+rq+"','yyyy-MM-dd')"))}

举报收起评论(9)

jXwn8ONc(提问者) 也报错了

2024-08-10 17:45

jXwn8ONc(提问者) 是不是不能这么写呀

2024-08-10 17:48

华莉星宸回复 jXwn8ONc(提问者) 理解错了，REGEXP_REPLACE这个不是帆软的函数，不能这么写，你的参数rq格式是什么样的啊？

2024-08-10 17:50

jXwn8ONc(提问者) 回复华莉星宸 xxxx年x季，或者xxxx年xx周，或者2024-08-08,用if加正则判断，不同的参数走不同的sql

2024-08-10 17:54

华莉星宸回复 jXwn8ONc(提问者) 用这个形式的判断，find("周",rq)>0

2024-08-10 18:02

还有4条评论点击查看

很困想睡觉Lv5初级互助
发布于2024-8-10 17:10

${if(REGEXP_REPLACE('"+${rq}+"', '[^周]', '')='周',

"SELECT * FROM PC_S_TPJSYSCRSJ WHERE RQ >='"+(SELECT MIN(rq) FROM PC_SYS_DATE_POSTMARK WHERE zrq='"+${rq}+"')+"' AND RQ <='"+(SELECT MAX(rq) FROM PC_SYS_DATE_POSTMARK WHERE zrq='"+${rq}+"')+"' ORDER BY rq",

if(REGEXP_REPLACE('"+${rq}+"', '[^季]', '')='季',

"SELECT * FROM PC_S_TPJSYSCRSJ WHERE RQ >='"+(SELECT MIN(rq) FROM PC_SYS_DATE_POSTMARK WHERE jrq='"+${rq}+"')+"' AND RQ <='"+(SELECT MAX(rq) FROM PC_SYS_DATE_POSTMARK WHERE jrq='"+${rq}+"')+"' ORDER BY rq",

"SELECT * FROM PC_S_TPJSYSCRSJ WHERE RQ ='"+TO_DATE('"+${rq}+"','yyyy-MM-dd')+"'"

)

)}