Connect external bank to the UI Designer in Bonitasoft Community

3

I am using the Bonitasoft tool to develop a BPM project, I have a PostgreSQL database that through a JDBC insert and change records by Bonitasoft , but I can not select the data from the database and display it in my UI Designer , since it is not yet widely used, I did not find much information about it, if you have some material or some idea of how I can display the data in a spreadsheet in my UI Designer soon, it would be very useful.

I tested the return that my Select brings me and the information matched correctly with what I need, so I added the information to a arrayList , my problem now is to display the information of this Array in UI Designer

    
asked by anonymous 23.01.2017 / 17:26

1 answer

0

After much research and help from a user with more experience and knowledge of the tool, I was able to view the information that is in my external database in my UI Designer.

Initially I had to set up a REST API variable that would point to my BDM:

../API/bdm/businessData/com.hss.model.TransportadoraPostgreSQL?q=find&p=0&c=100

Where:

  • TransportadoraPostgreSQL is the name of my BDM.
  • q=find is my query that finds everything in BDM.
  • c=100 is the maximum number of BDM records that will be displayed

REST API Variable Configuration:

Tableconfigurationwherethelogswillbedisplayed:

    
22.03.2017 / 15:29