how to display Customer name from the DATABASE(MySql)

Q&A
1

i am new for Bonitasoft… what is the script to get the value of the column from database?

2

You can use a Database Connector to do the database connection and everything, then just use a normal Select statement as you would normally i.e.

select * from Users order by userid

In the output, you have to add a little script the change the rowset to a List of list (rows and columns) which you can then process accordingly under noral java/groovy script.

If you wnat to do a select with a where clause then use

select customername from customers where customerid = ${MyVariable}

regards

3

Actually no script required…

  1. On the Step add a Connector,
  2. choose Others and then MySQL, click next
  3. give it a name, click next
  4. click next
  5. Complete the access information, click next
  6. in the query field add your select statement, click next
  7. if you want list by list you could just select graphical mode n rows by n columns, no scripting at all required in fact, click next
  8. in Select Target just give a variable of type list to take the results

use the variable as data to a table widget and you will see the results on the form.

If you are so new to Bonita see:

Create and Run Your First Process, and
Develop a first business process application

which will help, somewhat

regards

4

thank you,
What script should i Use?
Sorry coz im learning also how to use the script…