This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Is anyone developing reports in BIRT?
Date parameters are giving me a fit using BIRT. My latest issue is that I need report generated using a parameter that should include date and time. I thought I should be able to just leave the parameter as a datetime value, but when I attempt to enter a date time (2012-09-25 13:00:00.000) I get no results.
What does your SQL statement and parameter look like?
Are you using the Maximo supplied date methods?
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: cbrandon63 <cbrandon63@yahoo.com>
To: MAXIMO@yahoogroups.com
Sent: Friday, September 28, 2012 12:06 PM
Subject: [MAXIMO List] Date parameter issue with creating BIRT report for Maximo 7.5
Is anyone developing reports in BIRT?
Date parameters are giving me a fit using BIRT. My latest issue is that I need report generated using a parameter that should include date and time. I thought I should be able to just leave the parameter as a datetime value, but when I attempt to enter a date time (2012-09-25 13:00:00.000) I get no results.
sqlText =
"select po.vendor, companies.company, companies.name, person.displayname, "
" matrectrans.ponum, matrectrans.itemnum, matrectrans.description, "
" matrectrans.modelnum, matrectrans.quantity, matrectrans.receivedunit, matrectrans.tobin, "
" matrectrans.actualdate, matrectrans.enterby, matrectrans.issuetype, matrectrans.remark "
" from matrectrans "
" left outer join po on po.ponum = matrectrans.ponum "
" left outer join companies on po.vendor = companies.company "
" left outer join person on person.personid = po.shiptoattn "
" where matrectrans.actualdate >= ? "
" and matrectrans.issuetype = ? "
" order by po.vendor, matrectrans.ponum "
;maximoDataSet.setQuery(sqlText);
maximoDataSet.setQueryParameterValue(1, params[
"PARM_FromDate"]);
maximoDataSet.setQueryParameterValue(2, params[
"PARM_Type"]);
________________________________
From: "wwilliams@rocketmail.com" <wwilliams@rocketmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Friday, September 28, 2012 12:29 PM
Subject: Re: [MAXIMO List] Date parameter issue with creating BIRT report for Maximo 7.5
What does your SQL statement and parameter look like?
Are you using the Maximo supplied date methods?
Wes Williams
http://www.weswilliams.net/
http://www.williamsconnell.com/
________________________________
From: cbrandon63 <mailto:cbrandon63%40yahoo.com>
To: mailto:MAXIMO%40yahoogroups.com
Sent: Friday, September 28, 2012 12:06 PM
Subject: [MAXIMO List] Date parameter issue with creating BIRT report for Maximo 7.5
Is anyone developing reports in BIRT?
Date parameters are giving me a fit using BIRT. My latest issue is that I need report generated using a parameter that should include date and time. I thought I should be able to just leave the parameter as a datetime value, but when I attempt to enter a date time (2012-09-25 13:00:00.000) I get no results.
http://www-01.ibm.com/support/docview.wss?uid=swg21498572
Wes Williams
http://www.weswilliams.net
http://www.williamsconnell.com
________________________________
From: Chris Brandon <cbrandon63@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Friday, September 28, 2012 12:41 PM
Subject: Re: [MAXIMO List] Date parameter issue with creating BIRT report for Maximo 7.5
sqlText =
"select po.vendor, companies.company, companies.name, person.displayname, "
" matrectrans.ponum, matrectrans.itemnum, matrectrans.description, "
" matrectrans.modelnum, matrectrans.quantity, matrectrans.receivedunit, matrectrans.tobin, "
" matrectrans.actualdate, matrectrans.enterby, matrectrans.issuetype, matrectrans.remark "
" from matrectrans "
" left outer join po on po.ponum = matrectrans.ponum "
" left outer join companies on po.vendor = companies.company "
" left outer join person on person.personid = po.shiptoattn "
" where matrectrans.actualdate >= ? "
" and matrectrans.issuetype = ? "
" order by po.vendor, matrectrans.ponum "
;maximoDataSet.setQuery(sqlText);
maximoDataSet.setQueryParameterValue(1, params[
"PARM_FromDate"]);
maximoDataSet.setQueryParameterValue(2, params[
"PARM_Type"]);
________________________________
From: "wwilliams@rocketmail.com" <wwilliams@rocketmail.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Friday, September 28, 2012 12:29 PM
Subject: Re: [MAXIMO List] Date parameter issue with creating BIRT report for Maximo 7.5
What does your SQL statement and parameter look like?
Are you using the Maximo supplied date methods?
Wes Williams
http://www.weswilliams.net/
http://www.williamsconnell.com/
________________________________
From: cbrandon63 <mailto:cbrandon63%40yahoo.com>
To: mailto:MAXIMO%40yahoogroups.com
Sent: Friday, September 28, 2012 12:06 PM
Subject: [MAXIMO List] Date parameter issue with creating BIRT report for Maximo 7.5
Is anyone developing reports in BIRT?
Date parameters are giving me a fit using BIRT. My latest issue is that I need report generated using a parameter that should include date and time. I thought I should be able to just leave the parameter as a datetime value, but when I attempt to enter a date time (2012-09-25 13:00:00.000) I get no results.
Brandon,
I am running Maximo in an Oracle 11 database. Whenever I need to use Date/Time parameters, I force the user to enter the parameters in the format mm/dd/yyyy hh:mm:ss (24-hour format). For Oracle you would construct your query as follows:
" where matrectrans.actualdate >= to_date('" + params["PARM_FromDate"] + "','mm/dd/yyyy hh24:mi:ss')"
Regards,
- Patrick Burrows
Grifols, Inc.
--- In MAXIMO@yahoogroups.com, wwilliams@... wrote:
>
> http://www-01.ibm.com/support/docview.wss?uid=swg21498572Â
>
>
> Â
> Wes Williams
>
>
> http://www.weswilliams.net
> http://www.williamsconnell.com
>
>
> ________________________________
> From: Chris Brandon <cbrandon63@...>
> To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> Sent: Friday, September 28, 2012 12:41 PM
> Subject: Re: [MAXIMO List] Date parameter issue with creating BIRT report for Maximo 7.5
>
>
> Â
>
> sqlText =
> "select po.vendor, companies.company, companies.name, person.displayname, "
> " matrectrans.ponum, matrectrans.itemnum, matrectrans.description, "
> " matrectrans.modelnum, matrectrans.quantity, matrectrans.receivedunit, matrectrans.tobin, "
> " matrectrans.actualdate, matrectrans.enterby, matrectrans.issuetype, matrectrans.remark "
> " from matrectrans "
> " left outer join po on po.ponum = matrectrans.ponum "
> " left outer join companies on po.vendor = companies.company "
> " left outer join person on person.personid = po.shiptoattn "
> " where matrectrans.actualdate >= ? "
> " and matrectrans.issuetype = ? "Â Â Â Â Â
> " order by po.vendor, matrectrans.ponum "
> ;maximoDataSet.setQuery(sqlText);
> maximoDataSet.setQueryParameterValue(1, params[
> "PARM_FromDate"]);
> maximoDataSet.setQueryParameterValue(2, params[
> "PARM_Type"]);
>
>
> ________________________________
> From: "wwilliams@..." <wwilliams@...>
> To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> Sent: Friday, September 28, 2012 12:29 PM
> Subject: Re: [MAXIMO List] Date parameter issue with creating BIRT report for Maximo 7.5
>
>
> Â
>
> What does your SQL statement and parameter look like?
> Are you using the Maximo supplied date methods?
> Â
> Wes Williams
>
> http://www.weswilliams.net/
> http://www.williamsconnell.com/
>
> ________________________________
> From: cbrandon63 <mailto:cbrandon63%40yahoo.com>
> To: mailto:MAXIMO%40yahoogroups.com
> Sent: Friday, September 28, 2012 12:06 PM
> Subject: [MAXIMO List] Date parameter issue with creating BIRT report for Maximo 7.5
>
> Â
> Is anyone developing reports in BIRT?
>
> Date parameters are giving me a fit using BIRT. My latest issue is that I need report generated using a parameter that should include date and time. I thought I should be able to just leave the parameter as a datetime value, but when I attempt to enter a date time (2012-09-25 13:00:00.000) I get no results.
>
>
>
>
>
>
>
>
>
>