...
The following fields are configured on the Query String tab:
| Field | Description |
|---|---|
| Query String | Query to be processed by the database collector to retrieve data from the database. |
| Anchor | ||||
|---|---|---|---|---|
|
The query string must bring back data in fields with the same name as the stream attributes you wish to populate. So to collect data into a stream with attributes account_number, cust_ref and eventsource from a table with fields account_number, customer_ref and eventsource use the query string:
...