View feature relations (parent/child, collection, etc.) in an isolated project.
Output
Column | Type | Description |
|---|---|---|
project_id | NUMBER | ID of the project. |
foid1 | NUMBER | The parent feature object identifier (FOID) as a number. See FOID Conversion Functions |
foid2 | NUMBER | The child feature object identifier (FOID) as a number. See FOID Conversion Functions. |
relation | VARCHAR2 | The type of relationship. The types of relationships are defined in the catalogue. The following three types exist by default: • ParentChild • collection • annotation |
time_start | DATE | Timestamp for relationship creation. |
time_end | DATE | Timestamp for relationship termination. |
add_task_id | NUMBER | The ID of the edit where the relation was created. See TASK_VW or more information. |
del_task_id | NUMBER | The ID of the edit where the relation was deleted. NULL for current relationships. See TASK_VW for more information. |
Example
select FoidNumberToString(foid1), FoidNumberToString(foid2), relation, time_start, time_end, project_id from ip_relation_vw where foid1 = FoidStringToNumber('1C 0000000004 00001'); |