Overview: Date and Time Data Types Summary This article explains the differences found across the date, date time, and time data types supported by Connect and example use cases for […]

UTCDateTime The UTCDateTime function returns the current system zoned date time aligned to UTC. Syntax UTCDateTime() Return Type Zoned_date_time Details Use the CurDateTime function instead of UTCDateTime if you want the current date […]

UTCDate The UTCDate function returns the current system date aligned to UTC. Syntax UTCDate() Return Type Date Details Use the CurDate function instead of UTCDate if you want the current date relative […]

LookupSplitTotalByOrderCodeItemCode The LookupSplitTotalByOrderCodeItemCode scalar function takes a sales order order_code and item_code as input parameters. It returns the sum of staging.order_item_assignment.split_amount_pct for the given combination. Syntax LookupSplitTotalByOrderCodeItemCode(<string>, <string>) The first […]

LookupOrderStageIdByOrderCodeItemCode The helper lookup function takes string values for order_code and item_code and returns the corresponding xactly.xc_order_stage.order_stage_id if found. Otherwise, the function returns null. Syntax LookupOrderStageIdByOrderCodeItemCode(<string>, <string>) The first parameter […]

LookupPeriodIdByName The LookupPeriodIdByName function returns the period_id for the given period name input parameter. Syntax LookupPeriodIdByName(<string>) Return Type long Details The function returns the xactly.xc_period.period_id for the given period name input parameter. Null […]

LookupPeriodTypeById The LookupPeriodTypeById function returns the xactly.xc_period_type.name value for the corresponding period_type_id given in the input parameter. Syntax LookupPeriodTypeById(<long>) Return Type String Details The function returns null if the period_type_id input parameter is not found in xactly.xc_period_type.period_type_id. Examples eval […]

LookupPeriodTypeByPeriodName The LookupPeriodTypeByPeriodName function returns the xactly.xc_period_type.name value for the corresponding period name given in the input parameter. Syntax LookupPeriodTypeByPeriodName(<string>) Return Type String Details The function returns null if the period name input parameter does not tie to […]

Show Keys The show keys command returns a result set listing any tables that have primary keys defined. Syntax show keys; Return Type Table result set Details Connect allows developers to create […]

Incent Diagnostic The incent diagnostic command returns summary log information for jobs submitted to Incent’s processing queue. Most queue events are submitted from the Incent application, not Connect. The command […]