Posted By:
pratap_tripathy
Posted On:
Thursday, January 31, 2008 09:57 AM
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 sa
More>>
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...
<<Less