Groovy Script

Groovy Script SQL Connection Bonitasoft

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 […]

CSS Fixed image side bar floating side bar html css HTML

Fixed Floating sidebar using HTML and CSS

By using simple HTML and CSS you will get Fixed Floating Right side bar and you can also make customization to it. Copy the code from the below Textarea box and see <br /> <br /> <html><br /> <head><br /> <br /> <script type=”text/javascript”><br /> function load()<br /> {<br /> document.getElementById(‘abc’).style.right=’25px’;<br /> }<br /> </script><br […]