This discussion is archived
2 Replies Latest reply: Aug 13, 2013 7:50 AM by pawankumaar RSS

How to Perform a Dynamic Action on Item

pawankumaar Newbie
Currently Being Moderated

Hi,

 

In Parametrized Report i want to filter my item value based on previous item

Actually i am having 3 parameters based on that report output will be generated

 

1 ..Employee name ...text item

2 ..Department name ....select list type(LOV)

3 ..Manager name .....select list type(LOV)

 

Based on employee name the department name should  be displayed... what approach is suitable for this

ie by creating process in page rendering

or by creating dynamic action in page rendering

 

I used the Below Queries

 

1....report query:

select oe.employee_id,

oe.first_name||' '||oe.last_name as "EMPLOYEE NAME",

oe.email,

oe.phone_number,

oe.hire_date,

oj.job_title,

oe.salary,

od.department_name,

(select oee.first_name||' '||oee.last_name from OEHR_EMPLOYEES oee where oee.employee_id(+)=oe.manager_id) as "MANAGER NAME"

from OEHR_EMPLOYEES oe,

OEHR_JOBS oj,

OEHR_DEPARTMENTS od

where oe.job_id=oj.job_id

and oe.department_id(+)=od.department_id

and oe.first_name||' '||oe.last_name=nvl(:P1_EMPNAME,oe.first_name||' '||oe.last_name)

and oe.department_id=nvl(:P1_DEPTID,oe.department_id)

and oe.manager_id=nvl(:P1_MGRID,oe.manager_id)

order by 1

 

2...Department name ....select list type(LOV)  query

select distinct od.department_name d,od.department_id r 

from OEHR_departments od,oehr_employees oe

where oe.department_id(+)=od.department_id

and oe.first_name||' '||oe.last_name = nvl(:P1_EMPNAME,oe.first_name||' '||oe.last_name)

order by 1

 

3....Manager name .....select list type(LOV) query

SELECT distinct oe.first_name||' '||oe.last_name d,oee.manager_id r

FROM oehr_employees oe ,oehr_employees oee

WHERE oe.employee_id = oee.manager_id

and  oee.department_id = nvl(:P1_DEPTID,oee.department_id)

and oee.first_name||' '||oee.last_name = nvl(:P1_EMPNAME,oee.first_name||' '||oee.last_name)

order by 1

 

 

 

Regards,

Pavan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points