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...
Previous Topic
