Query

Query

In this field, the user will configure a query to return the desired columns from one or more tables.

This field will accept "SELECT FROM" statements and also Stored Procedures.

Example:

Database Configuration:

.     Table name: Test

.     Columns: ID, Name, InitialDate, Status

Query Configuration:

.     SELECT * FROM Test => To return all columns from the Test table

.     SELECT ID, Name FROM Test => Return only the columns ID and Name