Home >	Contents >	Index >

Template Tags TOC   |    Alpha TOC   |    Tag Family TOC   |    Purpose TOC   |    Annotated TOC   |    Index

---

ics:catalogmanager.history

Gets a revision history for rows in a revision-tracked table using ics:catalogmanager.

Syntax

<ics:catalogmanager>
   <ics:argument name="ftcmd" value="history" />
   <ics:argument name="tablename" value="table" />
   <ics:argument name="asset" value="primarykey"/>
   [<ics:argument name="version" value="first|last|#|date"/>]
   [<ics:argument name="locker" value="username1"/>]
   [<ics:argument name="creator" value="username2"/>]
   [<ics:argument name="annotation" value="annotation"/>]
</ics:catalogmanager>   

Parameters

ftcmd (required)

Value must be set to history.

tablename (required)

Name of the tracked table.

asset (required)

Value of the primary key for the row to obtain history.

version (optional)

Possible values are:

first - history of earliest revision of record.

last - history of most recent revision of record.

# - history of a specific revision number.

date - history of the record to whichever revision was current at the specified date. The date must be in SQL format (yyyy-mm-dd hh:mm:ss) and is expected to be GMT.

locker (optional)

Filter rows returned based on a user who has rows locked. If the current user does not have rtaudit privileges, you must specify a value for locker, creator, or both. If you specify only locker, the value must be the current user's name; otherwise, no data is returned.

creator (optional)

Filter rows returned based on the user who created the row. If the current user does not have rtaudit privileges, you must specify a value for locker, creator, or both. If you specify only creator, the value must be the current user's name; otherwise, no data is returned.

annotation (optional)

Filter rows returned based on the annotation of a row.

Description

The history command gets a revision history for rows in a revision-tracked table.

To obtain history for all rows, the current user must have rtaudit privileges for the table. If the current user has read privileges on the table, only history for the revisions which the user has created or locked are returned. Specific versions can be specified by using the optional version parameter. Rows may be filtered using the optional parameters locker and creator. Use the annotation parameter to retrieve rows based on their annotation.

Error Numbers

The possible values of errno include:

Value	Description
-103	No such table.
-104	No table definition.
-105	Database error.

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