HQL to_number()中有子句Select count(*)问题?
Hql:
我的Hql检索条件
" and ( " +
" to_number((select count(*) from RemindTarget as rt where ri.remindInfoId = rt.remindInfo.remindInfoId)) > " +
" to_number(((select count(*) from ReadRemind as readR where ri.remindInfoId = readR.remindEntityId " +
" and readR.remindResourceType.remindResourceTypeId = 1 and readR.closeFlag = 1 )) ) "
转意成Sql:
and to_number()>to_number() and (remindinfo0_.REMIND_INFO_ID
子句没有加载
怎么处理?