[
https://issues.apache.org/jira/browse/OFBIZ-5146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13905492#comment-13905492
]
Jacopo Cappellato commented on OFBIZ-5146:
------------------------------------------
In my opinion the proposed patch is a good one and could be committed as is,
even if we are considering an overhaul.
I have used a similar one for a custom project.
We could also slightly change the code (it is a simple change) to allow for any
unary function in the field definition: of course the db will return an error
if the function is not supported. In order to do this properly we could add a
"type" attribute to the field definition to specify the type of the unary
operator expected by the function.
I understand that there are DBMS that do not support these functions: we could
fix this in a second phase (this is more complex) by creating all the missing
function at startup.
> 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 was sent by Atlassian JIRA
(v6.1.5#6160)
