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 forlocker
,creator
, or both. If you specify onlylocker
, 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 forlocker
,creator
, or both. If you specify onlycreator
, 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 parameterslocker
andcreator
. Use theannotation
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, 2016, Oracle and/or its affiliates. All rights reserved.