Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   Index

VDM.GETHISTORYSUM

Sums the entries in a specific field for the specified history type.

Syntax

<VDM.GETHISTORYSUM
      ATTRIBUTE="attribute"
      FIELD="fieldname"
      VARNAME="varname"
      [STARTDATE="date1"]
      [ENDDATE="date2"]
      [LIST="constraints"]/>

Parameters

ATTRIBUTE (required)

Input parameter. Name of a history type or name of an external history vector (that is, a vector of history data stored in the Transact database).

FIELD (required)

Input and output parameter. Name of the history attribute in the history type, or the vector attribute in the external history vector to add.

VARNAME (required)

Input and output parameter. As input, name of a variable to create on output to hold the sum.

STARTDATE (optional)

Input parameter. Start date, in milliseconds from epoch.

ENDDATE (optional)

Input parameter. End date, in milliseconds from epoch.

LIST (optional)

Input parameter. Name of a list of values to use to constrain the sum. The list has two columns:

• field - Name of an individual history attribute.
• value - Corresponding value for the history attribute.

Use this argument if you want to sum only the instances of this record that match specific criteria. There might be more than one row for the same field.

Description

You can use this tag to add the amount of money a visitor spent during a period of time.

		Home >	Contents >	Index >
	Oracle XML Tag Reference Copyright (c) 2013, 2019, Oracle and/or its affiliates. All rights reserved.