Data Tables Block

From Genesys Documentation
Jump to: navigation, search
This topic is part of the manual Designer User's Guide for version Current of Designer.

Use this block when you want an application to reference one of your data tables.

You can use the Data Tables block in any phase of your application to read values from a Data Table.

Data Table tab

Select a Data Table in the drop-down list. If you want to enable the option to use the data table as a variable, select Use variable. For example, you might select this option if you are using the same application in multiple locations, and each location needs to refer to a data table that is specific to that location.

Once you have selected a Data Table, you can configure the following:

  • Look up by key(s) - For each key in your Data Table, enter a value (or variable, if Variable? is enabled) to use as an input for the Data Table block.
  • Strict comparisons - Select this option to use a stricter form of key matching when performing lookups. If enabled, Designer won't trim or ignore leading zeros in numeric columns or spaces in string columns. This option also prevents type-coercion during lookups; for example, strings won't be able to match numeric keys.
  • Multiple rows output - Select this option if the lookup key is of a date/time range data type, or if the data table contains multiple keys.
  • Store loaded data into these variables - For each column in your Data Table, select a variable to hold the output value of your Data Table block.

Des data table properties 02.png

Results tab

Select a variable to store the outcome status of the lookup (true or false). You can also select a variable to store the number of returned rows.

Des data table block results.png

Retrieved from "https://all.docs.genesys.com/DES/Current/Designer/DataTable (2021-11-30 06:23:46)"