Announcement
Collapse
No announcement yet.
X
-
This is fixed and will be available for download in nightly builds since Dec 2 (tomorrow).
Leave a comment:
-
Hello, actually I haven't got specific setting for those, just the defaults in framework.properties:
Code:sql.defaultDateFormat: YYYY-MM-DD sql.defaultDateTimeFormat: YYYY-MM-DD HH24:MI:SS
Please note that the "new" behaviour, without the time part, is also that of the more recent builds.
Leave a comment:
-
There were bugs fixed in this area. Specifically which one of framework settings is picked up as default format for date and datetime data types. These were mixed up under certain circumstances. Please check your framework settings sql.defaultDateFormat / sql.defaultDateTimeFormat and make sure they are set to appropriate formats. Let us know please if it helped.
Leave a comment:
-
SQLDataSource field of type datetime: velocity behaviour changed
Hello, I've got a dataSource with a field of type datetime and a whereClause with a velocity substitution:
Code:.... <field name="DATA_EVENTO" type="datetime" includeFrom="JPC_LISTINI.DATA_INIZIO"/> .... <whereClause> JPC_LISTINI.DATA_INIZIO = $advancedCriteria.DATA_EVENTO </whereClause> ....
Code:JPC_LISTINI.DATA_INIZIO = TO_DATE('2019-11-27 16:41:02','YYYY-MM-DD HH24:MI:SS')
Code:JPC_LISTINI.DATA_INIZIO = TO_DATE('2019-11-27','YYYY-MM-DD')
Note: in my actual use case the criteria value referred with $advancedCriteria.name is NOT actually declared as a field. Nevertheless the change in behaviour is the same.Tags: None
Leave a comment: