Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0031363 | Openbravo ERP | A. Platform | public | 2015-11-04 18:02 | 2022-02-01 08:09 |
| Reporter | gorkaion | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Platform | OS | 20 | OS Version | Gentoo | |
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0031363: Date related parameters do not work correctly | ||||
| Description | When a date (on most of its variants) parameter value is stored in the OBUIAPP_Parameter_Value table it is not properly stored and displayed later. This issue can be reproduced with Widget Parameters. Only Date references are stored in the Value_Date column. Absolute Date, Absolute Time, Date Time and Time references are stored in the Value_String column. When the value is displayed Time and Absolute Time values are lost, Date type References are shown with the Time and Date Time references are shown without parsing the value. | ||||
| Steps To Reproduce | 1. As System Administrator open the Widget window. 2. Go to Invoices To Collect widget. 3. In the Parameter tab add 5 new parameters one for each Date related reference: * Date, Date Time, Time, Absolute Date Time and Absolute Time. 4. Change to F&B International Group Admin role. 5. If the modified widget is not in the workspace add it using the Add Widget link. 6. Go to Edit Settings and insert a value on each date related parameter. 7. Click save 8. Change to System Administrator and open the Sql Query window (it is important to change the role even if you don't execute the query) 9. Execute the following query to get the latest values and check that only the Date parameter is stored in the Value_Date column: "select * from obuiapp_parameter_value order by created desc" 10. Change to F&B International Group Admin role. 11. Go to Edit Settings on the Invoice to Collect widget. 12. Check that the date references are not properly displayed. | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2015-11-04 18:02 | gorkaion | New Issue | |||
| 2015-11-04 18:02 | gorkaion | Assigned To | => platform | ||
| 2015-11-04 18:02 | gorkaion | Modules | => Core | ||
| 2015-11-04 18:02 | gorkaion | Triggers an Emergency Pack | => No | ||
| 2015-11-06 10:58 | alostale | Status | new => acknowledged | ||
| 2015-11-06 10:58 | alostale | Type | defect => design defect | ||
| 2022-02-01 08:09 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |