Retrieve the history of a feature since it was included in the product, or at least cycle back through each iteration. The information is similar to what is returned in the History window including tasks/projects etc., that has affected the object.
Input
Parameter | Type | Description |
|---|---|---|
p_productversion_id | NUMBER | The primary key of the product version. |
p_foid | NUMBER | The feature object identifier (FOID) as a number. See FOID Conversion Functions. |
Output
Type | Description |
|---|---|
history_info Pipelined array | Tabular history results. |
Definition of HISTORY_INFO
Name | Type | Description |
|---|---|---|
timestamp | DATE | The time of the edit. |
username | VARCHAR2 | The user that performed the edit. |
project_name | VARCHAR2 | The project that performed the edit. |
taskcomment | VARCHAR2 | Details about the edit. |
rep_id | NUMBER | The spatial version ID. |
rwf_id | NUMBER | The feature version ID. |
project_id | NUMBER | The primary key of the project that performed the edit. |
Example
select username, project_name, taskcomment from TABLE(P_gpeapi.getHistory(:productversion_id, :foid)); order by timestamp; |
Exceptions
• Invalid productversion_id
• Invalid FOID
• The FOID p_foid does not belong to the product version p_productversion_id