Below is the SQL Connection for a Groovy Script for a SELECT Command in Bonitasoft BPM import groovy.sql.Sql;def host = “localhost”;def user = “bonita”;def pass = “bpm”;def schema = “bonita_journal”;def query = “SELECT * FROM BN_USER where USER_PRO_EMAIL_=’${email_Address__}’ limit 1”;def list=[];sql = providedscripts.BonitaSql.newInstance(“jdbc:mysql://${host}/${schema}”,user, pass, new com.mysql.jdbc.Driver())sql.eachRow(query,{row-> list.add(row.USER_USERNAME_)}); IdentityAPI api = apiAccessor.getIdentityAPI();User userObj = api.findUserByUserName(list[0]);User manager1 […]
Confirm Form Resubmission This webpage requires data that you entered earlier in order to be properly displayed. You can send this data again, but by doing so you will repeat any action this page previously performed. ERR_CACHE_MISS Hide details Reload this webpage Press the reload button to resubmit the data needed to load the page. […]
