users@jsf-extensions.java.net

Showing Data from 2 tables in JSF

From: pktripathy <pratap.tripathy_at_gmail.com>
Date: Thu, 31 Jan 2008 06:56:40 -0800 (PST)

I am developing a project in JSF and JPA

I have one table called employees with column
Name,Job_code,Dept_code
For employee table I have a entity

I have another table called ListOfValues with column
Prefix,Lov_code and Lov_desc
Prefix can be JOB(for job) and DEP(for department)

I want to display these columns
Name
Job desc(=lov_desc, comes from ListOfValues for prefix-JOB and
lov_code=job_code)
dept_desc(=lov_desc, comes from ListOfValues for prefix-DEPand
lov_code=dept_code)

I have got a session bean which does query(em.createquery(....)) and shows
data using JSF datatable. It shows Name,Job_code,Dept_code fine. now I want
to get job_desc and dept_desc in same table

Can anyone please tell me how to do it. Any help will be highly appreciated.
Thanks...

-- 
View this message in context: http://www.nabble.com/Showing-Data-from-2-tables-in-JSF-tp15206114p15206114.html
Sent from the jsf-extensions users mailing list archive at Nabble.com.