Project

General

Profile

« Previous | Next » 

Revision 36114

Added by Antonis Lempesis about 9 years ago

sql error....... :(

View differences:

modules/uoa-goldoa-service/trunk/src/main/java/eu/dnetlib/goldoa/service/dao/ProjectDAO.java
38 38 
            "select id, acronym, title, funder, fundingstream, scientificarea, call, \"grant\", startdate, enddate, sc39, url, source, coordinator, array_agg(po.organization) as organizations\n" +
39 39 
                    "from project  p\n" +
40 40 
                    "left join project_organization po on po.project=p.id\n" +
41 
                    "where po.organization=? and p.enddate > now() - (? || ' months')::interval \n" +
41 
                    "where po.organization=? and p.enddate > now() - (? || ' months')::interval and p.enddate < now() \n" +
42 42 
                    "group by id, acronym, title, funder, fundingstream, scientificarea, call, \"grant\", startdate, enddate, sc39, url, source, coordinator ";
43 43 
    private final String GET_FUTURE_PROJECTS_FOR_ORGANIZATION=
44 44 
            "select id, acronym, title, funder, fundingstream, scientificarea, call, \"grant\", startdate, enddate, sc39, url, source, coordinator, array_agg(po.organization) as organizations\n" +

Also available in: Unified diff