rsCopyFiltered

This function copies only selected rows from one ResultSet to create another ResultSet. Any prior ResultSet with name rsNameTarget will be replaced. The rows are selected by testing each row's value of filterField using a test against the pattern in filterPattern. The pattern match is the same as used in the Idoc script like operator.

Type and Usage

Parameters

Takes four parameters:

  • The first parameter is the ResultSet that is providing the rows to copy.

  • The second parameter is the new ResultSet created by the copy.

  • The third parameter is the name of the field being tested.

  • The fourth parameter is the pattern match to apply to see if the row should be copied.

Output

  • Returns TRUE if the function is successful.

  • Returns FALSE if the function fails.

Example

<$rsCopyFiltered(rsNameSource, rsNameTarget, filterField, filterPattern)$>