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!
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
Why is a 'where' SQL statement needed in the Department region?
Not necessary. Depends on your situation
working ok but in latest version Execution Event Scope Must be Dynamic
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.
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
Thanks
Thanks a lot!
Thanks Weilli,
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
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?