Datasets not associated to a technical installation

11499
Reporter: fmendez
Type: Bug
Summary: Datasets not associated to a technical installation
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2012-06-26 15:26:30.3
Updated: 2013-12-16 17:50:55.418
Resolved: 2012-06-29 15:49:41.945
        
Description: This list can be retrieved using:
SELECT a.id,s.service_type_id FROM agent a
JOIN service s ON s.agent_id = a.id AND s.deleted IS NULL
WHERE a.type = 14020 AND a.deleted IS NULL
AND a.id NOT IN (SELECT ar.to_agent_id FROM agent_relation ar
                 JOIN agent owner ON ar.from_agent_id = owner.id AND owner.type =14100
                 WHERE ar.deleted IS NULL AND ar.relation_type_id = 15020)
ORDER BY s.service_type_id DESC

In the list we have: TAPIR, DWcA, BioCASE and few records of other endpoint types.]]>