Catalogue of Life Partnership Datasets

11551
Reporter: fmendez
Assignee: mdoering
Type: SubTask
Summary: Catalogue of Life Partnership Datasets
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2012-07-10 16:59:54.505
Updated: 2013-12-16 17:50:22.037
Resolved: 2012-10-08 15:45:34.664
        
Description: Can we group those dataset under a technical installation of a new type?
Those datset can be retrieved by running the quuery at mogo.registry_uat db
SELECT ar.from_agent_id,a.* FROM agent a
LEFT OUTER JOIN service s ON s.agent_id = a.id AND s.deleted IS NULL
JOIN agent_relation ar ON ar.to_agent_id = a.id AND ar.deleted IS NULL
WHERE a.type = 14020 AND a.deleted IS NULL AND s.id IS NULL AND a.category = 18010 AND ar.from_agent_id = 1639]]>
    

Author: mdoering@gbif.org
Created: 2012-07-10 22:08:22.556
Updated: 2012-07-10 22:08:22.556
        
I haven't run that query yet, but all the datasets for that organisation listed here:
http://gbrds.gbif.org/browse/agent?uuid=f4ce3c03-7b38-445e-86e6-5f6b04b649d4

are constituents of dataset "The catalogue of life":
http://gbrds.gbif.org/browse/agent?uuid=7ddf754f-d193-4cc9-b351-99906754a03b

And all the services can simply be linked to the same technical http installation.