This dialog appears when you click edit... on the events tab of the sample list properties dialog. It allows you to construct an SQL query.
Your query is displayed in the SQL Code box, where you can type and edit the text to your satisfaction. The left-hand pane displays the database list, where you can view details of tables, fields and views for use in your query. To toggle this pane, click view database information.
The following options are available:
View Database Information: Toggles the display of the left-hand pane, which contains details (tables and views) of the selected SQL database. This allows you to find table and field names for use in your expression.
Parameters: Select a parameter from the list that you would like to place in your SQL expression, and click insert. Your own field names can be used as parameters; they are available in the ListFields section at the bottom of the drop-down list.
Copy from: If you want to copy the SQL expression associated from another event into your expression, select the events (interview finished, invitation mail sending successful, etc.). You can then edit the copied expression if required.
Test: Tests your SQL expression. If there is a problem with your expression's syntax, a message will appear informing you of the details.