Add Query

The Add Query task is different depending on the selected Query Type.

Add Query for Select or Stored Procedure

Clicking Add Query when a Select or Stored Procedure query type is selected opens the Query Properties dialog box.

Query Name

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.

Record Limit

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.

Add Query for Update

Clicking Add Query when an Update query type is selected opens the Query Properties dialog box.

Query Name

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.

Update from Table

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.

Update Type

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.