WhereBuilderMethods

Overview

Location


Instance Methods

constructor

Creates a new instance of the WhereBuilderMethods class.

 

constructor(global: GlobalObject)

 

WhereBuilderMethods(GlobalObject global)

 

Sub New(global As GlobalObject)

Parameters:

  • global:

createBetween

Creates a WhereBetween Object (Business Rules Scripting). The value parameter will be compared to lower and upper, it has to be greater or equal to lower, and less than or equal to upper.

 

method createBetween(expression: WhereExpressionWrapper; lower: WhereExpressionWrapper; upper: WhereExpressionWrapper): WhereExpressionWrapper

 

WhereExpressionWrapper createBetween(WhereExpressionWrapper expression, WhereExpressionWrapper lower, WhereExpressionWrapper upper)

 

Function createBetween(expression As WhereExpressionWrapper, lower As WhereExpressionWrapper, upper As WhereExpressionWrapper) As WhereExpressionWrapper

Parameters:

  • expression:
  • lower:
  • upper:

createBinary

Creates a WhereBinary Object (Business Rules Scripting); use this to create a where binary expression, like field = 15.

Possible values of the aOperator parameter are:

  • And
  • Or
  • Xor
  • Less
  • LessOrEqual
  • Greater
  • GreaterOrEqual
  • NotEqual
  • Equal
  • Like
  • In
  • Addition
  • Subtraction
  • Multiply
  • Divide

 

method createBinary(left: Object; right: Object; operator: String): WhereExpressionWrapper

 

WhereExpressionWrapper createBinary(Object left, Object right, String operator)

 

Function createBinary(left As Object, right As Object, operator As String) As WhereExpressionWrapper

Parameters:

  • left:
  • right:
  • operator:

createConstant (Object): WhereExpressionWrapper

Creates a WhereConstant Object (Business Rules Scripting).

 

method createConstant(value: Object): WhereExpressionWrapper

 

WhereExpressionWrapper createConstant(Object value)

 

Function createConstant(value As Object) As WhereExpressionWrapper

Parameters:

  • value:

createConstant (Object, String): WhereExpressionWrapper

Creates a WhereConstant Object (Business Rules Scripting) of required type.

 

method createConstant(value: Object; type: String): WhereExpressionWrapper

 

WhereExpressionWrapper createConstant(Object value, String type)

 

Function createConstant(value As Object, type As String) As WhereExpressionWrapper

Parameters:

  • value:
  • type:

createDateTimeNow

 

method createDateTimeNow: WhereExpressionWrapper

 

WhereExpressionWrapper createDateTimeNow()

 

Function createDateTimeNow() As WhereExpressionWrapper

createDateTimePart

 

method createDateTimePart(value: WhereExpressionWrapper; dateTimePart: String): WhereExpressionWrapper

 

WhereExpressionWrapper createDateTimePart(WhereExpressionWrapper value, String dateTimePart)

 

Function createDateTimePart(value As WhereExpressionWrapper, dateTimePart As String) As WhereExpressionWrapper

Parameters:

  • value:
  • dateTimePart:

createDateTimeToday

 

method createDateTimeToday: WhereExpressionWrapper

 

WhereExpressionWrapper createDateTimeToday()

 

Function createDateTimeToday() As WhereExpressionWrapper

createField (String): WhereExpressionWrapper

Creates a WhereField Object (Business Rules Scripting). This is a reference to a data table field.

 

method createField(field: String): WhereExpressionWrapper

 

WhereExpressionWrapper createField(String field)

 

Function createField(field As String) As WhereExpressionWrapper

Parameters:

  • field:

createField (String, String): WhereExpressionWrapper

Creates a WhereField Object (Business Rules Scripting). This is a reference to a field in the table in the "aTable" parameter.

 

method createField(table: String; field: String): WhereExpressionWrapper

 

WhereExpressionWrapper createField(String table, String field)

 

Function createField(table As String, field As String) As WhereExpressionWrapper

Parameters:

  • table:
  • field:

createFunctionCall

 

method createFunctionCall(value: WhereExpressionWrapper; functionName: String): WhereExpressionWrapper

 

WhereExpressionWrapper createFunctionCall(WhereExpressionWrapper value, String functionName)

 

Function createFunctionCall(value As WhereExpressionWrapper, functionName As String) As WhereExpressionWrapper

Parameters:

  • value:
  • functionName:

createList

Creates a WhereList Object (Business Rules Scripting), lists are used with the IN operator to determine if a value is in a list of others.

 

method createList(params items: array of WhereExpressionWrapper): WhereExpressionWrapper

 

WhereExpressionWrapper createList(params WhereExpressionWrapper[] items)

 

Function createList(ParamArray items As WhereExpressionWrapper()) As WhereExpressionWrapper

Parameters:

  • items:

createMacro

Creates a WhereMacro Object (Business Rules Scripting). See the Macro Processor for more information on macros and when to use them.

 

method createMacro(name: String; params values: array of WhereExpressionWrapper): WhereExpressionWrapper

 

WhereExpressionWrapper createMacro(String name, params WhereExpressionWrapper[] values)

 

Function createMacro(name As String, ParamArray values As WhereExpressionWrapper()) As WhereExpressionWrapper

Parameters:

  • name:
  • values:

createNull

Creates a WhereNull Object (Business Rules Scripting). This represents the SQL "null" construct.

 

method createNull: WhereExpressionWrapper

 

WhereExpressionWrapper createNull()

 

Function createNull() As WhereExpressionWrapper

createParameter

Creates a WhereParameter Object (Business Rules Scripting). Parameters are stored externally and can be used to pass blobs as where expressions.

 

method createParameter(name: String; type: String; size: Int32): WhereExpressionWrapper

 

WhereExpressionWrapper createParameter(String name, String type, Int32 size)

 

Function createParameter(name As String, type As String, size As Int32) As WhereExpressionWrapper

Parameters:

  • name:
  • type:
  • size:

createUnary

Creates a WhereUnary Object (Business Rules Scripting), unary expressions are negations or binary NOT operations.

Possible values of the aOperator parameter are:

  • Not
  • Minus

 

method createUnary(value: WhereExpressionWrapper; operator: String): WhereExpressionWrapper

 

WhereExpressionWrapper createUnary(WhereExpressionWrapper value, String operator)

 

Function createUnary(value As WhereExpressionWrapper, operator As String) As WhereExpressionWrapper

Parameters:

  • value:
  • operator: