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

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.

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.

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

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?

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

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

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

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

So many thanks, this really helped me