Project

General

Profile

« Previous | Next » 

Revision 42557

Added by Antonis Lempesis over 8 years ago

fixed an sql typo

View differences:

modules/uoa-goldoa-service/trunk/src/main/java/eu/dnetlib/goldoa/service/dao/PublicationDAO.java
36 36 
					"left join publication_affiliation pa on pa.publication=p.id\n" +
37 37 
					"left join publication_identifier i on i.publication = p.id\n" +
38 38 
					"where p.id=?\n" +
39 
					"group by p.id, title, languages, subjects, doi, source, date, p.type, journal, publisher, repository, acceptancedate, alternativetitle, alternativedoi, license;";
39 
					"group by p.id, title, languages, subjects, doi, source, date, p.type, journal, publisher, repository, acceptancedate, alternativetitle, alternativedoi, license, eventdetails;";
40 40 

  		




  41
  41
  
    
	private static final String INSERT_PUBLICATION_AFFILIATIONS =


  		




  42
  42
  
    
			"with aff as (insert into affiliation (id, person, organization, startdate, enddate, department) values (?, ?, ?, ?, ?, ?) returning id as affid) insert into publication_affiliation (publication, affiliation) select ?, affid from aff";


  		












Also available in:  Unified diff