Retrieve the history of a feature since it was included in the product, or at least cycle back through each iteration. This information is similar to what is returned in the History window including tasks/projects etc., that has affected the object.
Input
Parameter | Type | Description |
|---|---|---|
panelver_id | NUMBER | Primary key of the panel version. |
foid | NUMBER | Feature object identifier (FOID) as a number. See FOID Conversion Functions. |
Output
Type | Description |
|---|---|
history_info | Tabular history info (see definition below). |
Definition of HISTORY_INFO
Name | Type | Description |
|---|---|---|
timestamp | DATE | Time of the edit. |
username | VARCHAR2 | User that performed the edit. |
project_name | VARCHAR2 | Project that performed the edit. |
taskcomment | VARCHAR2 | Details about the edit. |
rep_id | NUMBER | Spatial version ID. |
rwf_id | NUMBER | Feature version ID. |
project_id | NUMBER | Primary key of the project that performed the edit. |
Example
select username, project_name, taskcomment from TABLE(P_pprapi.getHistory(:panelver_id, :foid)) order by timestamp; |
Exceptions
• Invalid panel version.
• Invalid FOID.
• The FOID p_foid does not belong to the Panel Version p_panelver_id.