Project

General

Profile

« Previous | Next » 

Revision 61861

Added by Michele Artini over 2 years ago

new dsm_services table

View differences:

searchApisUsingField.sql
15 15 
	coalesce((array_agg(o.country))[1], '-')                                 AS "country",
16 16 
    (array_agg(o.legalname))[1]                                              AS "organization"
17 17 
FROM dsm_api a
18 
	LEFT OUTER JOIN dsm_datasources ds ON (a.datasource = ds.id)
18 
	LEFT OUTER JOIN dsm_services ds ON (a.service = ds.id)
19 19 
	LEFT OUTER JOIN dsm_datasource_organization dsorg ON (ds.id = dsorg.datasource)
20 20 
	LEFT OUTER JOIN dsm_organizations o ON (dsorg.organization = o.id)
21 21 
GROUP BY

Also available in: Unified diff