Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0013322 | Openbravo ERP | A. Platform | public | 2010-05-14 09:41 | 2010-05-14 09:41 |
| Reporter | alostale | ||||
| Assigned To | iciordia | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| 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 | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0013322: Entity subtypes | ||||
| Description | A very common pattern in openbravo is subtypes. For example there is a super type of Invoices and two subtypes for it: Sales Invoices and Purchase Invoices. All subtypes are physically stored in the same table, C_Invoice in this case. This should be definable in AD. A subtype would be defined as: -Subtype entity: is the subtype entity. In the example Purchases and Sales. -Parent type: which would be the parent entity. In the example Invoice. -Where clause: it is a boolean expression that for each record in the physical table, this clause defines the record subtype. In the example IsSoTrx value would define to which subtype belongs each record. -Columns: subtypes should also be allowed to define specific columns, which are accessible from other subtypes at the same level, but are present in the super type. This would allow to have subtype specific properties. With this definition subtypes could be used in different places: -They would become DAL objects, so they could be instantiated. -They could be used to define tabs, in this way many of the where clauses that currently tabs have would be unnecessary. -Navigation window could be defined at this level, solving issues like 0012938 -... | ||||
| Steps To Reproduce | |||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2010-05-14 09:41 | alostale | New Issue | |||
| 2010-05-14 09:41 | alostale | Assigned To | => iciordia | ||
| 2010-05-14 09:41 | alostale | Description Updated | bug_revision_view_page.php?rev_id=362#r362 | ||
| There are no notes attached to this issue. |