did you insert the records into the table manually or did you use the EntityManager?
i've noticed that when i insert records manually queries made with EntityManager don't see them for a while. Not sure yet why that is...
if that's not your problem, then i would try the query as
fine. thank you for your response..
but i found that the problem is not in retrieving the data but the problem is in viewing those data in my (jsf)facelet file.
can you help me to view/show/display that data in my facelt