In-Portal Issue Tracker - In-Portal CMS
|
|||||
Viewing Issue Advanced Details | |||||
|
|||||
ID: | Category: | Type: | Reproducibility: | Date Submitted: | Last Update: |
489 | [In-Portal CMS] Data Management | feature request | N/A | 2009-12-23 04:28 | 2009-12-23 04:30 |
|
|||||
Reporter: | alex | Platform: | |||
Assigned To: | OS: | ||||
Priority: | normal | OS Version: | |||
Status: | active | Product Version: | 5.0.2-B1 | ||
Product Build: | Resolution: | open | |||
ETA: | none | Fixed in Version: | |||
Reference: | http://groups.google.com/group/in-portal-dev/browse_thread/thread/884988084a8f4b41# | ||||
Change Log Message: | |||||
Estimate Points: | 0 | ||||
|
|||||
Summary: | 0000489: Protection against related record deletion in grids | ||||
Description: |
There are two type of database record relations in In-Portal: * direct - related record is subitem of main record (relation is defined in unit config); * indirect - there is dropdown in one table, where you can select data from other table (no direct relation defined on unit config level). When main record is deleted, then subitems are deleted as well, so it's not a problem (this is direct relation). For indirect relation this creates a problem. I propose to define field relations with other tables in unit config. Such relation will be used to check for related data before actual database record is deleted. This feature will preserve data integrity. Here is proposed data format (in main unit config, which shows data from other unit configs): 'DependentFields' => Array ( 'MainFieldA' => 'related-prefixA_FieldNameA', 'MainFieldB' => 'related-prefixB_FieldNameB', ); For example you can delete payment type, that is used in orders. |
||||
Steps To Reproduce: | |||||
Additional Information: | |||||
Relationships | |||||
Attached Files: | |||||
|
|||||
Issue History | |||||
Date Modified | Username | Field | Change | ||
2009-12-23 04:30 | alex | Reference | => http://groups.google.com/group/in-portal-dev/browse_thread/thread/884988084a8f4b41# | ||
2009-12-23 04:30 | alex | Target Version | => Icebox | ||
2009-12-23 04:28 | alex | New Issue |
There are no notes attached to this issue. |