Project

General

Profile

« Previous | Next » 

Revision 55131

Added by Alessia Bardi about 5 years ago

distinct PIDs for datasources

View differences:

queryDatasources.sql
1 1 
SELECT
2 2 
	d.id                                                                                                       AS datasourceid,
3 
	d.id || array_agg(di.pid)                                                                                  AS identities,
3 
	d.id || array_agg(distinct di.pid)                                                                         AS identities,
4 4 
	d.officialname                                                                                             AS officialname,
5 5 
	d.englishname                                                                                              AS englishname,
6 6 
	CASE

Also available in: Unified diff