Project

General

Profile

« Previous | Next » 

Revision 57353

Added by Claudio Atzori over 4 years ago

added summary, totalcost and fundedamount to the projects_mv materialized view

View differences:

modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/materialised_views.sql
120 120 
		p.contactfax                                                                                               AS contactfax,
121 121 
		p.contactphone                                                                                             AS contactphone,
122 122 
		p.contactemail                                                                                             AS contactemail,
123 
		p.summary                                                                                                  AS summary,
124 
		p.currency                                                                                                 AS currency,
125 
		p.totalcost                                                                                                AS totalcost,
126 
        p.fundedamount                                                                                             AS fundedamount,
123 127 
		dc.id                                                                                                      AS collectedfromid,
124 128 
		dc.officialname                                                                                            AS collectedfromname,
125 129 
		p.contracttype || '@@@' || p.contracttypename || '@@@' || p.contracttypescheme || '@@@' || p.contracttypescheme     AS contracttype,
......
169 173 
		p.contactphone,
170 174 
		p.contactemail,
171 175 
		p.contracttype,
176 
		p.summary,
177 
		p.currency,
178 
		p.totalcost,
179 
		p.fundedamount,
172 180 
		dc.id,
173 181 
		dc.officialname,
174 182 
		pac.code, pac.name, pas.code, pas.name

Also available in: Unified diff