| Problem with date parameters "Cannot set the date value (2019-10-17 00:00) to parameter 1" [message #1816020] |
Thu, 17 October 2019 12:02 |
 kaltoum hajoui
Messages: 1
Registered: October 2019 |
Junior Member |
|
|
Hi!
the error "Cannot set the date value (2019-10-17 00:00) to parameter 1" is displayed when launching the birt report in our web application. while the report runs without error in birt version = "3.2.23".
I' ve used a string as parameter whit setting the default format to : Formatter.format(BirtDateTime.now(), "dd/MM/yyyy HH:mm:ss")
My query goes like this:
select
cust.DESCRIPTION as Activité,
eq.CODE as Série,
"EQPT"."mat_code" as "material_code",
--"EQPT"."mat_description" as "material_desc",
Atype.CODE as Opérations,
count (Distinct w.ID) as process_expected,
count ( Distinct int_closed_exp.ORIGIN_ID) as process_performed
from /*@@@*/
CARL_CS02.CARL_CS02.CSWO_WO w
inner join CARL_CS02.CARL_CS02.CSWO_ACTIONTYPE Atype
on Atype.id = w.ACTIONTYPE_ID
left outer join (select
we.WO_ID as "wo_id",
eq.CODE as "mat_code",
eq.DESCRIPTION as "mat_description"
from CARL_CS02.CARL_CS02.CSWO_WOEQPT we
inner join CARL_CS02.CARL_CS02.CSEQ_EQUIPMENT eq
on we.EQPT_ID = eq.ID
and eq.STRUCTURE_ID = 'MATERIAL'
where /*###*/ CAST(we.DIRECTEQPT as INTEGER) = 1
and CAST(we.REFEREQPT as INTEGER) = (select max(CAST(we2.REFEREQPT as INTEGER)) from CARL_CS02.CARL_CS02.CSWO_WOEQPT we2
where /*###*/ we.WO_ID = we2.WO_ID)) "EQPT"
on "EQPT"."wo_id" = w.ID
inner join CARL_CS02.CARL_CS02.CSWO_PREVENTIVETRIGGER pt
on pt.ID = w.PREVENTIVETRIGGER_ID
left outer join CARL_CS02.CARL_CS02.CSEQ_MATERIAL mat
on mat.ID = pt.MATERIAL_ID
left outer join CARL_CS02.CARL_CS02.CSCU_CUSTOMER cust
on mat.CUSTOMER_ID = cust.ID
left outer join CARL_CS02.CARL_CS02.CSST_ITEM item
on mat.ITEM_ID = item.ID
left outer join CARL_CS02.CARL_CS02.CSEQ_EQUIPMENT eq
on eq.ID = item.ID
left outer join CARL_CS02.CARL_CS02.CSWO_WOEQPT we
on w.ID = we.WO_ID
left outer join CARL_CS02.CARL_CS02.CSWO_WOSTATUS int_request
on int_request.ORIGIN_ID = we.WO_ID and int_request.STATUS_CODE = 'REQUEST'
left outer join CARL_CS02.CARL_CS02.CSWO_WOSTATUS int_closed
on int_closed.ORIGIN_ID = we.WO_ID and int_closed.STATUS_CODE = 'CLOSED'
left outer join CARL_CS02.CARL_CS02.CSWO_WOSTATUS int_closed_exp
on int_closed_exp.ORIGIN_ID = we.WO_ID and int_closed_exp.STATUS_CODE = 'CLOSED' and year (int_closed_exp.STATUS_CHANGEDDATE) = year (?)
left outer join CARL_CS02.CARL_CS02.CSEQ_EQUIPMENT e
on we.EQPT_ID = e.ID
where /*###*/
"EQPT"."mat_code" is not null
and year(int_request.STATUS_CHANGEDDATE)= YEAR(?)
and w.STATUS_CODE <> 'CANCEL'
and year (w.WOBEGIN)= YEAR(?)
and year (w.WOEND) >= YEAR(?) or w.WOEND IS NULL
and year(int_closed.STATUS_CHANGEDDATE) >= YEAR(?)
--and year(w.XTRADATE01) >= year(?) or w.XTRADATE01 is NULL
group by
eq.CODE,
"EQPT"."mat_code",
Atype.CODE,
cust.DESCRIPTION
|
|
|
Powered by
FUDForum. Page generated in 0.03050 seconds
] 
Search
Help
Register
Login
Home
