Using queries to select data
You can use a query to identify contacts from your databases or flat files when you
configure a Select, Segment, or Extract process in a flowchart. There are several different
query methods.
Creating queries with Point & Click
These instructions explain how to create a query using
the default Point & Click method in
a process configuration dialog. You can also follow these instructions
to edit a query. Selecting a new item from the Select Based
On list removes the existing query.
Creating queries with Text Builder
These instructions explain how to create a query using the Text Builder feature in a
process configuration dialog. To edit an existing query, edit the text of the query directly in
the query text box, after clicking the Text Builder button.
Creating queries with Formula Helper
These instructions explain how to use the Formula Helper to build a query in a process
configuration dialog. Use the Fomula Helper to select macros and functions from pre-defined lists.
Use the supplied buttons to insert operators and punctuation.
Creating raw SQL queries
Experienced SQL users can write their own SQL queries or copy and paste SQL queries from
other applications. Writing raw SQL is an advanced operation; users are responsible for correct
syntax and query results.