Home > Contents > Index >
CATALOGMANAGER.history
This tag is DEPRECATED. Please refer to the HISTORY xml tag to get a revision history for rows in a revision tracked table.
If you still need to look up the syntax and description for debugging or whatever reasons, only then use the following description. Otherwise use the <HISTORY> xml tag.
This tag gets a revision history for rows in a revision-tracked table using the
CATALOGMANAGER
command.Syntax
<CATALOGMANAGER> <ARGUMENT NAME="ftcmd" VALUE="history" /> <ARGUMENT NAME="tablename" VALUE="table" /> <ARGUMENT NAME="asset" VALUE="primarykey"/> [<ARGUMENT NAME="version" VALUE="version data"/>] [<ARGUMENT NAME="locker" VALUE="locker data"/>] [<ARGUMENT NAME="creator" VALUE="creator data"/>] [<ARGUMENT NAME="annotation" VALUE="row annotation"/>] </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 is returned. Specific versions can be specified by using the optional version parameter. Rows may be filtered using the optional parameterslocker
andcreator
. Use the optional parameter annotation 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.Example
This example gets the history for the row in
movies
whose primary key value is95137
.<SETVAR NAME="errno" VALUE="0"/> <CATALOGMANAGER> <ARGUMENT NAME="ftcmd" VALUE="history"/> <ARGUMENT NAME="tablename" VALUE="movies" /> <ARGUMENT NAME="asset" VALUE="95137" /> </CATALOGMANAGER> <IF COND="IsError.Variables.errno=true"> <THEN> <!--Handle error--> </THEN> </IF>
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, Oracle and/or its affiliates. All rights reserved.