MYSQL DB - Select list

Q&A
1

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

1 Like
2

Hi.

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.

http://img15.hostingpics.net/pics/168420externalAPI.png
http://img15.hostingpics.net/pics/516617availableValue.png

3

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…?

4

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: http://documentation.bonitasoft.com/getting-started-tutorial-0

regards
Seán

5

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.

6

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

7

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 ?

8

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

9

Hello yannick,

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

https://drive.google.com/open?id=0BwccGZ67DeQ0a080M1o2bGxzZWM https://drive.google.com/file/d/0BwccGZ67DeQ0ZGtZUkFpc1dQNmc/view?usp=sharing
10

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 ?

11

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

12

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 ?

13

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.

regards

14

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

15

Hello yannick,

you have a tutorial where you can help us ?

16

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

regards