Issue #2587: date parameter not working (probably) in explorer

Type: Bug ReoprtVersion: 2.7.6Priority: NormalStatus: FixedReplies: 1
#1

in explorer, for a query like this:

    select o from ObjectNode o where o.classIdentifier = '(PR)' and o.created > ?1

we try to set the parameter (its a java.util.Date) in the parameters table. None of the following works:

2020-12-01

2020.12.01

{d '2020-12-01'}

the parameter is just ignored

#2

Thank you for this report. Build 2.8.3_03 should fix this issue.

Various formats are now supported, including {d' 2020-12-01'} and d'2020-12-01'.

A workaround for previous versions is to use a date literal (embedded in the query) instead of a date parameter.

ObjectDB Support

Reply