||Wed, 18 April 2012 13:39
| Dejan Vujanic
Registered: October 2011
Within some IBM application I want to run report from specific record and for that record automatically to be shown only it's information. But I keep getting information from all records from database (I am getting the list instead of one record).|
I created table with one row and there put grid with many rows and two columns:
I want it like in this form:
FIELD3: VALUE3 ....
I think that I need to create script data set with open and fetch method:
maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
var sqlText = new String();
sqlText = "select workorder.workorderid, workorder.wonum, workorder.description, workorder.status "
+ "from workorder"
row["workorderid"] = maximoDataSet.getString("workorderid");
row["wonum"] = maximoDataSet.getString("wonum");
row["description"] = maximoDataSet.getString("description");
row["status"] = maximoDataSet.getString("status");
I do not know what am I doing wrong. My simple example file is attached. But as result I am getting many grids, I just want one record that runs that report. How to restrict it?
Powered by FUDForum
. Page generated in 0.16071 seconds