Project

General

Profile

« Previous | Next » 

Revision 59018

Added by Alessia Bardi almost 4 years ago

exclude projects from BETA funders in the view used by the IIS in production

View differences:

materialised_views.sql
10 10 
	FROM projects p
11 11 
		LEFT OUTER JOIN project_fundingpath pf ON (pf.project = p.id)
12 12 
		LEFT OUTER JOIN fundingpaths fp ON (fp.id = pf.funding)
13 
	WHERE p.collectedfrom <> 'openaire____::dfgf'
14 
	AND p.collectedfrom <> 'openaire____::innoviris'
15 
	AND p.collectedfrom <> 'openaire____::sgov'
16 
	AND p.collectedfrom <> 'openaire____::conicytf'
17 
	AND p.collectedfrom <> 'openaire____::anr'
18 
	AND p.collectedfrom <> 'openaire____::gsrt'
19 
	AND p.collectedfrom <> 'openaire____::rif'
20 
	AND p.collectedfrom <> 'openaire____::rsf'
21 
	AND p.collectedfrom <> 'openaire____::miur'
13 22 
	GROUP BY p.id
14 23 
);
15 24 

  		












Also available in:  Unified diff