Skip to main content
Skip table of contents

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:

image-20260126-234125.png

Stage Settings

The stage settings available are:

image-20260126-234323.png

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 image-20260114-021549.png to save the pre-processor settings

Saving the RIA Page

Press the Save Button image-20260114-021648.png 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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.