diff --git a/reports/reports-impl/impl/src/java/org/sakaiproject/reports/logic/impl/ReportsManagerImpl.java b/reports/reports-impl/impl/src/java/org/sakaiproject/reports/logic/impl/ReportsManagerImpl.java index 45efd61..e03b3df 100644 --- a/reports/reports-impl/impl/src/java/org/sakaiproject/reports/logic/impl/ReportsManagerImpl.java +++ b/reports/reports-impl/impl/src/java/org/sakaiproject/reports/logic/impl/ReportsManagerImpl.java @@ -1150,6 +1150,7 @@ public class ReportsManagerImpl extends HibernateDaoSupport implements ReportsMa return inQuery; } Iterator iter = reportParams.iterator(); + int index = 0; // loop through all the parameters and find in query for replacement while (iter.hasNext()) { @@ -1159,9 +1160,8 @@ public class ReportsManagerImpl extends HibernateDaoSupport implements ReportsMa if (ReportDefinitionParam.VALUE_TYPE_MULTI_OF_SET.equals(rdp.getValueType()) || ReportDefinitionParam.VALUE_TYPE_MULTI_OF_QUERY.equals(rdp.getValueType())) { - + index = inQuery.indexOf("(?)", index); if (rp.getListValue().size() > 1) { - int index = inQuery.indexOf("(?)"); inQuery.delete(index, index + 3); StringBuilder tempString = new StringBuilder("("); for (int i = 0; i < rp.getListValue().size(); i++) { @@ -1171,6 +1171,7 @@ public class ReportsManagerImpl extends HibernateDaoSupport implements ReportsMa tempString.append(") "); inQuery.insert(index, tempString); } + index++; } } return inQuery;