details: https://code.openbravo.com/erp/devel/pi/rev/46bcbbcf35c2 changeset: 16562:46bcbbcf35c2 user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Wed May 16 18:47:20 2012 +0200 summary: Fixes issue 20527: Alerts are not moved from New to Solved when status is null
details: https://code.openbravo.com/erp/devel/pi/rev/90cdb77c016b changeset: 16563:90cdb77c016b user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Wed May 16 18:07:34 2012 +0200 summary: Related to issue 20142: do not use status column in ad_alert. Status column in ad_alert table does not exist on 2.50. details: https://code.openbravo.com/erp/devel/pi/rev/5e580de24a96 changeset: 16564:5e580de24a96 user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Wed May 16 18:03:53 2012 +0200 summary: Related to issue 20350: do not use status column in ad_alert. Status column in ad_alert table does not exist on 2.50. diffstat: src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/AccountingTabsData.class | 0 src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DuplicateDocExchangeRateData.class | 0 src-util/buildvalidation/src/org/openbravo/buildvalidation/AccountingTabs_data.xsql | 5 ++--- src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicateDocExchangeRate_data.xsql | 4 ++-- src/org/openbravo/erpCommon/ad_process/AlertProcess_data.xsql | 4 ++-- 5 files changed, 6 insertions(+), 7 deletions(-) diffs (57 lines): diff -r 3075c0f96cd7 -r 5e580de24a96 src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/AccountingTabsData.class Binary file src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/AccountingTabsData.class has changed diff -r 3075c0f96cd7 -r 5e580de24a96 src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DuplicateDocExchangeRateData.class Binary file src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DuplicateDocExchangeRateData.class has changed diff -r 3075c0f96cd7 -r 5e580de24a96 src-util/buildvalidation/src/org/openbravo/buildvalidation/AccountingTabs_data.xsql --- a/src-util/buildvalidation/src/org/openbravo/buildvalidation/AccountingTabs_data.xsql Wed May 16 18:21:14 2012 +0200 +++ b/src-util/buildvalidation/src/org/openbravo/buildvalidation/AccountingTabs_data.xsql Wed May 16 18:03:53 2012 +0200 @@ -130,9 +130,8 @@ <Sql> <![CDATA[ INSERT INTO AD_Alert (AD_Alert_ID, AD_Client_ID, AD_Org_ID, IsActive, - Created, CreatedBy, Updated, UpdatedBy, Description, AD_AlertRule_ID, Record_Id, Referencekey_ID, - status) - VALUES (get_uuid(), '0', '0', 'Y', NOW(), '0', NOW(), '0', ?, ?, ?, ?, 'NEW') + Created, CreatedBy, Updated, UpdatedBy, Description, AD_AlertRule_ID, Record_Id, Referencekey_ID) + VALUES (get_uuid(), '0', '0', 'Y', NOW(), '0', NOW(), '0', ?, ?, ?, ?) ]]> </Sql> <Parameter name="description" /> diff -r 3075c0f96cd7 -r 5e580de24a96 src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicateDocExchangeRate_data.xsql --- a/src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicateDocExchangeRate_data.xsql Wed May 16 18:21:14 2012 +0200 +++ b/src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicateDocExchangeRate_data.xsql Wed May 16 18:03:53 2012 +0200 @@ -129,11 +129,11 @@ INSERT INTO AD_Alert ( AD_Alert_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, - Description, AD_AlertRule_ID, Record_Id, Referencekey_ID, status + Description, AD_AlertRule_ID, Record_Id, Referencekey_ID ) VALUES ( get_uuid(), ?, '0', 'Y', NOW(), '0', NOW(), '0', - ?, ?, ?, ?, 'NEW') + ?, ?, ?, ?) ]]> </Sql> <Parameter name="client"/> diff -r 3075c0f96cd7 -r 5e580de24a96 src/org/openbravo/erpCommon/ad_process/AlertProcess_data.xsql --- a/src/org/openbravo/erpCommon/ad_process/AlertProcess_data.xsql Wed May 16 18:21:14 2012 +0200 +++ b/src/org/openbravo/erpCommon/ad_process/AlertProcess_data.xsql Wed May 16 18:03:53 2012 +0200 @@ -67,7 +67,7 @@ FROM AD_ALERT WHERE AD_ALERTRULE_ID = ? AND REFERENCEKEY_ID = ? - AND STATUS != 'SOLVED' + AND COALESCE(STATUS, 'NEW') != 'SOLVED' ]]></Sql> <Parameter name="alertRule"/> <Parameter name="ref"/> @@ -135,7 +135,7 @@ UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = ? - AND STATUS != 'SOLVED' + AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS (SELECT 1 FROM (SELECT '' AS AD_REFERENCEKEY_ID FROM DUAL) A WHERE 1=1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID) ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
