Exception thrown by connect sql
i get the following exception in tracer on using a connect sql :
com.pega.pegarules.pub.clipboard.WrongModeException: The property .COUNT was of mode String while com.pega.pegarules.data.internal.clipboard.ClipboardPropertyStrMinFeatureImpl.getPageValue() was expecting Page mode.
The query used in connect sql is :
select COUNT (pxCommitDateTime) from XX_CPE_SR_LME_OTP
where {.pxCommitDateTime} >= to_date({.CalculationStart},'yyyy-mm-dd hh:mi:ss AM')
Can any body explain this and provide a solution ?
Accepted Solution
BUPA
AU
Hi Anuj,
Pls try with the below query:
select COUNT (pxCommitDateTime) as ".CountOfCases" from XX_CPE_SR_LME_OTP
where {.pxCommitDateTime} >= to_date({.CalculationStart},'yyyy-mm-dd hh:mi:ss AM')
and create a property CountOfCases in the applies to class of the RDB step page or browse page.