View feature relationships (parent/child, collection, etc.) in an HPD source.
Output
Column | Type | Description |
|---|---|---|
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 |
add_task_id | NUMBER | The ID of the edit where the relation was created. See TASK_VW for 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
-- Find current relationships select sv.foid1, sv.foid2, sv.relation, e.project_id, e.timestamp start_time from source_relation_vw sv, task_vw e where sv.add_task_id = e.task_id and sv.foid1 = FoidStringToNumber('1C 0000000001 00001') and sv.del_task_id is NULL; -- current data only |