Input values

Field Description
OUT

Optional for XML Data Server requests.

Specify CSV (comma-separated values format) or XML output.

The default value is XML.
TOTAL

The type of totaling. Valid values are SUM and AVERAGE.

The default value is SUM.
PERIOD

Specify the type of period to use for totaling. A fixed number of periods is returned, depending on the parameter specified:

  • DAILY returns 7 periods.

  • WEEKLY returns 13 periods.

  • MONTHLY returns 13 periods

  • QUARTERLY returns 12 periods

  • YEARLY returns 5 periods.

The default value is DAILY.
DATEFIELD

Required for a totaling query.

The field used in period totaling.

PERIODEND

Required for a totaling query.

The ending date of the period.
OTMMAX

The maximum number of one-to-many related records to return. The default value is 25.

There is no absolute maximum set; however queries with a large OTMMAX value may result in errors.
XCOLS

A TRUE/FALSE flag for displaying column/field data.

The default value is TRUE.
XCOUNT

A TRUE/FALSE flag for displaying count of total number of records to which a user has access, depending on security.

The default value is FALSE

XIDA

A TRUE/FALSE flag for displaying integrated IDA calls references.

The default value is TRUE.
XKEYS

A TRUE/FALSE flag for displaying integrated key values.

The default value is TRUE.
XNEXT

A TRUE/FALSE flag for displaying integrated related data calls.

The default value is TRUE.
XRELS

A TRUE/FALSE flag for displaying integrated related drills.

The default value is TRUE.