Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0029086 | Openbravo ERP | A. Platform | public | 2015-02-26 19:05 | 2022-02-01 08:05 |
|
| Reporter | caristu | |
| Assigned To | Triage Platform Base | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | pi | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 34265 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0029086: TableDir reference does not support parent table with computed column as identifier |
| Description | TableDir reference does not support parent table with computed column as identifier |
| Steps To Reproduce | 1. Add a computed column in a parent table and mark it as "record identifier". For example, add a computed column in the FIN_Financial_Account table.
2. Create a child table, with foreign key to the parent table.
In the table definition, use TableDir as reference type. We already have this with the FIN_Finacc_Transaction table
3. Recompile. Notice that an error related to the computed column is shown, but the compilation ends successfully
4. Navigate to the Financial Account window. Open any record of the Transaction tan in form mode, the record is not opened properly and the attached error appears in the log.
Notice that using a different reference from TableDir in the child table, the record in the child tabs can be opened without errors. |
| Proposed Solution | To be decided if it is allowed to mark a computed column as record identifier |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  errorLog.txt (80,047) 2015-02-26 19:05
https://issues.openbravo.com/file_download.php?file_id=7836&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2015-02-26 19:05 | caristu | New Issue | |
| 2015-02-26 19:05 | caristu | Assigned To | => AugustoMauch |
| 2015-02-26 19:05 | caristu | File Added: errorLog.txt | |
| 2015-02-26 19:05 | caristu | OBNetwork customer | => Yes |
| 2015-02-26 19:05 | caristu | Modules | => Core |
| 2015-02-26 19:05 | caristu | Support ticket | => 34265 |
| 2015-02-26 19:05 | caristu | Resolution time | => 1431295200 |
| 2015-02-26 19:05 | caristu | Triggers an Emergency Pack | => No |
| 2015-02-26 19:06 | caristu | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=7800#r7800 |
| 2015-02-26 19:06 | caristu | version | => pi |
| 2015-02-26 19:06 | caristu | Target Version | => 3.0PR15Q2 |
| 2015-02-26 19:09 | caristu | Issue Monitored: networkb | |
| 2015-02-26 19:14 | caristu | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=7801#r7801 |
| 2015-02-26 19:14 | caristu | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=7802#r7802 |
| 2015-03-06 09:15 | alostale | Note Added: 0075226 | |
| 2015-03-06 09:18 | alostale | Status | new => acknowledged |
| 2015-03-09 17:37 | jonalegriaesarte | Resolution time | 1431295200 => |
| 2015-03-11 08:07 | alostale | Target Version | 3.0PR15Q2 => |
| 2015-03-17 14:37 | alostale | Assigned To | AugustoMauch => platform |
| 2015-11-11 11:37 | alostale | Priority | high => normal |
| 2022-02-01 08:05 | alostale | Assigned To | platform => Triage Platform Base |