title | description | ms.author | ms.date | ms.topic | author | ms.reviewer |
---|---|---|---|---|---|---|
DataTransfer.AddSourceFilter(Integer, Text [, Any,...]) Method |
Adds a filter for the source table for the data transfer. |
solsen |
05/14/2024 |
reference |
SusanneWindfeldPedersen |
solsen |
Version: Available or changed with runtime version 10.0.
Adds a filter for the source table for the data transfer.
DataTransfer.AddSourceFilter(SourceField: Integer, String: Text [, Value: Any,...])
DataTransfer
Type: DataTransfer
An instance of the DataTransfer data type.
SourceField
Type: Integer
The field in the source table to filter on.
String
Type: Text
The filter expression. A valid expression consists of alphanumeric characters and one or more of the following operators: <, >, \, &, |, and =. You can use replacement fields (%1, %2, and so on) to insert values at runtime.
[Optional] Value
Type: Any
Replacement values to insert in replacement fields in the filter expression. The data type of Value must match the data type of Field.
[!INCLUDEdata-transfer]
Use this method when copy data in rows or fields from one table to another table. For more information, see Transferring Data Bewteen Tables.
[!INCLUDEdata-transfer-example]
DataTransfer Data Type
Getting Started with AL
Developing Extensions