Script Process - Revision history

Schnbeck: /* See Also */

2021-02-25T07:31:39Z

CarlosRuiz: add two arguments

2019-05-22T10:03:22Z

add two arguments

CarlosRuiz at 19:14, 23 July 2013

2013-07-23T19:14:26Z

CarlosRuiz at 18:56, 23 July 2013

2013-07-23T18:56:55Z

CarlosRuiz: 13 revisions

2013-07-23T18:54:23Z

13 revisions

Sarafudheen: added breadcrumb for TOC

2010-12-21T06:10:15Z

added breadcrumb for TOC

New page

{{Breadcrumb|next=Process}}
{{Contribution|logo=Qss.jpg|name=[[User:CarlosRuiz|Carlos Ruiz]], Quality Systems & Solutions - QSS Ltda.|url=http://globalqss.com}}
[[Category:Developer documentation]]
[[Category:Features]]
[[Category:Development]]
[[Category:Code snippets]]

Status: working in version > 3.3.1b<br>

== Create the Rule ==

Within the script you can use:
* Login context variables start with G_ prefix
* Process Parameters for the process start with P_ prefix, for example P_Name
* If the parameter is a range then the parameters will be P_Name1 and P_Name2
And the following predefined arguments:
* A_Ctx - the context
* A_Trx - the transaction
* A_TrxName
* A_Record_ID
* A_AD_Client_ID
* A_AD_User_ID
* A_AD_PInstance_ID
* A_Table_ID

[[Image:01_ScriptForProcess.png]]

== Configure the Process ==

[[Image:02_ProcessWithScript.png]]

== 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 (A_Ctx, P_AD_Table_ID, A_TrxName);
if (table.get_ID() == 0)
throw new IllegalArgumentException ("No AD_Table_ID=" + P_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=" + A_AD_Client_ID;
int no = DB.executeUpdate(sql, A_TrxName);
A_ProcessInfo.addLog (0, null, null, "Deleted "+no+" rows from table "+tableName);
result = "OK";

=See Also=
*[[Script Callout]]
*[[Script ModelValidatorLogin]]
*[[Script_ModelValidator]]

CarlosRuiz: new category

2010-08-20T14:15:21Z

new category

CarlosRuiz: see also new page

2008-02-09T21:01:10Z

Red1: /* See Also */

2008-02-08T03:58:05Z

Red1: wikify

2008-02-08T03:56:46Z

wikify

← Older revision		Revision as of 03:56, 8 February 2008
Line 58:		Line 58:
	*[[Script Callout]]		*[[Script Callout]]
	*[[Script ModelValidatorLogin]]		*[[Script ModelValidatorLogin]]
		+
		+	[[Category:Developer documentation]]
		+	[[Category:\|Features]]
		+	[[Category:\|Training]]
		+	[[Category:\|Development]]

@@ Line 54: / Line 54: @@
 *[[Script ModelValidatorLogin]]
 *[[Script_ModelValidator]]
+*[[Rule snippets]]
 [[Category:Development]]
 [[Category:Code snippets]]

@@ Line 14: / Line 14: @@
 * A_AD_PInstance_ID
 * A_Table_ID
 [[Image:01_ScriptForProcess.png]]

@@ Line 24: / Line 24: @@
 On the Report & Process:
-  @script:beanshell:ImportDelete
+  @script:groovy:ImportDelete
 On the Rule Search Key:
-  beanshell:ImportDelete
+  groovy:ImportDelete
 On the Rule Script:

@@ Line 1: / Line 1: @@
 == Create the Rule ==
@@ Line 61: / Line 52: @@
 *[[Script ModelValidatorLogin]]
 *[[Script_ModelValidator]]

← Older revision		Revision as of 14:15, 20 August 2010
Line 63:		Line 63:
	[[Category:Features]]		[[Category:Features]]
	[[Category:Development]]		[[Category:Development]]
		+	[[Category:Code snippets]]

@@ Line 58: / Line 58: @@
 *[[Script Callout]]
 *[[Script ModelValidatorLogin]]
 [[Category:Developer documentation]]
 [[Category:Features]]
 [[Category:Development]]