Dropdown list with different displayed / saved values
So, I tried to do a simple list and display it on my form, but I got an error. I can't figure it out.
The script I tried:
import groovy.sql.Sql
def result = []
Sql sql = BonitaSql.newInstance("jdbc:oracle:thin:@MY_IP:1521:DATABASE", "USER", "PASSWORD",new oracle.jdbc.OracleDriver())
sql.eachRow 'select * from TABLE', { result += it.COLUMN }
sql.close()
result
The test runs just fine and returns the values like [test1,test2,test3] but when I try to run the form it doesn't load. I got the error from the bonita's log (posting just the first lines):
Out 30, 2013 9:22:33 AM org.bonitasoft.forms.server.provider.impl.FormServiceProviderImpl resolveExpressions
SEVERE: Error while communicating with the engine.
org.bonitasoft.forms.server.exception.BPMEngineException: Error when evaluating expressions on activity instance 12
at org.bonitasoft.forms.server.accessor.api.ExpressionEvaluatorEngineClient.evaluateExpressionsOnActivityInstance(ExpressionEvaluatorEngineClient.java:44)
Any directions?