how I may show a table's content in a form table?

Q&A
1

Hi, I’m having a problem when I want to show a MYSQL table in a form table.

Do you know how can I show its content?

Thanks in advance.

Regards.

2

If you trying to retrieve table data from MySQL database and display these data in a table. You can follow following steps:

  1. Use a database query connector to access MySQL, that will give you a java.sql.ResultSet as an output.
  2. Prepare a List<List> object out of the ResultSet
  3. Add a Table widget in your form, set the List<List> object as table data (by using option Edit as an expression).

Think this will help you somehow.

3

I did just-that in mysql but don’t have the video near me. Sorry…

What I do have is this buggy version. Its pretty close. Try it first.
link

Then I converted mysql to teradata.
This one works.
link2

Using those two videos should give you success!
Jim

4

Which version of Bonita BPM are you using? You will not use the same solution for each version.

Also can you confirm that you want to display data in a read-only mode?

5

Yes, i just show the information in a read-only mode.

I’m using BOS 6.5.3

Do you know how can I do it?

Many thanks

6

Many thanks for the reply,

but can you help me with this? How I create a variable List tipe?

I’m new in the “programming world” and also in BOS.

I would greatly appreciate if you help me further

7

This is the query that I want to use “SELECT * FROM proceso_rma”.

8

To create a variable of type List you need :

  • Select you process and open the General/Data tab
  • Click on Add…
  • In the Data type field, select “Java Object”
  • The class “java.util.List” is selected by default, this is the class that you need
  • Validate and it’s done
9

So many thanks, this really helped me