[
https://issues.apache.org/jira/browse/OFBIZ-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13602218#comment-13602218
]
Paul Foxworthy commented on OFBIZ-5146:
---------------------------------------
Hi Adrian,
OK, I see your point.
For YEAR, MONTH etc vs EXTRACT, its doable. Before we expose a database
function, we should decide what databases we want to support, and ensure the
function can be implemented in every one of them.
One approach might be to only expose standard SQL 03 functions, and provide
adapter functions (either within OFBiz or as user-defined functions in the
database) for databases that do not directly support the SQL 03 function. That
reduces our effort, and increases the chance that it will work with some random
database we don't already support, should anyone want to try.
Cheers
Paul Foxworthy
> 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
