Postgres query result (List of lists) fills only the first column in form Table

Q&A
21

Hello Stefandebruijn,

You solution works very well, I used in mysql 5.6+bonita community 7.1.5, got the same issue as you had before, but your solution is perfect cure for this, thank you so much for your contribution…

22

Hello Stefandebruijn,

You solution works very well,thank you so much

23

hello i have always same result
son

2

my output
output

log file
log

24

Hello DrakunDry,
At this time you probably already solved your problem, but for the community… I just wanted to point out that there is an error in your script:

The variable “jsonb” was defined before the While setence. The variable “jsonb” must be defined after the While and also the line before of the “line” variable definition.
Hope it helps others.

Actually, the post from stefandebruijn tells the correct form of creating your script.

Happy coding!

25

Hi jeanov92,

In the ‘output operations definition’ (the last step when defining a connector). Click on the little pencil on the right hand side.

You should create a variable indeed.

26

I am not a developer, but i guess there are some ways to achieve what you need:

  1. query directly from to form on your database (through rest api, outside bonita) I do not know how to do this, depends also on your database.
  2. load all the data into your form and add a filter in the result table. The filter value should be bound to the value of your selector (search angular js filter). This works pretty good. I can give you an example if you need.
  3. select the data in the selector, submit the form, query the database with the selector value, activate new form in new task and return the query result to the new form (not

Probably there are better options, Mayby you can post your question as a new one.

rgds, Stefan

27

I’m trying to do this in the same task.
Please, I really appreciate it, give me a filter example.

28

Ok, this is working for me:

  1. Create an empty String variable in de UI designer and call it varFilter (for example)
  2. Bind the output value of your selector to this variable. So if you select a value, that value is assigned to variable varFilter
  3. Add the filter to your table by adding a pipe and filter:varFilter to your table dataset. Like this: yourTableInputVariable | filter:varFilter
    This is done in the file ‘content’ for a table or ‘repeat contents’ for a container

This is basic angularjs. You can search google for other angularjs filter examples,

Good luck

29

Thanks it works great!