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 […]
The maximum value for decimal(5,3) is 99.999, it means 5 digits with 3 digits after decimal, and whenever you try to insert or update more than 99.999 value it is automatically capped to 9.99 in mysql. This Try decimal(5, 2) Decimal(5,3) is used for financial values or less than 100% values. If you want to […]
Below are the list of PHP predefined Magic Constants PHP Magic Constants Name Description __LINE__ The current line number of the file. __FILE__ The full path and filename of the file with symlinks resolved. If used inside an include, the name of the included file is returned. __DIR__ The directory of the file. If used […]
