Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Date parameter not working Date=any date(Unable to set Date parameter as Date= Oct 1, 2019)
Date parameter not working Date=any date [message #1833036] Thu, 01 October 2020 08:01 Go to next message
Muhammad Minhal is currently offline Muhammad MinhalFriend
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 Go to previous message
rbaak Mising name is currently offline rbaak Mising nameFriend
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 "



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

Report message to a moderator

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


Current Time: Sun Sep 19 21:04:40 GMT 2021

Powered by FUDForum. Page generated in 0.02064 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top