You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacques Le Roux (JIRA)" <ji...@apache.org> on 2013/03/10 12:11:12 UTC
[jira] [Commented] (OFBIZ-5146) in ModelViewEntity.java, a Map is
built with only a few of the SQL functions, extend the map to include the
MONTH and Year functions.
[ https://issues.apache.org/jira/browse/OFBIZ-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13598209#comment-13598209 ]
Jacques Le Roux commented on OFBIZ-5146:
----------------------------------------
Those functions are not supported by all DBMS. Derby, MySql and SQL server have them, but for instance not Postgres http://www.postgresql.org/docs/9.1/static/functions-datetime.html#FUNCTIONS-DATETIME-TABLE where you need to use extract http://wiki.postgresql.org/wiki/MONTH%28%29_equivalent
Also then why not day, etc?
> in ModelViewEntity.java, a Map is built with only a few of the SQL functions, extend the map to include the MONTH and Year functions.
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-5146
> URL: https://issues.apache.org/jira/browse/OFBIZ-5146
> Project: OFBiz
> Issue Type: Improvement
> Components: framework
> Affects Versions: SVN trunk
> Reporter: Jaideep Singh
> Fix For: SVN trunk
>
> Attachments: ModelViewEntity.patch, ModelViewEntity.patch
>
>
> in ModelViewEntity.java, a Map is built with only a few of the SQL functions, extend the map to include the MONTH and Year functions.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira