Fixed alert management on Cbpvendoracct build validation.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Wed, 30 Mar 2011 13:38:49 +0200
changeset 11399 94a3373de4b1
parent 11398 ebcc3d5bc6f5
child 11400 46698571afe5
Fixed alert management on Cbpvendoracct build validation.
src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/CbpvendoracctData.class
src-util/buildvalidation/src/org/openbravo/buildvalidation/Cbpvendoracct_data.xsql
Binary file src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/CbpvendoracctData.class has changed
--- 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" />