Retrieve the history of a feature since it was included in the product, or at least cycle back through each iteration. Similar to what is returned in the History window — tasks/projects etc., that have 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 FoidNumberToString. |
Output
Parameter | 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_encapi.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