Create Insert Query (Classic)
This topic describes how to create an Insert query.
Before you begin
About this task
Procedure
- 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 Name 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. - Select Save or Save And Exit.The query is created.