Script Process

Status: working in version > 3.3.1b

Contributed by:
Quality Systems & Solutions - QSS Ltda.
Carlos Ruiz

Create the Rule

Within the script you can use:

• Login context variables start with two underscores __
• Parameters for the process start with three underscores ___, for example ___Name
• If the parameter is a range then the parameters will be ___Name1 and ___Name2

And the following predefined:

• • ___Ctx - the context
  • ___Trx - the transaction
  • ___TrxName
  • ___Record_ID
  • ___AD_Client_ID
  • ___AD_User_ID
  • ___AD_PInstance_ID
  • ___Table_ID

Configure the Process

Code provided for copy/paste testing

On the Report & Process:

@script:beanshell:ImportDelete

On the Rule Search Key:

beanshell:ImportDelete

On the Rule Script:

import org.compiere.model.MTable;
import org.compiere.util.DB;
import org.compiere.util.Msg;

/* get Table Info */
MTable table = new MTable (___Ctx, ___AD_Table_ID, ___TrxName);
if (table.get_ID() == 0)
    throw new IllegalArgumentException ("No AD_Table_ID=" + ___AD_Table_ID);
String tableName = table.getTableName();
if (!tableName.startsWith("I"))
    throw new IllegalArgumentException ("Not an import table = " + tableName);

/* Delete */
String sql = "DELETE FROM " + tableName + " WHERE AD_Client_ID=" + ___AD_Client_ID;
int no = DB.executeUpdate(sql, ___TrxName);
___ProcessInfo.addLog (0, null, null, "Deleted "+no+" rows from table "+tableName);
result = "OK";