<p>Hi, I need help figuring out how to list workorders from MAXIMO, just by entering in the parameter workorder.wonum ,"the WO parent". This is the script from de maindataset and de subdataset.</p>
<p> </p>
<p>MAINDATASET</p>
<p>mainDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName()); mainDataSet.open();</p>
<p>var sqlText = new String();</p>
<p>sqlText = "select workorder.description, workorder.wonum nro_ot, workorder.location from workorder" </p>
<p>+ " where " + params["where"] </p>
<p>;</p>
<p>mainDataSet.setQuery(sqlText);</p>
<p> </p>
<p>SUBDATASET</p>
<p>subDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName()); subDataSet.open();</p>
<p>var sqlText = new String();</p>
<p>sqlText = "select workorder.description, workorder.wonum subot, workorderlocation, workorder.assetnum, workorder.parent " + " from workorder" + " where workorder.parent = ' "+ rows[0]["nro_ot"] + " ' " </p>
<p>//+ " where " + params["where"] </p>
<p>;</p>
<p>subDataSet.setQuery(sqlText);</p>
<p> </p>
<p>I can't see to make the report run the list of WO, it only shows the parent WO.</p>
