Project

General

Profile

« Previous | Next » 

Revision 59019

Added by Alessia Bardi almost 4 years ago

Query updated to ignore funders that are not ready for production, but have been aggregated into production

View differences:

queryProjectOrganization.sql
15 15 
	'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction
16 16 

  		




  17
  17
  
    
FROM project_organization po


  		




  
  18
  
    
WHERE po.project not like 'dfgf%'


  		




  
  19
  
    
AND po.project not like 'innoviris%'


  		




  
  20
  
    
AND po.project not like 'sgov%'


  		




  
  21
  
    
AND po.project not like 'conicytf%'


  		




  
  22
  
    
AND po.project not like 'anr%'


  		




  
  23
  
    
AND po.project not like 'gsrt%'


  		




  
  24
  
    
AND po.project not like 'rif%'


  		




  
  25
  
    
AND po.project not like 'rsf%'


  		




  
  26
  
    
AND po.project not like 'miur%'


  		












Also available in:  Unified diff