=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2015-10-20 06:46:47 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2015-11-12 12:21:41 +0000 @@ -164,11 +164,11 @@ if ( queryItem.isNumeric() ) { - hql += " and teav.value" + queryFilter.getSqlOperator() + filter + ")"; + hql += " and teav.value " + queryFilter.getSqlOperator() + filter + ")"; } else { - hql += " and lower(teav.value)" + queryFilter.getSqlOperator() + filter + ")"; + hql += " and lower(teav.value) " + queryFilter.getSqlOperator() + filter + ")"; } }