Revision 60663
Added by Argiro Kokogiannaki about 3 years ago
QueryGenerator.java | ||
---|---|---|
665 | 665 |
return " select count(*) from claim where claim.id in ( select claim.id from ("+generateFetchClaimsByFunder(funderId, null,null,keyword,null,false, types, params)+")as claim )"; |
666 | 666 |
} |
667 | 667 |
public String generateCountByContext(String contextId ,String keyword, List<String> types, ArrayList<Object> params) { |
668 |
if((keyword == null || keyword.equals(""))&&types.isEmpty()){ |
|
669 |
params.add(contextId+"%"); |
|
670 |
params.add("%_connect_" + contextId); |
|
671 |
return " select count(*) from claim where "+" claim.source_id like ? or claim.claimed_in_dashboard like ? "; |
|
672 |
} |
|
673 | 668 |
return " select count(*) from claim where claim.id in ( select claim.id from ("+generateFetchClaimsByContext(contextId, null,null,keyword,null,false, types, params)+")as claim )"; |
674 |
|
|
675 | 669 |
} |
676 | 670 |
public String generateCountByResult(String resultId ,String keyword, List<String> types, ArrayList<Object> params) { |
677 | 671 |
if((keyword == null || keyword.equals(""))&&types.isEmpty()){ |
... | ... | |
810 | 804 |
clauseParams.add("%_connect_" + contextId); |
811 | 805 |
String filterByType = addFilterByType(types, clauseParams); |
812 | 806 |
clause+= ((filterByType==null)?"":" and ("+filterByType+") "); |
813 |
String query = " select * from ("+" ( " +generateSelectclaimQuery(ClaimUtils.CONTEXT,ClaimUtils.PUBLICATION,limit, offset, orderBy,desc,clause,clauseParams, keyword, params)+")"+
|
|
807 |
String query = " select * from ("+" ( " +generateSelectClaimQueryAsUnionOfAllRelations(limit, offset, orderBy,desc,clause,clauseParams, keyword, types, params)+")"+
|
|
814 | 808 |
") as claim "; |
815 | 809 |
return query; |
816 | 810 |
} |
... | ... | |
887 | 881 |
|
888 | 882 |
return fields; |
889 | 883 |
} |
890 |
//private String generateSelectclaimQuery(String sourceType, String targetType, Integer limit,Integer offset,String orderBy, boolean desc,String whereClause, String keyword, ArrayList<Object> params) { |
|
891 | 884 |
private String generateSelectclaimQuery(String sourceType, String targetType, Integer limit,Integer offset,String orderBy, boolean desc,String whereClause, ArrayList<Object> whereParams, String keyword, ArrayList<Object> params) { |
892 | 885 |
if(sourceType == null || targetType == null){ |
893 | 886 |
return null; |
894 | 887 |
} |
895 |
/* |
|
896 |
" select "+getClaimFields()+" ,"+getFieldsPerType(sourceType, "source")+" , "+getFieldsPerType(targetType,"target")+ |
|
897 |
" \nfrom claim, "+getTypeForTable(sourceType)+" as source, "+getTypeForTable(targetType)+" as target \n" + |
|
898 |
"where claim.source_id = source.openaire_id and claim.target_id = target.openaire_id "+((specificWhereClause==null)?"":" and "+specificWhereClause+" "); |
|
899 |
*/ |
|
888 |
|
|
900 | 889 |
String orderByClause= addOrderByClause(orderBy,desc); |
901 | 890 |
String pagingClause= addPagingClause(limit,offset); |
902 | 891 |
String query = " select "+getClaimFields()+" ,"+getFieldsPerType(sourceType, "source")+" , "+getFieldsPerType(targetType,"target")+ |
... | ... | |
949 | 938 |
String query = "select * from ("+ |
950 | 939 |
|
951 | 940 |
" ( " +generateSelectclaimQuery(ClaimUtils.PUBLICATION,ClaimUtils.PUBLICATION,null,null,null,false, specificWhereClause,whereParams,keyword, params)+" ) \nunion "+ |
952 |
// " ( " +generateSelectclaimQuery(ClaimUtils.DATASET,ClaimUtils.DATASET,null,null,null,false, specificWhereClause, whereParams,keyword, params)+" ) \nunion "+ |
|
953 |
// " ( " +generateSelectclaimQuery(ClaimUtils.SOFTWARE,ClaimUtils.SOFTWARE,null,null,null,false, specificWhereClause, whereParams,keyword, params)+" ) \nunion "+ |
|
954 |
// " ( " +generateSelectclaimQuery(ClaimUtils.OTHER,ClaimUtils.OTHER,null,null,null,false, specificWhereClause, whereParams,keyword, params)+" ) \nunion "+ |
|
955 | 941 |
" ( " +generateSelectclaimQuery(ClaimUtils.PROJECT,ClaimUtils.PUBLICATION, null,null,null,false, specificWhereClause, whereParams,keyword, params)+" ) \nunion "+ |
956 | 942 |
" ( " +generateSelectclaimQuery(ClaimUtils.CONTEXT,ClaimUtils.PUBLICATION,null,null,null,false, specificWhereClause, whereParams, keyword, params)+" )" + |
957 | 943 |
|
Also available in: Unified diff
Fix context query (to return claims linked to a community or made in community dashboard)