Create an Insert Query

About this task

This topic describes how to create an Insert query. You can also copy a query.

In the main navigation menu, select QUERIES.
The QUERIES workspace appears.
Select Add new query.
The Create Query window appears.
In the Query name box, enter a name, and then select Create. The name must contain at least one uppercase or lowercase letter.
The available options for creating the query appear.
In the Description box, enter a value.
In the Query Type box, select Insert.
In the Entity box, select an entity in which you want to insert results.
The Set Data section appears.

In the Set Data section, select Add, and then enter or select values as described in the following table.

Field	Description
Entity field	Select the entity field whose values you want to insert using the query.
Value	Select one of the following values: Input field: Select this value if you want to insert values specified by application users, and then enter a name in the Input Data Name box. Add an input control for the field in the application and map it to the input field in the query. Fixed value: Select this value if you want to insert a fixed value, and then enter the value in the Name box.
Input Data Name	This field appears only if you select Input field in the Value box. Enter the name of the field that you will add in the application. Application users can then provide the value by accessing the application.
Name	This field appears only if you select Fixed value in the Value box. Enter the value that you want to insert using the query.