[ABI 5.2] ardb函数在过滤条件中如何使用

14
0

esen_4QBPI1VXAV 初学数据Lv2

发表于2026-2-3 16:12

悬赏30

未解决

楼主

2026-02-03 16:09:30 开始计算报表:Leaded_TFMTBA_MAIN(内存情况:FREE=458.1M TOTAL=1.5G MAX=4.3G)
2026-02-03 16:09:30 执行SQL:
select a.Head from TF_Process a group by a.Head order by a.Head desc
2026-02-03 16:09:30 执行SQL:
select a.HostName from TF_DATAALARM a group by a.HostName order by a.HostName desc
2026-02-03 16:09:30 执行SQL:
select RFIDCode from TF_DataAlarm where RFIDCode is not null GROUP BY RFIDCode ORDER BY RFIDCode desc
com.esen.exception.RuntimeException4I18N: 无法获取宏表达式if(@p=1,"and dim(LEADED_TF_ALARM.Describe) <> '"<#=ardb("select AlarmInfo from TF_AlarmType").join("|")的值:表达式“if(@p=1,"and dim(LEADED_TF_ALARM.Describe) <> '"<#=ardb("select AlarmInfo from TF_AlarmType").join("|")”中缺少日期常量结束符“#”,出错位置:50,请修改表达式后重新计算。
at com.esen.util.exp.impl.ExpZzParser.throwException(ExpZzParser.java:70)
at com.esen.util.exp.impl.ExpZzParser.parseConstDate(ExpZzParser.java:544)
at com.esen.util.exp.impl.ExpZzParser.parseNextToken(ExpZzParser.java:363)
at com.esen.util.exp.impl.ExpZzParser.nextToken(ExpZzParser.java:300)
at com.esen.util.exp.ExpressionCompiler.compile(ExpressionCompiler.java:327)
at com.esen.util.exp.ExpressionCompiler.compile(ExpressionCompiler.java:297)
at com.esen.util.exp.Expression.doCompile(Expression.java:159)
at com.esen.util.exp.Expression.compile(Expression.java:153)
at com.esen.util.exp.Expression.compile(Expression.java:130)
at com.esen.ebibase.rptbase.exp.ExpEvaluateHelper_forCompileAnaObjectBase.getMacroValue(ExpEvaluateHelper_forCompileAnaObjectBase.java:611)
at com.esen.util.macro.impl.MacroResolveImpl.handleASSIGN(MacroResolveImpl.java:327)
at com.esen.util.macro.impl.MacroResolveImpl.traceMacro(MacroResolveImpl.java:204)
at com.esen.util.macro.impl.MacroResolveImpl.parseMacro(MacroResolveImpl.java:162)
at com.esen.util.macro.impl.MacroResolveImpl.resolve(MacroResolveImpl.java:141)
at com.esen.util.exp.ExpressionCompiler.resolveMacro(ExpressionCompiler.java:421)
at com.esen.util.exp.ExpressionCompiler.resolveMacro(ExpressionCompiler.java:363)
at com.esen.util.exp.ExpressionCompiler.compile(ExpressionCompiler.java:310)
at com.esen.util.exp.ExpressionCompiler.compile(ExpressionCompiler.java:297)
at com.esen.util.exp.Expression.doCompile(Expression.java:159)
at com.esen.util.exp.Expression.compile(Expression.java:153)
at com.esen.util.exp.Expression.compile(Expression.java:130)
at com.esen.ebibase.rptbase.analyse.floatfxq.CellAnaInf.compile(CellAnaInf.java:186)
at com.esen.ebibase.rptbase.analyse.floatfxq.CellAnaInf.compile(CellAnaInf.java:175)
at com.esen.ebibase.rptbase.analyse.floatfxq.DimCell.compile(DimCell.java:315)
at com.esen.ebibase.rptbase.analyse.floatfxq.DimCellFloat.compile(DimCellFloat.java:112)
at com.esen.ebibase.rptbase.analyse.floatfxq.FloatFxq.compile(FloatFxq.java:129)
at com.esen.ebibase.rptbase.analyse.floatfxq.FxqRectInFxb.compile(FxqRectInFxb.java:28)
at com.esen.ebibase.rptbase.analyse.floatfxq.RectsInFxb.compile(RectsInFxb.java:105)
at com.esen.ebibase.rptbase.analyse.FormatCal.compile(FormatCal.java:88)
at com.esen.ebibase.rptbase.widget.WidgetAnaGrid.doCompile(WidgetAnaGrid.java:372)
at com.esen.ebibase.rpttpl.widget.WidgetTplGrid.doCompile(WidgetTplGrid.java:96)
at com.esen.ebibase.rptbase.widget.WidgetAnaGrid.compile(WidgetAnaGrid.java:324)
at com.esen.ebibase.rptbase.widget.WidgetAnaGrid.compile(WidgetAnaGrid.java:344)
at com.esen.ebibase.rptbase.widget.WidgetAnaGrid.compile(WidgetAnaGrid.java:297)
at com.esen.ebibase.rptbase.analyse.ReportPageAnalyse.doCompile(ReportPageAnalyse.java:927)
at com.esen.ebibase.rpttpl.analyse.ReportTemplate.doCompile(ReportTemplate.java:111)
at com.esen.ebibase.rptbase.analyse.ReportPageAnalyse.compile(ReportPageAnalyse.java:832)
at com.esen.ebibase.rptbase.analyse.ReportPageAnalyse.compile(ReportPageAnalyse.java:627)
at com.esen.ebibase.rpttpl.calc.ReportCalc_calc_rpttpl.calcAnalyseResult(ReportCalc_calc_rpttpl.java:64)
at com.esen.ebibase.rptbase.calc.impl.ReportCalc_calc_abs.calc_analyseResult(ReportCalc_calc_abs.java:294)
at com.esen.ebibase.rptbase.calc.impl.ReportCalc_calc_abs.calc(ReportCalc_calc_abs.java:122)
at com.esen.ebibase.req.RequestTask_Calc.calc(RequestTask_Calc.java:98)
at com.esen.ebibase.req.RequestTask_Calc.innerRun(RequestTask_Calc.java:66)
at com.esen.ebibase.req.RequestTask_Calc_Abstract.doRun(RequestTask_Calc_Abstract.java:64)
at com.esen.ebibase.req.AbstractRequestTask.call(AbstractRequestTask.java:86)
at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.esen.util.exp.ExpException: 表达式“if(@p=1,"and dim(LEADED_TF_ALARM.Describe) <> '"<#=ardb("select AlarmInfo from TF_AlarmType").join("|")”中缺少日期常量结束符“#”,出错位置:50
... 51 more

最近看过此主题的会员

清香茉莉

0个回答

只看楼主

登录后可回答问题,请登录注册

快速回复 返回顶部 返回列表

小时

全天响应

分钟

快速处理问题

工程师强势助力

明星产品
解决方案
联系合作

400咨询:400-0011-866

技术支持QQ:400-0011-866(工作日9:00-18:00)

产品建议邮箱yixin@esensoft.com

关注我们

扫TA学习更多干货

一对一专家交流

版权所有© 2006-2024 北京亿信华辰软件有限责任公司 京ICP备07017321号 京公网安备11010802016281号