Causedby:java.lang.IllegalArgumentException:Nopositionalparametersinquery:selectsum(casewhent.expenseDeatailLine.financeauditmoney>0thent.expenseDeatailLine.financeauditmoneyelest.expenseDeatailLine.reimbursementamountend)fromTravelEx

Question

Caused by:java.lang.IllegalArgumentException:No positional parameters in query:
select sum(case when t.expenseDeatailLine.financeauditmoney>0 then t.expenseDeatailLine.financeauditmoney eles t.expenseDeatailLine.reimbursementamount end ) from TravelExpenseVVO t where 1=1 and t.status=3 and t.department = 'BFPID0000000OH0029' and t.projectcode = 'D300/PT3001/移动互联' and t.expenseDeatailLine.reimburseproject = 'BFPID0000000PM0006'

Answer 1

这个应该是查询语句写错了.找不到查询位置了.