how to retrieve data from list in jpa through jsf page

how to retrieve data from list in jpa through jsf page

here is my code to get result list but i am getting result for wrong input
also which is not present in database
DataModel searchrs=null;
public DataModel createCrmSearchDataModel() throws Exception{
return new ListDataModel(searchres());
}
public CrmDailySheet SearchshtData() throws Exception{
if(crmSheets==null){
crmSheets=createCrmSearchDataModel();
}
return searchsht;
}
public List <CrmDailySheet> searchres() throws Exception{
SimpleDateFormat ddMMMyyFormat = new SimpleDateFormat("dd/MM/yy");
Date d1=searchsht.getReportedOn();
String date_to_string = ddMMMyyFormat.format(d1);
return crmsrvc.searchDailysht(date_to_string);
}
the Native query i am using is enter code here
public List <CrmDailySheet> findSheetForDaily(String reported) {
EntityManager em = getEntityManager();
try {
Query query = em.createNativeQuery("SELECT * FROM CRM_DAILY_SHEET WHERE
to_char(REPORTED_ON,'dd/MM/yy') = ?", CrmDailySheet.class);
query.setParameter(1, reported); List res= query.getResultList(); return
res; } finally { em.close(); } }