Home > Contents > Index >
Expanded TOC   |    Accordion TOC   |    Annotated TOC   |    Index

 

ICS.RTHistory

Gets revision history for rows in a revision-tracked table.

Syntax

Parameters

sTable
Name of the tracked table.

sAsset
Value of the primary key for the row whose history to retrieve.

sVersion
String version number, "first", "last", or a date (in the format of "YYYY-MM-DD HH:MM:SS"). "first" or "last" return the first or last revisions, while a date will return the revision that was or is current as of the specified date.

sLocker
Filters the rows returned based on a user who has rows locked. If the current user does not have rtaudit privileges, it is necessary to specify a value for LOCKER, CREATOR, or both. If only LOCKER is specified, the value must be the current user name; otherwise, no data will be returned.

sCreator
Filters the rows returned based on the user who created the row. If the current user does not have rtaudit privileges, it is necessary to specify a value for LOCKER, CREATOR, or both. If only CREATOR is specified, the value must be the current user name; otherwise, no data will be returned.

sAnnotation
Filters the rows returned based on the annotation of a row.

sListName
Name of the list.

Description

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

To obtain history for all rows, the current user must have rtaudit privileges on the table. If the current user has read privileges on the table, only history on the revisions that the user has created or locked will be returned.

Returns

List containing the returned results.

 

  Home > Contents > Index >

Oracle JAVA Reference
Copyright (c) 2013, 2019, Oracle and/or its affiliates. All rights reserved.