Great tutorial, however when I use paging on the top table, the Dep3 no longer updates. In my instance my top table will contain 3000 rows, and I will need pagination. Guidance?
Thank you for asking. I tried your scenario, It is working. I think maybe you missed some setting. I have 2 items, P3_DEP is for report department,P3_DEP3 is for report emp. when I click the row and column deptno, in the top report department, I have a dynamic action: Get_dept_no when: Click Selection Type: Jquery Selector Jquery Selector:#my_dept_id table:eq(1) tr:not(:eq(0)) td[headers="deptno_id"] Action :Execute Javascript Code $s(('P3_DEP3'),$(this.triggeringElement).text()) Affected Elements: Items P3_DEP3 You should create another dynamic action：Refresh_3 when: Event: Change Selection Type: Items Items:P3_DEP3 Action: refresh Selection Type： Region Region：EMP
HI I need to submit the value for the item P3_DEP3? because I have the same example.. and I can see in the page de value for apex_item but in session still missing..! So the EMP report show not found, but when run the report script show the recordset.. any ideas? thanks a lot
@@weililiu2119 ok but I need the P3_DEP3 item because in my second report Select * From table_details Where dep_id = :P3_DEP3 When the P3_dep3 change I need to show the details... Thanks a lot..
Yes, you are correct. When user selects dept report specific row , get specific dept no in that row and pass to the item p3_dep3, when the p3_dep3 changes, then refresh emp report. Need to submit p3_dep3 in the report emp. @@jorgebernal837
@@weililiu2119 Thanks for your help... could you give me an example the best way to submit ape_item value? I can use javascript or need to perform set value PL/SQL ? thanks a lot
Hi, I've just tried to implement this. It mostly works - I click on a department number and it goes into the dep3 box and refreshes the second report, but when I refresh it doesn't filter the department id, it just refreshes the report without changing it. Which part am I missing?
I understand your question. P3_DEP3 item is for EMP report partial refresh not for DEP refresh report in this example. I put the item P3_DEP3 visible not hidden only for people understand Clearly how it worked. If you want the DEP report fresh when P3_DEP3 changes, you can add a dynamic action when P3_DEP3 changes then refresh the DEP report. Thanks for you question.
@@weililiu2119 sorry that's not what I mean. I mean when I click on the dep report, the emp report refreshes but the information in it isn't filtered to the department number that is shown in the P3_DEP3 box
I think you didn't add the condition clause in the emp report source SQL query , Please see below select EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO from EMP where DEPTNO=:P3_DEP3 or :P3_DEP3 is null Then set 'page item to submit': P3_DEP3 @@jannahinchliff8420
@@weililiu2119 like my requirement is . mainly i used Interactive Report and Form for Company_details. Under that form page i just created a grid region which contain the detail of employee working in that company. So my aim is like when i select just a company on IR Report it should fetch the records which are present into grid.
@@arfaatshaikh2452 You can create page item Pxx_companyID in detail page and the type as 'hidden' . In master page, that is company page, under the IR report, column 'company_name', set the type as link, then link to detail page, pass the parameter companyID to Pxx_companyID(xx representing the detail page number). Another, In detail page, IG report SQL, should add where condition , companyID=:Pxx_companyID. Hope it is helpful for you. You can try, Thanks for asking.
If you want to click first column, you can try this below. A little change: Dynamic Action: when Event:click Selection Type: Jquery Selector Jquery Selector: #my_dept_id table:eq(1) tr:not(:eq(0)) td[headers="deptno_id"] Action: Execute Javascript:$s(('P3_DEP3'),$(this.triggeringElement).text()) Hope it is helpful for you.
@@weililiu2119 i try to jQuery Selector #tn_emp_by_job table:eq(1) tr:not(:eq(0)) td:not(:has(input[type="checkbox"])) but Execute Javascript: $s(('P76_TN_JOBKEY'),$(this.triggeringElement).find('td[headers="JOB_KEY"]').text()) is not working Is there a way to solve it?
Very useful. Clear and precise. Well done!
Glad it was helpful!
Great tutorial, however when I use paging on the top table, the Dep3 no longer updates. In my instance my top table will contain 3000 rows, and I will need pagination. Guidance?
Thank you for asking. I tried your scenario, It is working. I think maybe you missed some setting.
I have 2 items, P3_DEP is for report department,P3_DEP3 is for report emp.
when I click the row and column deptno, in the top report department,
I have a dynamic action: Get_dept_no
when: Click
Selection Type: Jquery Selector
Jquery Selector:#my_dept_id table:eq(1) tr:not(:eq(0)) td[headers="deptno_id"]
Action :Execute Javascript Code
$s(('P3_DEP3'),$(this.triggeringElement).text())
Affected Elements: Items P3_DEP3
You should create another dynamic action：Refresh_3
when:
Event: Change
Selection Type: Items
Items:P3_DEP3
Action: refresh
Selection Type： Region
Region：EMP
HI I need to submit the value for the item P3_DEP3? because I have the same example.. and I can see in the page de value for apex_item but in session still missing..! So the EMP report show not found, but when run the report script show the recordset.. any ideas? thanks a lot
Not submit p3_dep3. when p3_dep3 changes, refresh the emp report. It is partially refreshing using dynamic action.
@@weililiu2119 ok but I need the P3_DEP3 item because in my second report
Select *
From table_details
Where dep_id = :P3_DEP3 When the P3_dep3 change I need to show the details...
Thanks a lot..
Yes, you are correct. When user selects dept report specific row , get specific dept no in that row and pass to the item p3_dep3, when the p3_dep3 changes, then refresh emp report.
Need to submit p3_dep3 in the report emp. @@jorgebernal837
@@weililiu2119 Thanks for your help... could you give me an example the best way to submit ape_item value? I can use javascript or need to perform set value PL/SQL ? thanks a lot
Is there a way to pass column value to page item?
This program is pass dept no in the dept report to page item p3_dept_no
Hi, I've just tried to implement this. It mostly works - I click on a department number and it goes into the dep3 box and refreshes the second report, but when I refresh it doesn't filter the department id, it just refreshes the report without changing it. Which part am I missing?
I understand your question. P3_DEP3 item is for EMP report partial refresh not for DEP refresh report in this example. I put the item P3_DEP3 visible not hidden only for people understand Clearly how it worked. If you want the DEP report fresh when P3_DEP3 changes, you can add a dynamic action when P3_DEP3 changes then refresh the DEP report. Thanks for you question.
@@weililiu2119 sorry that's not what I mean. I mean when I click on the dep report, the emp report refreshes but the information in it isn't filtered to the department number that is shown in the P3_DEP3 box
I think you didn't add the condition clause in the emp report source SQL query , Please see below
select EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO
from EMP
where DEPTNO=:P3_DEP3 or :P3_DEP3 is null
Then set 'page item to submit': P3_DEP3
@@jannahinchliff8420
is it possible to fetch the data of a master details region page to the master page, but only the selected data.
Could you give me specific detail ? Thank you.
@@weililiu2119 like my requirement is . mainly i used Interactive Report and Form for Company_details. Under that form page i just created a grid region which contain the detail of employee working in that company. So my aim is like when i select just a company on IR Report it should fetch the records which are present into grid.
@@arfaatshaikh2452
You can create page item Pxx_companyID in detail page and the type as 'hidden' . In master page, that is company page, under the IR report, column 'company_name', set the type as link, then link to detail page, pass the parameter companyID to Pxx_companyID(xx representing the detail page number). Another, In detail page, IG report SQL, should add where condition , companyID=:Pxx_companyID.
Hope it is helpful for you. You can try, Thanks for asking.
Why is a 'where' SQL statement needed in the Department region?
Not necessary. Depends on your situation
Is there any way to pass a "*page item*" value to a "report column"?
dynamic action:
Action:
set value, PL/SQL expression: page item,(eg, :P1_item)
submit: P1_item
affected column: report column
working ok but in latest version Execution Event Scope Must be Dynamic
please can you advise for this java script code source ?
Please
Get_dept_no
When: Click
Selection Type:jQuery Selector
jQuery Selector：#my_dept_id table:eq(1) tr:not(:eq(0))
Action：Execute JavaScript Code：
$s(('P3_DEP3'),$(this.triggeringElement).find('td[headers="deptno_id"]').text())
Affected Elements:
Selection Type: Items
Items: P3_DEP3
Thanks Weilli,
I am trying on 21.2.1 not working,
It should be working
how to pass only when click first column
If you want to click first column, you can try this below. A little change:
Dynamic Action:
when
Event:click
Selection Type: Jquery Selector
Jquery Selector: #my_dept_id table:eq(1) tr:not(:eq(0)) td[headers="deptno_id"]
Action:
Execute Javascript:$s(('P3_DEP3'),$(this.triggeringElement).text())
Hope it is helpful for you.
@@weililiu2119 i try to jQuery Selector #tn_emp_by_job table:eq(1) tr:not(:eq(0)) td:not(:has(input[type="checkbox"]))
but
Execute Javascript: $s(('P76_TN_JOBKEY'),$(this.triggeringElement).find('td[headers="JOB_KEY"]').text()) is not working
Is there a way to solve it?
Thanks
Thanks a lot!