Using Notes Select statement (instead of SQL Select)
If you are uncomfortable with SQL syntax, but are comfortable with the Notes syntax, you could leave the SQL Select Statement section blank and use the Notes formula Select CompanyCity = "Boston" instead of the familiar Select @All.
Examples of Notes Select statement vs SQL Select
We want to select just the records where the CompanyCity is Boston. The following examples will both accomplish the same results:
SQL statement
SELECT * FROM Customers WHERE CompanyCity = "Boston"
Note: You can run both these statements. The Notes Select is redundant, however.
What does the Sentinel do with the records that do not fit the Notes Select Statement?
The Sentinel will discard any data that does not fit the Notes Select statement.
Network Data Traffic Note: Using the Notes statement to Select records will move more data across the network than the SQL Select Statement. The SQL statement is preferred for efficiency, especially with very large data sources.