Skip to main content
Skip table of contents

Run Query

The Run Query pre-processor can be used to execute a SQL query that can retrieve or insert/update table data.

The Run Query screen is shown below:

image-20260126-234125.png

Stage Settings

The stage settings available are:

image-20260126-234323.png

Provider - Select your desired provider.

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.

Data Query - Select your desired query to execute, placeholders are supported.

Examples:

CODE
INSERT INTO my_table
VALUES ("Hardcoded Value", {{metadata["order_id"]}})
CODE
Select * from my_table where OrderId = {{metadata["order_id"]}}

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.