Home > Contents > 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, 2015, Oracle and/or its affiliates. All rights reserved.