Revision 57678
Added by Alessia Bardi over 4 years ago
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch_funder_countries.sql | ||
---|---|---|
1 |
update dsm_organizations dor set country = f.jurisdiction from fundingpaths f where f.funder = dor.id ; |
Also available in: Unified diff
Query to patch the missing countries for funders.