cascading input test parameter

[pcouas_1]

Hi,

I have define an first parameter name isGrpMoreTweleve like this with default value expression

Boolean

(((int) ((new java.text.SimpleDateFormat("dd/MM/yyyy").parse($P{periodeFin}).getTime() -
new java.text.SimpleDateFormat("dd/MM/yyyy").parse($P{periodeDebut}).getTime())/(1000*60*60*24)))>365 ? true:false)

 

AND i want use it

($P{isGrpMoreTweleve} ?
    "nvl(decode ((TRUNC((to_number(to_char(iv.inventory_date, 'MM'))-1) / 3)+1), 1,'First Quarter',2,'Second Quarter',3,'Third Quarter',4,'Fourth Quarter', ''),'') || '-' || to_char(iv.inventory_date, 'YYYY')"
    : "to_char(iv.inventory_date,'MON-YYYY')")

This second value expression is NOT Ok

Why ?

Regard

Phil

 

[mlopez_1]

The second has some SQL syntax that does not execute at java level.

Regards,

 

Mariano

[pcouas_1]

Resolved Thanks