NewColumnFilterBuilder

The NewColumnFilterBuilder command can be used for an IDEA equation to create an extraction based on a SmartAnalyzer SingleList- or SmartAnalyzer FromToList-control. This makes it easier to write the macro and pass the parameters from the dialog to the macro.

The user can specify the values inside the embedded dialog that is attached to an audit test or a CIR.

If the number of values is so large that the size of the equation exceeds the limit set by IDEA this object will (if necessary) create one or more temporary columns containing partial values of the equation.

The resulting equation will use these temporary columns, so the size of the equation will be shortened.

Compatibility

Available as of IDEA version 11.2

In order to create values, the dialog has to contain one of the following controls:

for single values

SA.Client.CustomControls.SmartSingleList, SA.Client.CustomControls.CirSimpleList

for range/single values

SA.Client.CustomControls.SmartFromToList, SA.Client.CustomControls.CirFromToList

Example:

Set oMC = SmartContext.MacroCommands

Set filterBuilder = oMC.NewColumnFilterBuilder

filterBuilder.ColumnName = "CUSTNO"

filterBuilder.Values = SmartContext.Parameters.Item("smartFromToList1")

or

filterBuilder.Values = SmartContext.Parameters.Item("smartSingleList1")

filterExpression = filterBuilder.Equation

for a SmartFromToList, the filterExpression could be:

(@Match(CUSTNO,"12").OR.((CUSTNO>="122".AND.CUSTNO<="2324").OR.(CUSTNO>="20000".AND.CUSTNO<="22000")))

-------

for a SmartSingleList, the filterExpression could be:

@Match(CUSTNO,"1212","1300","1144","1224","1345")