Open topic with navigation

Softdial Scripter™ - Step Library

Script Field Lookup

Performs a lookup on a table and if a unique row is found, sets script variables accordingly.

ClosedInputs

1. Source Table (Mandatory)

The table that data will be selected from. This has to be a table that is accessible via the DSN configured for the campaign.
2. Key Column 1 (Mandatory) The column name for the key column used to select a row.
3. Key Value 1 (Mandatory) The expected value for Key Column 1.
4. Key Column 2 (Optional) The column name for a second key column used to select a row. Only set this if there are multiple predicates required to build the WHERE clause.
5. Key Value 2 (Optional) The expected value for Key Column 2. Only set this if there are multiple predicates required to build the WHERE clause.
6. Key Column 3 (Optional) The column name for a third key column used to select a row. Only set this if there are multiple predicates required to build the WHERE clause.
7. Key Value 3 (Optional) The expected value for Key Column 3. Only set this if there are multiple predicates required to build the WHERE clause.
8. Row Limit (Optional) In the case where the query returns more than one row, the maximum number of rows to return in the result set.

Values:

  • Default - 5
  • Minimum - 1
  • Maximum - 25
9. Lookup Timeout (Optional)

The number of seconds to allow for the query before failing this step for taking too long.

Values (in seconds):

  • Default - 15
  • Minimum - 5
  • Maximum - 60

Script Field Lookup - Inputs

Fig. 1 - Script Field Lookup - Inputs

ClosedOutputs

1. Result Set The results of the query. In case of failure to bind script fields because multiple rows are selected, this contains the rowset that can be presented to the agent for record selection.
2. Result Rows The number of rows in the result set.
3. Error Status For diagnostic purposes only. If executing the query generated an error, the error is reported by the database interface.

Script Field Lookup - Outputs

Fig. 2 - Script Field Lookup - Outputs

ClosedOutcomes

1. Next A unique row was found
2. No record No unique rows were found
3. Many records Many rows were found

Script Field Lookup - Outcomes

Fig. 3 - Script Field Lookup - Outcomes

 

Copyright © 2004 - 2019  Sytel Limited