Status Report Reminder

Discussion created by Markus.Lipps on Aug 30, 2010
Latest reply on Aug 31, 2010 by Chris_Hackett

I want to implement kind of a status report reminder for the project managers and thougt about realizing this with a custom process.
Project Managers have to write their status reports every month. If the due report is not handed in, the manager shall be reminded via email.

So I just wantet to set the process' start condition on something like this:

any ("statusreport", to_char(statusreport.reportyear) concat to_char(statusreport.reportmonth) < select to_char(sysdate, 'YYYYMM') from dual, project.odf_pk, ctx)

but it doesn't work. I don't know where the mistake is and I'm nor sure if such custom expressions are allowed at all.

Can anyone help me?

(It's Clarity 12.05)