Repository: fineract Updated Branches: refs/heads/develop a42f9d526 -> cef41855a
FINERACT-571 Unable to transfer clients from one group to another group even though both groups are under same center and office Project: http://git-wip-us.apache.org/repos/asf/fineract/repo Commit: http://git-wip-us.apache.org/repos/asf/fineract/commit/cef41855 Tree: http://git-wip-us.apache.org/repos/asf/fineract/tree/cef41855 Diff: http://git-wip-us.apache.org/repos/asf/fineract/diff/cef41855 Branch: refs/heads/develop Commit: cef41855a2dd58d79bf84bfff9408812506a7bd8 Parents: a42f9d5 Author: Nazeer Hussain Shaik <[email protected]> Authored: Mon Dec 4 10:46:13 2017 +0530 Committer: Nazeer Hussain Shaik <[email protected]> Committed: Mon Dec 4 10:46:13 2017 +0530 ---------------------------------------------------------------------- .../portfolio/calendar/domain/CalendarInstanceRepository.java | 2 +- .../portfolio/group/service/GroupReadPlatformServiceImpl.java | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/fineract/blob/cef41855/fineract-provider/src/main/java/org/apache/fineract/portfolio/calendar/domain/CalendarInstanceRepository.java ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/java/org/apache/fineract/portfolio/calendar/domain/CalendarInstanceRepository.java b/fineract-provider/src/main/java/org/apache/fineract/portfolio/calendar/domain/CalendarInstanceRepository.java index 8b1ea7e..d51b378 100644 --- a/fineract-provider/src/main/java/org/apache/fineract/portfolio/calendar/domain/CalendarInstanceRepository.java +++ b/fineract-provider/src/main/java/org/apache/fineract/portfolio/calendar/domain/CalendarInstanceRepository.java @@ -50,7 +50,7 @@ public interface CalendarInstanceRepository extends JpaRepository<CalendarInstan Collection<CalendarInstance> findByCalendarIdAndEntityTypeId(Long calendarId, Integer entityTypeId); /** Should use in clause, can I do it without creating a new class? **/ - @Query("select ci from CalendarInstance ci where ci.entityId in (select id from Loan loan where loan.client.id = :clientId and loan.group.id = :groupId and (loan.loanStatus = 100 or loan.loanStatus = 200 or loan.loanStatus = 300)) and ci.entityTypeId = 3") + @Query("select ci from CalendarInstance ci where ci.entityId in (select loan.id from Loan loan where loan.client.id = :clientId and loan.group.id = :groupId and (loan.loanStatus = 100 or loan.loanStatus = 200 or loan.loanStatus = 300)) and ci.entityTypeId = 3") List<CalendarInstance> findCalendarInstancesForActiveLoansByGroupIdAndClientId(@Param("groupId") Long groupId, @Param("clientId") Long clientId); http://git-wip-us.apache.org/repos/asf/fineract/blob/cef41855/fineract-provider/src/main/java/org/apache/fineract/portfolio/group/service/GroupReadPlatformServiceImpl.java ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/java/org/apache/fineract/portfolio/group/service/GroupReadPlatformServiceImpl.java b/fineract-provider/src/main/java/org/apache/fineract/portfolio/group/service/GroupReadPlatformServiceImpl.java index 8dd0ed6..af28a31 100644 --- a/fineract-provider/src/main/java/org/apache/fineract/portfolio/group/service/GroupReadPlatformServiceImpl.java +++ b/fineract-provider/src/main/java/org/apache/fineract/portfolio/group/service/GroupReadPlatformServiceImpl.java @@ -234,7 +234,7 @@ public class GroupReadPlatformServiceImpl implements GroupReadPlatformService { final String name = searchCriteria.getName(); if (name != null) { - paramList.add(ApiParameterHelper.sqlEncodeString("%" + name + "%")); + paramList.add("%" + name + "%"); extraCriteria.append(" and g.display_name like ? "); }
