Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0022867 | Openbravo ERP | 00. Application dictionary | public | 2013-01-23 11:47 | 2013-04-09 17:23 |
| Reporter | neil_smith | ||||
| Assigned To | AugustoMauch | ||||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Openbravo 3.0 | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0022867: Allow CRUD operations on views | ||||
| Description | Alow to insert, update and delete on views through the database rules (CREATE RULE rule_name AS ON DELETE TO table_name DO INSTEAD...). This feature worked before (3.0MP8 I think... not sure of the MP). I installed MP14.2 and it is not supported any more (the rule had to be re-created by hand, but the operations on views worked). If the view is defined as a view, it is not possible to delete records. If I set the view not as a view, I get warnings that the client, organization, ... fields don't have the mandory setting in the database metadata. | ||||
| Steps To Reproduce | Create a view on a table in the database. Create a rule in the database for deletion on the view so that it deletes in table the view is based on. Create the table in OB and define it as a view. Create a window on the view and add it to the menu. Compile and access the new window. -> It is not possible to delete a record (the garbage is deactivated). Modify the view in OB and uncheck the view checkbox Compile You get warnings <code> Column xxx mandatory setting not found in the database metadata. A cause can be that the column does not exist in the database schema </code> Access the window, you can delete from the view and it deletes from the according table defined in the rule. | ||||
| Proposed Solution | Integrate support of Database Rules in OB (export.database, ...) Allow CRUD operations on views, if we don't want to, it is possible to uncheck the 'Deletable Records' in the table and set the tab as read-only. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2013-01-23 11:47 | neil_smith | New Issue | |||
| 2013-01-23 11:47 | neil_smith | Assigned To | => AugustoMauch | ||
| 2013-01-23 11:47 | neil_smith | Modules | => Openbravo 3.0 | ||
| 2013-01-23 11:47 | neil_smith | Triggers an Emergency Pack | => No | ||
| 2013-04-09 17:23 | AugustoMauch | Note Added: 0057813 | |||
| 2013-04-09 17:23 | AugustoMauch | Type | defect => feature request | ||
| Notes | |||||
|
|
|||||
|
|
||||