Eclipse Community Forums: BIRT » [SOLVED] Problem with date parameters

Home » Archived » BIRT » [SOLVED] Problem with date parameters(How do I pass correctly a date parameter?)

[SOLVED] Problem with date parameters [message #1065779]

Thu, 27 June 2013 09:06

Eclipse User

Hi!

I'm currently trying to represent in my report a list of data obtained from a query that sets a time interval. SO i need to pass 2 dates to my report, a "daystart" end a "dayend".

My query goes like this:

SELECT testuser.username
FROM testuser
WHERE DATE(testuser.reg_time)
BETWEEN ?
AND ?

where testuser.reg_time is a timestamp field.
I know it works because if I input the dates directly, like this:

select testuser.username
from testuser
where date(testuser.reg_time)
BETWEEN '2013/06/03'
AND '2013/06/19'

it gives me exactly what it shoud.
(But only if i use the format YYYY/mm/dd. Others data formats give no results, and I'm thinking this is maybe part of the problem.)

This is the JSP code getting and sending the values:

------------------------------------------------------------
<birt:parameterPage id="birtTest" reportDesign="report/report1.rptdesign"
name="test"
pattern="frameset"
height="600"
width="800"
format="html"
title="test"
isCustom="true"
showTitle="true"
showToolBar="true"
showNavigationBar="true"
>

<table border=1>
<tr id = "data1">
<th> Data d'inizio selezione </th>
<td> <input type="date" name="daystart" id="daystart"> </td>
<br><br>
</tr>
<tr id = "data2">
<th> Data di fine selezione </th>
<td> <input type="date" name="dayend" id="dayend"> </td>
</tr>
<br><br>
<tr>
<td colspan = 2><input type="Submit" value="Richiedi il report"></td>
</tr>
</table>
</birt:parameterPage>
------------------------------------------------------------

The user fills the input fields selecting the data from a javascript app.

The report parameters are set (with the same name as the JSP input) and i linked them with the data set parameters.

I'm sure enough it works to a degree, because there's no occurrence for missing values in the report. So why can't I get my data?

Alas, this portion of the report remains empty, while other dynamic elements are correctly represented. I really don't know where i'm going wrong, and I've already tried a number of things.

Could it depends on the details of the parameters configuration? I tried to set them as date and as string and to convert the timestamps and... well, I tried. I'm open to any suggestion you might have!

Thanks for your patience.

Paolo

[Updated on: Thu, 04 July 2013 06:35] by Moderator

Re: Problem with date parameters [message #1065812 is a reply to message #1065779]

Thu, 27 June 2013 10:48

Eclipse User

You might try just setting your query in your dataSet to:

SELECT testuser.username
FROM testuser

Then, in your dataSet's beforeOpen script, format the entered parameter value to the format you're wanting. Something like:

importPackage(Packages.java.text);

df = new SimpleDateFormat("yyyy/MM/dd");

ds = df.format(params["daystart"]).toString();
de = df.format(params["dayend"]).toString();

this.queryText = this.queryText + " WHERE DATE(testuser.reg_time)BETWEEN '" + ds + "' AND '" + de + "'";

This way, you control the format that is passed through the query.

Re: Problem with date parameters [message #1065842 is a reply to message #1065812]

Thu, 27 June 2013 14:02

Eclipse User

Thanks Micheal!
I'll try it tomorrow, as soon as i'm back to work.
And obviously i'll keep you posted. Smile

Also, sorry for any error in grammar and/or syntax.
My english is not really there... yet.

Re: Problem with date parameters [message #1065902 is a reply to message #1065812]

Fri, 28 June 2013 04:22

Eclipse User

Found the Properties section "befoerOpen", but i'm still trying to make your suggestion work.
I keep getting stack errors.
But i keep trying. Smile

[Updated on: Fri, 28 June 2013 06:20] by Moderator

Re: Problem with date parameters [message #1066777 is a reply to message #1065902]

Thu, 04 July 2013 06:38

Eclipse User

Hi! I solved the problem setting all parameters as string, and modifing the output of the javascript date-picker to have a yyyy/mm/dd format. SHould have thought of that earlier.
Altought, it still bugs me a little not having been able to solve the problem report-side. ^^"

Thanks for your help!

Re: Problem with date parameters [message #1067073 is a reply to message #1066777]

Fri, 05 July 2013 12:53

Eclipse User

No problem. If you want to set up a simple report with the sample database showing exactly what you tried, I can take a look and we can try to get it solved for you in the report.

Previous Topic:	Manual page break with DEAPI
Next Topic:	birt rhino object literals

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Apr 14 17:34:13 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter