Friday, 22 April 2016

Drop Down list/Select list from Database (IBM BPM 8.5)

Which deserves more than you expected.
Electroplating Mirror Iphone 5/5S and IPHONE 7 Mobile Case




Buy from Amazon:
Buy from Amazon





Creat A List Variable . For Ex: myVar(String)List
 
 Bind this variable to your Select Control in your Coach View. 







Take Script: Write a SQL Query as per your requirement.
Attach a Nested Service to execute SQL Statement.See I attached SQL Execute Statement(SQLResult).It returns result of type SQLResult.
The Business Object of SQLResult is


Take a Script and write this : Parsing which I used is SQL Parsing
tw.local.MyVar=new tw.object.listOf.String();
if(tw.local.Result[0].rows[0]!=null && tw.local.Result[0]!=null)
{
for(var i=0;i<tw.local.Result[0].rows.listLength;i++)
{
tw.local.MyVar[i]=tw.local.Result[0].rows[i].NAMES;
}
}
 







Download the twx.

https://drive.google.com/file/d/0B1OEJ8wVoN6qUkV4YUFZN05kYzA/view?usp=sharing