How do you display a business variable list (containing SQL data) in the UI table widget?


I'm quite new to Bonitasoft. I'm currently using the Bonitasoft 7.4.3 Community Edition, to use as a POC to show to my manager the capabilities of Bonitasoft in terms of a BPM offering.

I'm having issues with displaying a business variable list containing data from a MS SQL table into the UI table widget. I've gone through the tutorials on the UI and have looked at all questions and answers containing the linking of external data and displaying the data in the UI. Below is what I've done.

How to insert data in widget table

I do not know enter data in the table cells. Could you help me please

Table - sort and filter


I am new to the bonitasoft tool. And I am aware that in the subscription version this table widget is included that can be sorted and filtered. However, I am not sure that I will be purchasing the subscription version.

Deselecting row in a table

Is there a key / mouse combination for deselecting a row in a table. I would like to be able to hide the detail container setting the selected row to null. I have identified some workaround, but they have side effects.

Table Widget

As prescribed i tried to replicate the sample BPM provided by Bonitasoft

I face a situation where table data in Expense Review report is not populated

even though I checked other variables which are displaying and also binded the table content to the line values.

Please have a look at image and help me in this. Facing the issue from many days.

Thanks and Regards,
Karthik Rayanki.