Eclipse Community Forums: BIRT » Date parameter not working Date=any date

Home » Archived » BIRT » Date parameter not working Date=any date(Unable to set Date parameter as Date= Oct 1, 2019)

Show: Today's Messages :: Show Polls :: Message Navigator

Date parameter not working Date=any date [message #1833036]

Thu, 01 October 2020 08:01

Muhammad Minhal

Messages: 1
Registered: September 2020
Location: Pakistan

Junior Member

Hi All,
I am using Birt 4.3.1 I have to pass my date parameter as date should be equal to a specific date. The date range parameter(Start Date/End Date) is working fine but I want to add the parameter like date = Oct 1, 2019
My birt is connected with DB2 maximo database.
Following is the sample Code that I am trying:

if(params["Date"].value)
params["where"]+= " and table.date = " + MXReportSqlFormat.getTimestampFunction(params["Date"]);

When I try to put date like this it does not show any data while date range parameter is working fine.

[Updated on: Thu, 01 October 2020 09:44]

Report message to a moderator

Re: Date parameter not working Date=any date [message #1833667 is a reply to message #1833036]

Tue, 20 October 2020 19:28

rbaak Mising name

Messages: 31
Registered: July 2009

Member

Its been a little while since I used Maximo but I think you want to have something like this:

var yourdt = Formatter.format( params["Date"].value, "MM/dd/yy");

//here you are adding on to your base sql statement
sqlText = sqlText + "" and table.date =yourdt "

Robert Baakel
https://www.youtube.com/playlist?list=PLht0txJzVxKFp1WRUOouv7rQfkCmLjVas

[Updated on: Tue, 20 October 2020 22:53]

Report message to a moderator

Previous Topic:	X-Axis Interactivity
Next Topic:	onCreate error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:28:09 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter