Cisco Cisco Customer Voice Portal 8.0(1)

An aggregation function lastperiod(datetime, Period) is supported. Period can be: 15, 30, 60,

DD or WW. This will convert the datetime into the date and time at which the current period

started. Hence:

Lastperiod(2009-10-14 12:46:56,15) returns 2009-10-14 12:45:00

Lastperiod(2009-10-14 12:46:56, 30) returns 2009-10-14 12:30:00

Lastperiod(2009-10-14 12:46:56, 60) returns 2009-10-14 12:00:00

Lastperiod(2009-10-14 12:46:56, DD) returns 2009-10-14 00:00:00

Lastperiod(2009-10-14 12:46:56, WW) returns 2009-10-11 00:00:00 (Sunday)

Intervals

An Interval is a span of time and can be specified as n UNITS period where period can be:

•

YEAR

•

MONTH

•

DAY

•

HOUR

•

MINUTE

•

SECOND

A database query with an interval must be sent in the above format. When returned from the

database, the interval will look like a datetime (YYYY-MM-DD HH:MM:SS.FFF). The

components that are returned depend on the interval definition. It is unlikely that a DAY

component will be returned from Unified CVP intervals; instead, expect a format like

HH:MM:SS.FFF.

For a full discussion of Informix, refer to the 

(http://www-01.ibm.com/software/data/informix/pubs/library/ids_100.html).

Informix, Operating System Time, and Local Time

SIP Calls

 along with VXML calls.

They can be distinguished from VXML calls with the CallTypeID column. (Contains "4". Refer

to the CallTypeRef table, where 4 is a SIP call.)

Reporting Guide for Cisco Unified Customer Voice Portal Release 8.0(1)