The Add Query task is different depending on the selected Query Type.
Clicking Add Query when a Select or Stored Procedure query type is selected opens the Query Properties dialog box.
In Genesys Agent Scripting, queries can be nested. In other words, you can create a single query that returns rows from one table. For each row, you can have a nested query that returns rows from another table and so on. To join a nested query, you may need to reference values from a higher-level query. In that case, the query name will be used to identify the query. Query names cannot contain spaces.
If a stored procedure query type is selected, then the Query Name must be the name of the stored procedure.
This option allows you to limit the number of records that the query returns. If the limit is 0, all records will be displayed. It is available for select and stored procedure queries.
Clicking Add Query when an Update query type is selected opens the Query Properties dialog box.
In Genesys Agent Scripting, queries can be nested. In other words, you can create a single query that returns rows from one table. For each row, you can have a nested query that returns rows from another table and so on. To join a nested query, you may need to reference values from a higher-level query. In that case, the query name will be used to identify the query. Query names cannot contain spaces.
If a stored procedure query type is selected, then the Query Name property must be the name of the stored procedure defined in the database.
This option indicates that values for the query will come from a table. When this option is selected a Field drop-down list becomes active.
Use the Field drop-down list to indicate the table that will be used for this update. Each row in a table has a built in indicator managed by Genesys Agent Scripting that will structure the query for Inserts, Updates, and Deletes based on the actions of the users.
If the Update from Table box is not checked, you must select an update type for this query. The valid choices are Update, Insert, or Delete.