details:   /erp/devel/pi/rev/94a3373de4b1
changeset: 11399:94a3373de4b1
user:      Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date:      Wed Mar 30 13:38:49 2011 +0200
summary:   Fixed alert management on Cbpvendoracct build validation.

diffstat:

 
src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/CbpvendoracctData.class
 |    0 
 
src-util/buildvalidation/src/org/openbravo/buildvalidation/Cbpvendoracct_data.xsql
           |    7 ++++---
 2 files changed, 4 insertions(+), 3 deletions(-)

diffs (26 lines):

diff -r ebcc3d5bc6f5 -r 94a3373de4b1 
src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/CbpvendoracctData.class
Binary file 
src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/CbpvendoracctData.class
 has changed
diff -r ebcc3d5bc6f5 -r 94a3373de4b1 
src-util/buildvalidation/src/org/openbravo/buildvalidation/Cbpvendoracct_data.xsql
--- 
a/src-util/buildvalidation/src/org/openbravo/buildvalidation/Cbpvendoracct_data.xsql
        Wed Mar 30 12:29:32 2011 +0200
+++ 
b/src-util/buildvalidation/src/org/openbravo/buildvalidation/Cbpvendoracct_data.xsql
        Wed Mar 30 13:38:49 2011 +0200
@@ -58,7 +58,7 @@
             FROM AD_ALERT
            WHERE AD_ALERTRULE_ID = ?
              AND REFERENCEKEY_ID = ?
-             AND ISACTIVE = 'Y'
+             AND STATUS != 'SOLVED'
       ]]></Sql>
       <Parameter name="alertRule"/>
       <Parameter name="ref"/>      
@@ -115,8 +115,9 @@
        <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)
-               VALUES (get_uuid(), '0', '0', 'Y', NOW(), '0', NOW(), '0', ?, 
?, ?, ?)
+                      Created, CreatedBy, Updated, UpdatedBy, Description, 
AD_AlertRule_ID, Record_Id, Referencekey_ID,
+                      status)
+               VALUES (get_uuid(), '0', '0', 'Y', NOW(), '0', NOW(), '0', ?, 
?, ?, ?, 'NEW')
       ]]>
        </Sql>
        <Parameter name="description" />

------------------------------------------------------------------------------
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software 
be a part of the solution? Download the Intel(R) Manageability Checker 
today! http://p.sf.net/sfu/intel-dev2devmar
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to