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

CDM.GETCOMMERCEDATA

Retrieves rows of data from the specified table.

Syntax

<CDM.GETCOMMERCEDATA 
      TABLENAME="tablename" 
      BEFOREDATE="date" 
      AFTERDATE="date" 
      CDMLIST="listvar"/> 

Parameters

TABLENAME (required)

Input parameter. Name of the table from which to retrieve data.

BEFOREDATE (required)

Input parameter. A date expressed in long format; that is, in milliseconds from the epoch. Retrieves rows created on or before this (end) date.

AFTERDATE (required)

Input parameter. A date expressed in long format, that is, in milliseconds from the epoch. Retrieves rows created since this (start) date.

CDMLIST (required)

Input and output parameter. As input, a variable list name in which to store rows of data from the specified table on output. The list has column names that match the columns of the table being called.

Description

This tag is used in the element OpenMarket/CommerceData/retrieve/GetDataFromTable. A page request to OpenMarket/CommerceData/GetCommerceData&tablename=&from=yyyy-mm-ddhh:mm:ss&thru=yyyy-mm-ddhh:mm:ss, results in a call to CDM.CONVERTDATETOLONG to convert the entered dates to long format; that is, to milliseconds from the epoch. The converted dates are then used as input to the CDM.GETCOMMERCEDATA tag, the from date representing the AFTERDATE value, and the thru date, the BEFOREDATE value. These dates are compared against the last_update (creation date) column in the default tables and in user-defined tables containing this column.

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