Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0022867 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] 00. Application dictionary | major | always | 2013-01-23 11:47 | 2013-04-09 17:23 | |||||||
| Reporter | neil_smith | View Status | public | |||||||||
| Assigned To | AugustoMauch | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | PostgreSQL | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Openbravo 3.0 | |||||||||||
| 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. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0057813) AugustoMauch (administrator) 2013-04-09 17:23 |
In Openbravo it has never been possible to export/import database rules. Moved to feature request. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |