Run Query

The Run Query pre-processor can be used to insert or update a row of data in a SQL table.

The Run Query screen is shown below:

Stage Settings

The stage settings available are:

Provider - Leave set as SQL

Data Source - Choose the correct one from the list of available data sources. Data sources are usually configured by the EWA Site administrator using the EWA Admin panel Connections menu option.

Target metadata ID - Specify the id of the metadata which the query result will be saved into. If the query doesn't have a result, leave blank.

Saving the Pre-Processor

Press the Apply button to save the pre-processor settings

Saving the RIA Page

Press the Save Button to save the RIA page changes.

 Testing the Pre-Processor

1. Make sure its enabled.

2. Run an input document through the queue.

3. Check that the SQL table row data is being is being inserted/updated in the SQL database.