Filter Expression

The Filter Expression feature of Read Connectors gives users some control over filter conditions sent within the WHERE clause sent to the source system, when the source system is a database that supports SQL syntax.

The Filter Expression is supported in the majority of Read Connectors for relational databases and/or connectors with SQL interfaces.

📘

The syntax of the Filter Expression is dependent on the type of Read Connector and the source database. Consult with your database's SQL documentation for valid Filter Expression syntax.

You do not need to write the word "WHERE" token in the syntax. This will be handled for you in the SQL that Ascend generates to send to the source system. Specify only the conditions you wish to include in the source system's query.

Most ANSI SQL-92 standard syntax is supported across the majority of databases. SQL functions available are expected to differ across source database systems.