MYSQL DB - Select list


I'm trying to get the values from a mysql DB into a select list as possible values. I have created a connector to the database that works. I store the results in a process variable java object = java.util.list called hrcAfdelingen

Now i want to use this list as possible values in my form but i don't know how to get these values. I have tried just putting hrcAfdelingen in the possible values, but that didn't work.

Any suggestions ?

I'm working with bonitasoft BPM 7 community edition


Submitted by Sean McP on Fri, 07/10/2015 - 14:55

have you read the getting started piece for 7? You will need a contract for that piece of data for the form to use it...

Work through the example completely to get a understanding of how it all fits together.

the link is here:

regards Seán

Submitted by big73 on Fri, 07/10/2015 - 15:33

if you see here you'll find this doc but it doesn't tell us exactly how to populate a select widget in Bonita BPM 7.

Submitted by Gunther.dilles_1 on Fri, 07/10/2015 - 17:21

I had already worked tru the getting started tutorial, and al the steps are working. But i cant seem to find where i can connect the result set of my mysql connector to my available values of my select list

Submitted by Gunther.dilles_1 on Sat, 07/11/2015 - 20:38

I found this in the documentation but i can't seem to find an example on how to :

In Bonita BPM 6.x, you could add a connector to a form. This is no longer possible with forms created with the UI designer. To achieve the same result, create a REST API extension.

Has anybody have a example for BPM 7 ?

Submitted by rodrigojcortes on Wed, 09/09/2015 - 19:02

hello someone could work something.
I see that there is little information on this subject.

please help..

Alguien pudo resolver algo.
Veo que existe poca información con este tema.
por favor ayuda

2 answers

This one is the BEST answer!


In your form, you need to add a variable (I will call this variable "MyList") with the type "External API" and the value "../API/bpm/activityVariable/{{taskId}}/XXXX" where you replace XXXX by the name of your list in your process. Then, in your select widget, you set the "Available values" field with "MyList.value" to get the values in your list.


Submitted by Gunther.dilles_1 on Tue, 07/14/2015 - 07:23

Hello yannick,

I've tried it, but nothing happened. I've attatched screenshots. Do you see whats wrong ?

Submitted by Gunther.dilles_1 on Tue, 07/14/2015 - 11:14

I found my problem. If i do the same but not on my initial form, it works perfectly, but in my initial form, i get nothing. Do i have to work with an initial form ? Or can i skip this step ?

Submitted by yannick.lombardi on Wed, 07/15/2015 - 08:54

I never use the initial form. I think it only serves to initialize variables.

Submitted by Gunther.dilles_1 on Wed, 07/15/2015 - 15:06

Thank you, you seem to know much and for i starter like me it is very helpfull so thank you for your help. If i dont want to use the initial step, can i just leave it blank or must i do something to progress the process to the first form ?

Submitted by Sean McP on Wed, 07/15/2015 - 15:49

Hi Gunther,

the first page always comes up in 6 at least (not sure about 7), it just depends on what you want to do with it.

With a process that is started by a human I have a front introductory page that introduces the process, sometimes the user doesn't want to do this one so can cancel out, and there are no-orphaned processes left behind.


Submitted by big73 on Mon, 07/20/2015 - 12:07

Hi all,

My select widget is now populated, and could you to tell me how to set into text variable the item who has been selected by user please ?

Thank you very much

Submitted by rodrigojcortes on Wed, 09/09/2015 - 19:04

Hello yannick,

you have a tutorial where you can help us ?


Hello guys,

I am trying to connect Mysql DBMS with the latest connector and all but its not working. The data is not being saved to database. What kind of issue is this..?


Submitted by Sean McP on Tue, 07/21/2015 - 06:30

Unrelated to the previous question, please move to a new question where you will probably get a quicker answer.