D-Net

            List<Claim> claims = null;

            List<String> types= new ArrayList<String>();

//            types.add(ClaimUtils.CONTEXT);

            types.add(ClaimUtils.PUBLICATION);

//          Claim claim = fetchClaimHandler.fetchClaimById("5821");

//          System.out.println(fetchClaimHandler.claim2JSON(claim) );

//          System.out.println("ALL:"+fetchClaimHandler.countClaimsByUser("argirok@di.uoa.gr","EGI", types));

//            System.out.println("ALL:"+fetchClaimHandler.countClaimsByProject("corda_______::ab9c77ce02967b24fc9c1a74276e4677",null,types));

//        System.out.println("ALL:"+fetchClaimHandler.countAllClaims("", types));

    }

    private  String addFilterByType( List<String> types, ArrayList<Object> params) {

            return null;

        }else if (types.contains(ClaimUtils.PUBLICATION) && types.contains(ClaimUtils.DATASET) && types.contains(ClaimUtils.SOFTWARE) && types.contains(ClaimUtils.PROJECT) && types.contains(ClaimUtils.CONTEXT) ){

            //it's all types - no need to filter

        String clause = "source.openaire_id =?";

        ArrayList<Object> clauseParams = new ArrayList<>();

        clauseParams.add(projectId);

        String query = " select * from ("+" select * from ( " + generateSelectclaimQuery(ClaimUtils.PROJECT, ClaimUtils.PUBLICATION, limit, offset, orderBy, desc, clause, clauseParams, keyword, params) + " ) as claim  "+

                ") as claim ";

                return query;

    }

/*

        String clause=  "claim.source_id like ?";

        ArrayList<Object> clauseParams = new ArrayList<>();

        clauseParams.add(contextId+'%');

        String query = " select * from ("+" ( " +generateSelectclaimQuery(ClaimUtils.CONTEXT,ClaimUtils.PUBLICATION,limit, offset, orderBy,desc,clause,clauseParams, keyword, params)+")"+

        return query;

    }

    public  String generateFetchClaimsByFunder(String funderId, Integer limit, Integer offset,String keyword, String orderBy, boolean desc, List<String> types, ArrayList<Object> params) {

        String whereClause = "source_id =source.openaire_id ";

        ArrayList<Object> whereParams = new ArrayList<>();

        String query = " select * from ("+" ( " +generateSelectclaimQuery(ClaimUtils.PROJECT,ClaimUtils.PUBLICATION, limit, offset, orderBy,desc,whereClause,whereParams, keyword, params)+" )"+

                ") as claim ";

        return query;

    }

    public  String generateFetchClaimsByResult(String resultId,  Integer limit, Integer offset, String keyword, String orderBy, boolean desc, List<String> types, ArrayList<Object> params) {

        ArrayList<Object> whereParams = new ArrayList<>();

         whereParams.add(resultId);

         whereParams.add(resultId);

        String query =  " select * from ("+" ( " +generateSelectclaimQuery(ClaimUtils.PUBLICATION,ClaimUtils.PUBLICATION, limit, offset, orderBy,desc,queryWhereClause,whereParams, keyword, params)+" ) \nunion "+

                " ( " +generateSelectclaimQuery(ClaimUtils.PROJECT,ClaimUtils.PUBLICATION, limit, offset, orderBy,desc,queryWhereClause,whereParams, keyword, params)+" ) \nunion "+

                " ( " +generateSelectclaimQuery(ClaimUtils.CONTEXT,ClaimUtils.PUBLICATION, limit, offset, orderBy,desc,queryWhereClause,whereParams, keyword, params)+" ) "+

                ") as claim ";

        return query;

    }

	 * @throws SQLException

	 */

	public ResultSet executeQuery(String command, ArrayList<Object> values) throws SQLException, SQLStoreException {

		try{

			this.getConnection();

			PreparedStatement st = connection.prepareStatement(command);

	http://dnetlib.eu/springbeans/template http://dnetlib.eu/springbeans/template.xsd"

       default-autowire="byName">

    <!--Un comment in order to run the tests / Comment to deploy-->

    <bean id="directIndexHandler" class="eu.dnetlib.data.claims.migration.handler.DirectIndexHandler">

        <property name="directClaimAPIUrl"  value="http://beta.services.openaire.eu:8280/is/mvc/api/publications"/>

    </bean>