is it possible to embed the HTML code into the Groovy Script ?
Requirement : I have to send an email to the approvers with Prices fetched from the Database
Used SQL Connector and retrieved the information and I stored the values in X variable (Datatype : java.sql.Resultset) and created the HTML table with the data retrieved in variable "X" and stored in the variable called "htmlTable"(DataType : String).
Currently I have a groovy script configured in the message textbox in the Email connector , but I am not able to add the variable "HtmlTable" in the Groovy script.
Can any one help me in answering this ?
Bonita Version : 6.5.4