Example: Query call to the Rules Engine and loop through result

Here is an example of a PowerShell script which uses the $USEngine object to execute a database query and then loops through the returning recordset:

INVOKE USPowershell.ExecuteScript

WITH

SELECT '$USEngine.ExecuteSQLQuery("select domain_name, f_total_length from t_domain") | foreach {

"The first column is of type " + $_[0].GetType() + " and has the value " + $_[0]

"The second column is of type " + $_[1].GetType() + " and has the value " + $_[1]

The first column is of type string and has the value TW_YESNO

The second column is of type decimal and has the value 1

The first column is of type string and has the value TWI_CHAR_30_UP

The second column is of type decimal and has the value 30

The first column is of type string and has the value TWI_DEFAULT_CHAR

The second column is of type decimal and has the value 8

The first column is of type string and has the value TWI_INT_1

The second column is of type decimal and has the value 1

The first column is of type string and has the value TWI_INT_2

The second column is of type decimal and has the value 2

The first column is of type string and has the value TWI_INT_4

The second column is of type decimal and has the value 4

The first column is of type string and has the value TWI_INT_8

The second column is of type decimal and has the value 8