Eclipse Community Forums: BIRT » Passing Maximo where clause

Home » Archived » BIRT » Passing Maximo where clause

Passing Maximo where clause [message #1754913]

Thu, 23 February 2017 16:49

Eclipse User

I am having problems passing a simple where clause from Maximo to my BIRT report.

I have a parameter called where with default value of 1=1,
my open script includes the following: where " + params["where"].

I have tried hard coding the value into the open script and the report functions as designed. I have also set up a manual parameter where the user enters the value and that also works as designed.

The report seems to work I just cannot get Maximo to pass the where clause. I have looked at an out of box report as well as a custom report that both use the same where " + params["where"] and they work fine. I cannot think of any other reason that this will not work.

Any suggestions are appreciated.

Re: Passing Maximo where clause [message #1790121 is a reply to message #1754913]

Tue, 05 June 2018 09:35

Eclipse User

Did you resolve this understanding the params["where"]? If you are using Maximo BIRT, then the "where" will pass parameters that are contained in the Report Object Structure. Looking at an out of box report, WO Details for example, there is a standard set of report parameters for all out of box reports. The parameter 'appname' communicates to the BIRT report what maxrelationship is being used for the report. 'appname' = WOTRACK maxrelationship= WORKORDER. The current record workorderid, siteid, are automatically passed to the query in the 'where' parameter.
If you want to see what is passed in the 'where' you can setup a Global var in the initialize() then in the main dataset query set gblVar= sqlText then add this to a data element in the header of the report. Import and execute. The sqlText will contain the scripted query for the report with the added 'where' . Do this with several different OOB reports to learn what Maximo is passing to different kinds of reports.

Previous Topic:	data set with field date ?
Next Topic:	All numbers in Table format

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Mar 24 10:20:21 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter