I have a problem with configuring database on Bonitasoft. Lately I have trying every steps on Documentation Bonitasoft to connecting database. Then on the input query batch step there is a field that must be filled, if it not done I can’t continue to the next step. And on the next step is for pick between Graphical Mode and Scripting Mode, but because I have filled the field before so it continue to Scripting Mode. And I have no idea with Scripting Mode. Please help me, what do I do with that? thank you.
Hello,
On the input query screen, you will have to provide your query (like select name, lastname from contacts or anything that you need to retrieve).
To handle result of your DB connector in scripting mode, you will need to transform the ResultSet that is fetched to any data format that you want to display. You can find plenty of examples on different topics in the Community, but here is one that might help you get started: http://community.bonitasoft.com/answers/fill-table-widget-values-db
Hope this helps,
Haris