Jacopo,
I tested the patches again on the ofbiz instance configured with postgresQL
database, the patches worked pretty well. Although I did not have the chance to
test them under oracle or MySql, I guess the patches should work fine for these
two DBMS since they both also support SQL grammar E
Jacopo,
I tested both patches and it turns out at least Derby is not happy with these
changes. I tried SQL grammar EXTRACT(YEAR/MONTH/DAY FROM '2014-11-26')
literally in database Derby and I found Derby does not support such grammar. I
then searched WWW and found MySQL and Oracle support such g
Jacopo,
Sure, I'll test this new patch and let you know the results once it's done.
--
发自我的ONEPLUS智能手机
Jacopo Cappellato 编写:
>It would be great if you could test this improved version of the patch that I
>sent you: it internally uses the EXTRACT function that should be a standard
>function s
Dear Jacopo,
Thanks so much for your kind help, the solution works perfectly as it is
exactly what I wanted ! Now I can summary the total in the dimensions I want,
i.e. MONTH and YEAR. Thanks so much again, and I also think it is helpful to
commit these two added functions to public trunk in ca