Project

General

Profile

« Previous | Next » 

Revision 62012

Added by Michele Artini about 2 years ago

new fields in repo ui: fulltextdownload and consenttermsofuse

View differences:

searchApisUsingField.sql
13 13 
	ds.namespaceprefix                                                       AS "prefix",
14 14 
	ds.websiteurl                                                            AS "websiteUrl",
15 15 
	coalesce((array_agg(o.country))[1], '-')                                 AS "country",
16 
    (array_agg(o.legalname))[1]                                              AS "organization"
16 
    (array_agg(o.legalname))[1]                                              AS "organization",
17 
    ds.consenttermsofuse                                                     AS "consenttermsofuse",
18 
    ds.fulltextdownload                                                      AS "fulltextdownload"
17 19 
FROM dsm_api a
18 20 
	LEFT OUTER JOIN dsm_services ds ON (a.service = ds.id)
19 21 
	LEFT OUTER JOIN dsm_service_organization dsorg ON (ds.id = dsorg.service)
......
33 35 
	ds.officialname,
34 36 
	ds.englishname,
35 37 
	ds.namespaceprefix,
36 
	ds.websiteurl
38 
	ds.websiteurl,
39 
	ds.consenttermsofuse,
40 
    ds.fulltextdownload
37 41 
) AS t WHERE

Also available in: Unified diff