|
|
Re: Dynamic Parameter with Scripted Data Set [message #730940 is a reply to message #730789] |
Thu, 29 September 2011 14:56 |
|
My guess is that you are getting an error in the fetch. Try
if( typeof maximoDataSet == 'undefined')return false;
if( maximoDataSet == null)return false;
if (!maximoDataSet.fetch()) {
return (false);
}
You can also just add a file writer and write out variables to a local
file to see what is happening.
importPackage( Packages.java.io );
out = new PrintWriter( new FileWriter( "c:/temp/sdsevents.txt", true ) );
out.println( "maximoDataSet Size " + maximoDataSet.size());
out.close();
Jason
On 9/29/2011 3:37 AM, Krzysiek wrote:
> This is "open" script
>
> maximoDataSet =
> MXReportDataSetProvider.create(this.getDataSource().getName(),
> this.getName());
> maximoDataSet.open();
> var sqlText = new String();
> sqlText = "select enddescription from asset where enddescription is not
> NULL";
> maximoDataSet.setQuery(sqlText);
> i = 1;
>
> and here is "fetch"
>
> if (!maximoDataSet.fetch()) {
> return (false);
> }
> row["streetname"] = maximoDataSet.getString("enddescription");
> row["count"] = i++;
> return (true);
>
|
|
|
Powered by
FUDForum. Page generated in 0.02588 seconds