In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Type

Reproducibility

Date Submitted

Last Update

0000489

[In-Portal CMS] Data Management

feature request

N/A

2009-12-23 04:28

2009-12-23 04:30

Reporter

alex

View Status

public

Project Name

In-Portal CMS

Assigned To

Developer

Priority

normal

Resolution

open

Fixed in Version

Status

active

Product Version

5.0.2-B1

Target Version

Icebox

Time Estimate

No estimate

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.

Additional Information

Tags

No tags attached.

Reference

http://groups.google.com/group/in-portal-dev/browse_thread/thread/884988084a8f4b41#

Change Log Message

Estimate Points

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

There are no notes attached to this issue.

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

Web Development by Intechnic

In-Portal Open Source CMS