Creating Queries

Adding filters

Filter Selection

You can add filters to your query to further refine your search criteria by following these steps:

  1. Select a column from the drop-down list.
  2. Select an operation.
  3. Select a value.
  4. Repeat the process to add more filters. You can select the logical operator AND or OR from the first column to connect your query filters. Use AND if you want data pulled out of the tables only if both sets of criteria are met. Use OR if either or both sets of criteria are met.
    Optionally, you can create more complex filters by selecting parentheses to add to any section of the filter.

Limit Records Processed

You can limit the number of observations that are read from a table by typing the maximum number of records you'd like returned in the Limit records processed to field.

Edit SQL

Users who are proficient in SQL can edit the SQL statement directly by clicking Edit SQL.
Incorrect editing of the SQL statement will result in errors and loss of the query.

Save

If you want to save your query at this point, refer to Saving Queries.

Next

After you select your filters, you can view your query or format your data.