Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0015559 | Openbravo ERP | A. Platform | public | 2010-12-31 11:47 | 2022-02-01 08:08 |
|
| Reporter | vmromanos | |
| Assigned To | Triage Platform Base | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | new | Resolution | open | |
| Platform | | OS | 20 | OS Version | Debian 5.0 |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0015559: DAL: Add support to @#Date@ as default value for a column |
| Description | Right now is impossible to define a default value for a column to "today" in a way that both the UI and DAL understand it.
For example:
-if we define the default value in the AD for a column to "SYSDATE", DAL will understand it but the UI won't do it (it will display the string SYSDATE into the field)
-if we define the default value in the AD for a column to "@#Date@", the UI will understand it but the DAL won't do it (it will use null as a default value)
This is a problem when both DAL and the UI use this column's default value. An example can be a new date column in the AD_ORG table, because for creating a new organization we can use the DAL through the Initial Org Setup or the UI through the Organization window |
| Steps To Reproduce | |
| Proposed Solution | See attached patch (please review it) |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | blocks | feature request | 0013601 | | closed | vmromanos | "Valid from Date" field in Organization |
|
| Attached Files |  dal_today.diff (884) 2010-12-31 11:47
https://issues.openbravo.com/file_download.php?file_id=3456&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2010-12-31 11:47 | vmromanos | New Issue | |
| 2010-12-31 11:47 | vmromanos | Assigned To | => alostale |
| 2010-12-31 11:47 | vmromanos | File Added: dal_today.diff | |
| 2010-12-31 11:47 | vmromanos | Modules | => Core |
| 2010-12-31 11:47 | vmromanos | OBNetwork customer | => No |
| 2010-12-31 11:49 | vmromanos | Relationship added | blocks 0013601 |
| 2017-04-10 14:39 | alostale | Assigned To | alostale => platform |
| 2022-02-01 08:08 | alostale | Assigned To | platform => Triage Platform Base |