I have created a query rule which takes a date and text. I am calling it using =

karls over 10 years ago

I have created a query rule which takes a date and text. I am calling it using =rule!FR_getCommunicateScheduleForNotifyDate(today(),"RSD"). I get the following error

Expression evaluation error in rule 'fr_getcommunicateschedulefornotifydate' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [FRRATESCOMMUNICATESCHEDULEDT1441], query: [FR_getCommunicateScheduleForNotifyDate], order by: [[]], filters:[(('EMAIL_NOTIFY_DATE' = TypedValue[it=7,v=2014-08-05]) AND ('COMPANY_CODE' = TypedValue[it=3,v=RSD]))])

How can I pass a date to the query rule for evaluation ...

Discussion posts and replies are publicly visible

Parents

0 karls over 10 years ago

Thanks I see this in the logs. ORA-00904: I will check the column names
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 karls over 10 years ago

Thanks I see this in the logs. ORA-00904: I will check the column names
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data