database connector

How to Execute a Stored Procedure call in Bonita Studio


I'm trying to execute a stored procedure in Bonita Studio. The stored procedure is stored at a mysql database server, so currently I'm using a MYSQL Connector, but if it's unsuitable, I don't mind changing my approach. What I've done:

Get data from another database (not from business data) and do some operations at the start of a process (before instantiation form)


I would like to know if there is a way to get some data from another database, which is not the business data database as well as do some operations, at the very start of a process, before the user is being shown a form.

There are some data that needs to be retrieved before the start of a process and currently we're using a service task right after the start of the process to retrieve the necessary data and do some operations before displaying a page to the user. After the service task, then we have the human task, where the user will be able to input their request.

How to use database connector's command separator


I am trying to use the command separator of the mysql database connector, but I couldn't figure out how to structure the query. Right now, I'm using the script editor with Groovy interpreter, as follows: