To create a new selection, click the “Create New Selection” button located in the top right corner of the selections page.
The Create New Selection box requires three pieces of information:
The Selection name.
The Selection table to be used.
The Selection SQL statement.
To name the selection simply click in the “Name your Selection” textbox and enter in the desired name.
To pick the Selection table, click in the “Enter Selection Table” textbox and enter in the name of the table to be used. Once the name has been entered, select it from drop-down that is populated.
The last requirement is the Selection SQL statement. To begin creating the SQL statement click in the “Enter Selection SQL” textbox.
Here you are given a few options to make the writing of the SQL statement easier. In the box to the top right, the table that has been selected will be highlighted while all others have been greyed out. Expanding the table reveals all the fields within that table. Clicking one of the fields will cause it to populate in the Selection SQL textbox.
The ‘add fields’ box also has a search function that will identify any tables or fields that are searched for. Below the add fields box is the common logical operators’ buttons. These are commonly used expression for constructing a Selection SQL statement.
The last section is for common values. Here you will find values that are frequently used in the construction of a SQL statement. When all the fields have been filled in, click the “Submit and Close” button to complete the process.