Jump to: navigation, search

Query Language for Database Capture Point

Interaction Properties

Setting and Getting Interaction Properties and their Data
Interaction property Can be provided in submit Can be updated by source update query Input data type Output data type
InteractionId Y N Varchar Varchar(256)
ExternalId Y Y Varchar Varchar(256)
ParentID Y Y Varchar Varchar(256)
MediaType Y N Varchar Varchar(256)
InteractionType Y N Varchar Varchar(256)
InteractionSubtype Y N Varchar Varchar(256)
TenantId Y N Varchar or Int Int
Queue Y Y Varchar Varchar(256)
Workbin Y N Varchar Varchar(256)
WorkbinAgentId Y N Varchar Varchar(256)
WorkbinPlaceId Y N Varchar Varchar(256)
WorkbinAgentGroupId Y N Varchar Varchar(256)
WorkbinPlaceGroupId Y N Varchar Varchar(256)
IsOnline Y N Varchar or Int Int
ReceivedAt Y N Datetime Varchar(256)
SubmittedBy N N Not applicable Varchar(256)
State N N Not applicable Int
IsLocked N N Not applicable Int
SubmittedAt N N Not applicable Varchar(256)
DeliveredAt N N Not applicable Varchar(256)
SubmittedToRouterAt N N Not applicable Varchar(256)
PlacedInQueueAt N N Not applicable Varchar(256)
MovedToQueueAt N N Not applicable Varchar(256)
AbandonedAt N N Not applicable Varchar(256)
IsHeld N N Not applicable Int
HeldAt N N Not applicable Varchar(256)
AssignedAt N N Not applicable Varchar(256)
AssignedTo N N Not applicable Varchar(256)
CompletedAt N N Not applicable Varchar(256)

Special Column Names and Data Keys

Refer to the following table for special column names or data keys.

Special Column Names & Data Keys
Special column names or data keys Can be provided in submit Can be updated by source update query Input data type Output data type
Hold Y Y (but should not) Int or Varchar
ErrorCode Y (but should not) Y (but should not) Not applicable Int
ErrorDescription Y (but should not) Y (but should not) Not applicable Varchar(256)
EventTime N N Not applicable Varchar(256) available to notification queries only
ActorType N N Not applicable Int
ActorMediaServerId N N Not applicable Varchar(256)
ActorStrategyId N N Not applicable Varchar(256)
ActorRouterId N N Not applicable Varchar(256)
ActorTenantId N N Not applicable Int
ActorPlaceId N N Not applicable Varchar(256)
ActorAgentId N N Not applicable Varchar(256)
ReasonSystemName N N Not applicable Varchar(256)
ReasonDescription N N Not applicable Varchar(256)
Operation N N Not applicable Int
ItxServerName N N Not applicable Varchar(256)
ItxServerDBID N N Not applicable Int
_TenantsNames_ N N Not applicable Varchar(256)
_TenantsDBIDs_ N N Not applicable Varchar(256)
ReportingEventSequenceNumber N N Not applicable Varchar(256), available to notification queries only

User Data

All other column names not corresponding to interaction properties, special column names, or data keys are interpreted as user data keys.

Data Types

The tables above refer to data types Datetime, Int, and Varchar. More formally, these data types are defined for each DBMS as follows:

Data Types Defined Per DBMS
DBMS Int Types Datetime Types Varchar Types
Oracle int, integer, smallint date, timestamp varchar2
DB2 numeric, decimal, smallint timestamp varchar, char
MSSQL numeric, decimal, smallint, money, smallmoney datetime, datetime2 varchar
Important
The values in columns of Datetime type are converted and attached to their corresponding keys as strings, therefore their values are available as Varchar type for output parameters. If they need to be inserted into actual datetime columns, either casting or conversion should be performed.
This page was last edited on June 18, 2020, at 10:43.
Comments or questions about this documentation? Contact us for support!