-
Business Object: dates in SQL Query
I have a Business Object to count the number of folders for a process. This works fine: SELECT COUNT(*) AS numFolder FROM efolder WHERE eMapName = 'MyProcess' AND eCreationTime < SysDate But this doesn't work, it fails to generate the variable name: SELECT COUNT(*) AS numFolder FROM efolder WHERE eMapName = 'MyProcess' AND…
-
V9: Parameter driven child admin forms?
I could have sworn this was a new feature introduced in V9 whereby you could assign fields to be passed through to an administration form that was opened from a command button on a form? I can't however find any reference to it? Was I dreaming and am I going back to our JScrip libraries to implement this? Thanks, P
-
Send Email with memo field as "to:" parameter
Hi, I've been trying to use sendEmailActivity function to send email to various users. But whenever i try to put a memo type input as the "to:" parameter, it returns me error below: Failure sending mail. Object reference not set to an instance of an object. Is there any way to do this?
-
Oracle datetime fields
Hi All We are using v9.1 with Oracle 11gR2. When I use Oracle SQL developer to query the Metastorm system tables all the datetime fields are only showing date values e.g. eCreationTime will show 26-JAN-12 but not the time same for eEventTime etc. I'm not sure if this is an issue with SQL Developer as I get the same when I…
-
Deploymnet Errors - How to Locate
I have been working on a workflow process, and after a few hours of work I have attempted to deploy the process to test and the deployment is failing with 27 errors with most of the errors being "; expected" and "Invalid expression term '=' ". In the messages pane, the Component, Identifier, and other columns are all empty…