working ok but in latest version Execution Event Scope Must be Dynamic
@Mohammed-kh4lj
Жыл бұрын
Is there a way to pass column value to page item?
@weililiu2119
Жыл бұрын
This program is pass dept no in the dept report to page item p3_dept_no
@jorgebernal837
Жыл бұрын
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
Жыл бұрын
Not submit p3_dep3. when p3_dep3 changes, refresh the emp report. It is partially refreshing using dynamic action.
@jorgebernal837
Жыл бұрын
@@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..
@weililiu2119
Жыл бұрын
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
@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
@markangellotti893
11 ай бұрын
Why is a 'where' SQL statement needed in the Department region?
@weililiu2119
11 ай бұрын
Not necessary. Depends on your situation
@jannahinchliff8420
11 ай бұрын
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?
@weililiu2119
11 ай бұрын
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.
@jannahinchliff8420
11 ай бұрын
@@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
@weililiu2119
11 ай бұрын
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
@mdhassanahmed7079
2 жыл бұрын
Is there any way to pass a "*page item*" value to a "report column"?
is it possible to fetch the data of a master details region page to the master page, but only the selected data.
@weililiu2119
8 ай бұрын
Could you give me specific detail ? Thank you.
@arfaatshaikh2452
8 ай бұрын
@@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.
@weililiu2119
8 ай бұрын
@@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.
@deencrypt8041
8 ай бұрын
how to pass only when click first column
@weililiu2119
8 ай бұрын
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.
@deencrypt8041
2 ай бұрын
@@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?
@inamhusain
Жыл бұрын
please can you advise for this java script code source ?
Пікірлер: 34