select

Hello guys !

I want to select a list of users in a form and store them in the database.

In my project the user wants to select some projects (create a video / create a website / create a poster / ....), Each "project" has his own object in Database. For each project the user should be able to select a list of user who will be in charge of the project.

I´m trying to create a form where the user can select the number of the house and room that is renting.
but I don't know where can I add the houses to display that information clicking on the bar.
Please tell me where should I add those alternatives to display them as options.

Example:
houses:
* house 1
* house 2
* house 3

Regards.

.

Preciso exibir as informações de um arrayList no UI Designer, porém estou começando a utilizar a ferramenta Bonitasoft agora, como posso exibir essas informações? Fiz um select no banco para salvar as informações no arrayList.

Hi,

I have a process variable which has a list; the list is created by a "connector in".

I need to retrieve the list in a Select widget, but it seems that I can NOT get the process variable data from the first form (instantiation form)...

It does work with other activities. I can get to show the list in the Select widget in other activities, but it does not work with the instantiation form.

Do you know how to handle this?

Thanks a lot.

Hi,

I try to fill a select list with the content of the database field (id)
So I can fill the select list with the id's of my database but when I try to send the value to an another form I can't.

I have on the component an error of type field.

My code:
1) I create a Pool variable : listofId (java.util.List)
2) I create a connexion in
2.1) I edit expressions with that code :
def script = ""
script ="SELECT Id FROM demo"

La idea es que en un select de una formulario pueda seleccionar el usuario que le deseo asignar la tarea, muchas gracias por la ayuda.

I've created a simple process using the standard, out-of-the box JDBC MySQL connector. I entered a simple SELECT statement in the connector, and I get the following error:

org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.sql.BatchUpdateException: Can not issue SELECT via executeUpdate().

Strangely, any INSERT statements work just fine.

[My environment: Bonita BPM 6.2 (Community Edition) / Windows XP / MySQL database]

Hello,

I’m a beginner in the BPM/Java/Groovy world and, although I’ve been able to do things like insertions and updates to a MySQL database from Bonita using forms and connectors, I have yet to find a clear, step-by-step method to do a Select query based on a value entered in a form by a user and fill out the rest of the form with the results of the Select.