0014981: new alert: elements of type distinct to "subaccounts" and no summary level

Description

create a new alert to detect the elements value that they are of type distinct to subaccounts and they don't have selected summary level

If an element does not have selected summary level, it can be selected in account combination, and it is error if this element is not of type subaccount

The same if an element is of type subaccount and it has selected the summary level

Proposed Solution

select value, c_elementvalue_id, name, issummary, elementlevel, ad_org_id, c_element_id
from c_elementvalue ev
where ev.issummary='N'
and elementlevel<>'S';

select value, c_elementvalue_id, name, issummary, elementlevel, ad_org_id, c_element_id
from c_elementvalue ev
where ev.issummary='Y'
and elementlevel='S';

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2010-10-22 08:08	networkb	New Issue
2010-10-22 08:08	networkb	Assigned To	=> eduardo_Argal
2011-06-03 11:03	dalsasua	Assigned To	eduardo_Argal => dalsasua
2011-07-20 18:10	dalsasua	Assigned To	dalsasua => jonalegriaesarte