public static List<UserFlatMapping> checkMobileNumberValidForGroupz(String query) {
List<UserFlatMapping> membersList = null;
DatabaseSession session = sessionFactory.newDatabaseSession();
try {
SQLQuery results = constructMobileNumberValidForGroupzQuery(query);
System.out.println("Final SQL Qry:" + results.toString());
membersList =
(List<UserFlatMapping>)
results.addEntity("userflatmapping", UserFlatMapping.class).list();
System.out.println("Final Groupz List:" + membersList.size());
session.close();
} catch (Exception e) {
// TODO: handle exception
}
return membersList;
}
