Jump to content

Date type input control in new JasperServer 3.7.1


mariopielak

Recommended Posts

  • 1 month later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Hi all,

 

Ive got a similar Problem. Dates HAVE to be optional in my Reports sometimes. Now i can't make dates optional anymore.

In addition to that i used to have a flexible query which don't work aswell.

Explanation of the main query (simplified):

SELECT
<FIELDS>
FROM
<TABLE>
WHERE 1=1
--- Welches Datum
$P!{PAR_DATUMSART_VALUE}
 

Explanation of $P!{PAR_DATUMSART_VALUE} (simplified):

($P{PAR_DATUMSART}.equals(null)==true ? "" : " AND convert(CHAR(21),"+ $P{PAR_DATUMSART} +",120) BETWEEN '"+ $P{PAR_DATUMVON_VALUE} +"' AND '"+ $P{PAR_DATUMBIS_VALUE} +"' ")

So this used to work fine in 3.7.0.1 but now the Query String isn't built dynamically anymore.

No matter if there is $P{PAR_DATUMSART}.equals(null)==true is true or not it ALWAYS appends the code to the Query-String but it shouldnt.

Any suggestions on that would be highly welcome, have to fix that problem soon.

Thanks alot!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...