I try the script but it’s not working, maybe it comes from the variable.
What kind of variable must I use? I use a java.util.List
And I put the script in a connexion in for a Mysql connexion
I put this request : SELECT “titre”, “description” FROM demo
At the last screen I choose the variable listoftitre (java.util.List) take value of resulset, I edit and I put this code in script :
import groovy.json.JsonBuilder;
List<Object> booktable = new ArrayList<Object>();
while (resultset.next()){
def builder = new JsonBuilder();
def line = builder {
titre resulset.getString("titre");
description resulset.getString("description");
}
booktable.add(line);
}
return booktable;
Ofelia empowers development teams with Bonita BPM, the open-source and extensible platform to solve the most demanding process automation use cases. The Bonita BPM platform accelerates delivery of complex applications with clear separation between capabilities for visual programming and for coding. Ofelia integrates with existing solutions, orchestrates heterogeneous systems, and provides deep visibility into processes across the organization.