nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

optional parameter in subreport

oraBirt

HI, all,Thanks in advance!The report is edited from woprint report which is the out of box one, now two optional parameters are added for actualLaborDataset, its open function is coped below. the problem is when the date parameters are set, no related data is retrieved. Any help would be appreciated! [font="'courier new';"]actualLaborDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());[/font][font="'courier new';"]actualLaborDataSet.open();[/font] [font="'courier new';"]var sqlText = new String();[/font] [font="'courier new';"]// Add query to sqlText variable.[/font][font="'courier new';"]sqlText = "select workorder.taskid, labtrans.craft, labtrans.skilllevel, labtrans.laborcode, labtrans.vendor, "[/font][font="'courier new';"]+ "labtrans.contractnum, labtrans.regularhrs, labtrans.premiumpayhours, labtrans.payrate, "[/font][font="'courier new';"]+ "labtrans.premiumpayratetype, labtrans.linecost, labtrans.premiumpayrate, "[/font][font="'courier new';"]+ "labtrans.enterdate, labtrans.gldebitacct "[/font][font="'courier new';"]+ "from labtrans, workorder "[/font][font="'courier new';"]+ "where workorder.wonum = labtrans.refwo "[/font][font="'courier new';"]+ "and workorder.siteid = labtrans.siteid "[/font][font="'courier new';"]+ "and labtrans.genapprservreceipt = 1 "[/font][font="'courier new';"]+ "and workorder.siteid = '" + rows[0]["siteid"] + "'"[/font][font="'courier new';"]+ "and ((workorder.parent = '" + rows[0]["wonum"].replace(/'/g,"''") + "' and workorder.taskid is not null) "[/font][font="'courier new';"]+ "or (workorder.wonum = '" + rows[0]["wonum"].replace(/'/g,"''") + "' and workorder.taskid is null)) "[/font][font="'courier new';"]+ "order by workorder.taskid"[/font][font="'courier new';"];[/font] [font="'courier new';"]// **************************************************************************[/font][font="'courier new';"]if (params["StartDate"].value != "" && params["StartDate"].value != null)[/font][font="'courier new';"] {[/font][font="'courier new';"] sqlText = sqlText + " and labtrans.enterdate >= to_date('" + params["StartDate"] + "', 'MM/DD/YYYY')" ;[/font][font="'courier new';"]}[/font][font="'courier new';"]if (params["FinishDate"].value != "" && params["FinishDate"].value != null)[/font][font="'courier new';"] {[/font][font="'courier new';"] sqlText = sqlText + " and labtrans.enterdate <= to_date('" + params["FinishDate"] + "', 'MM/DD/YYYY')" ;[/font][font="'courier new';"] }[/font] [font="'courier new';"]// **************************************************************************[/font] [font="'courier new';"]actualLaborDataSet.setQuery(sqlText);[/font]

Find more posts tagged with

Comments

micajblock

'&&' is an AND operator. '||' is the OR operator.

oraBirt

Thanks very much for your reply!Tried Or operator ||, still no related data retrieved. I tested a simple reports using same syntax with optional parameter but worked fine. Not sure what is missing or wrong.Again, thanks!!

micajblock

What is the data type of [color=rgb(40,40,40);font-family:'courier new';]params["StartDate"]?[/color]

oraBirt

string, and the simple test report is same and worked fine. Thanks very much for your time and great help!

micajblock

Can you display oin a report to see How Maximo is passing the date?

oraBirt

Sorry, could you please show me? Thanks!

micajblock

drag the parameter from the outline in to the layout.

oraBirt

Thanks!The solution is to add this line after the if statement ( and delete this line from the long query): [font="'courier new';"][font="'courier new';"]sqlText = sqlText + "order by workorder.taskid";[/font][/font]

micajblock

that would do it. Order is always after the where clause.