I'd like to use a date interval as a filter for an Ad Hoc report I created in Maximo, so, when I create my report, I add STATUSDATE (WOTRACK application) as a filter; then I go in Report Administration and add a new one with a different name (but with the same attributename) and put two different operators in their relative fields (>= in the first, <= in the second).
The problem is that, when I launch my report and put a value in first parameter field, I get the same value in the second and viceversa.
Can anybody tell me why this happens?
Or better, can you help me finding a solution...?
This topic has been locked.
1 reply Latest Post - 2012-12-05T21:57:40Z by bob@work
Pinned topic Parameter date in Ad Hoc report
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-05T21:57:40Z at 2012-12-05T21:57:40Z by bob@work
bob@work 270000AABC19 PostsACCEPTED ANSWER
Re: Parameter date in Ad Hoc report2012-12-05T21:57:40Z in response to SystemAdminYou probably cannot use Maximo's automatic binding capabilities for these types of parameters. You'll have to handle the condition in the dataset open script.
params += " and (reportdate is not null) " +
" and reportdate >= "
+ MXReportSqlFormat.getStartDayTimestampFunction(params) + " and "
+ " reportdate <= "
+ MXReportSqlFormat.getEndDayTimestampFunction(params) + " "