Dynamic Widget visibility based on the DB value

Q&A
1

Hi I am trying to show or hide a text field widget based on a select widget.
Please check the below log error

Caused by: org.bonitasoft.engine.expression.ExpressionEvaluationException: org.bonitasoft.engine.expression.exception.SInvalidExpressionException: Declared return type interface java.util.List is not compatible with evaluated type class java.math.BigDecimal for expression getLeaveBal

2

Hello, what version of Bonita are you using ? Community or Subscription ?

3

Hello,

it seems that your expression getLeaveBal return BigDecimal and the widget seems to want a List.

4

I am using 6.2.2 performance edition.
Actually getLeaveBal is a text which is having contiligence based on empId with a connector. Based on the empId we should be able to print the leave balance. But two different leave balances are available for each employee which is provided through a select widget. Based on chabge of leave type that leave balance should be populate in the getLeaveBal text field.

5

kven,

As rig said, it is a problem related with the return type declared, and the given as result.
In the groovy editor at the bottom you have the return type, can you check it is not a list but a Long?

Cheers

6

Yes I have check that return type. I gave same datatype in grrovy editor as well as the valiable i need to store.
But still it is giving the same error. In mysql db the coulumn type is “leaveBal decimal(10,0)”. I gave the rethrn type as double in connector.

7

Can you add a screenshoot of data setup and the groovy script?

Thx