Entering SQL Statements

In the text box at bottom of the Create Data Source from SQL Statement page, enter your SQL statement using the given symbolic names for the tables and using the actual field names from those tables. (SQL Query Analysis)

If you specify a time, be sure to use the following format (those are zeroes at the end): yyyy-mm-dd hh:mi:ss.000

If you specify an SQL statement that includes a "where" clause (such as select * where EMAIL_ like '%Doc%'), the evaluation is case-sensitive. In other words, the query will not return records containing "doc" or "DOC" as in earlier versions of the software.

If you include a time in the SQL statement, be sure to specify it in terms of the server time zone shown below the text area.

Next step – Creating New Lists