Slack

Hi Marc, I've created example, you can see it on apex.oracle.com ws: mypublicws user: mypublicws pass: mypublicws Page Employees and Employee. You can acomplish that in various ways, first thing that came up on my mind was to: 1. Create Form on Table with report using Apex wizard. Report as IR, and form as Modal page dialog. 2. On Form page I've added P3_CLEAR_EMPNO hidden field, and if that field is set to 1, on the same page I've created PLSQL process to clear P3_EMPNO sessio state value 3. On IR page, I've added ROWID column and used it to link to Modal page form, I've used same parameters as EDIT record link with addition to set P3_CLEAR_EMPNO value to 1.
25-Mar-2019 10:06:AM by: bozo030
I'm not APEX savvy, but I think that doing something simple like creating a copy of a record in a form shouldn't be this hard. I'm extremely frustrated. Can anyone tell me, simply, how to link from an interactive report (existing record) to the form with the field content and a blank/null id, so a user can make minor changes and save it? The EDIT link works. CREATE link works. Those are built in. Why can't I figure out a simple "copy fields to form" and use the INSERT / Create DML?
25-Mar-2019 12:34:AM by: Marc Visconte
Thank you bozo. Now It is working fine. Thanks:+1::simple_smile:
24-Mar-2019 10:55:AM by: arjun
Is there any solution or alternate method to achieve this.???
24-Mar-2019 05:54:AM by: arjun
If manager gives the comment to particular header then I have to display one image,if there are no comments then I need to display another image. But when I use dynamic value in url that control break related header is not working as expected.
24-Mar-2019 05:53:AM by: arjun
In my scenario manager need to give header level comments.
24-Mar-2019 05:48:AM by: arjun
What do you want to accomplish with image link beside manager?
23-Mar-2019 04:19:PM by: bozo030
I want to group manager column also same like other `JOB` columns.Could you please tell me how to achieve this??
23-Mar-2019 12:29:PM by: arjun
```APEX_UTIL.PREPARE_URL('f?p=&APP_ID.:35:&SESSION.::NO:35,RIR,CIR:P35_EMPNO,P35_SAL,P35_JOB:'||EMPNO||','||SAL||','||JOB)--NOT WORKING APEX_UTIL.PREPARE_URL('f?p=&APP_ID.:35:&SESSION.::NO:35,RIR,CIR:P35_EMPNO,P35_SAL,P35_JOB:'||7839||','||2000||','||'MANAGER')--Working fine```
23-Mar-2019 12:16:PM by: arjun
Hi Bozo, If I pass dynamic values in APEX_UTIL.PREPARE_URL then after control break is not working for "Manager ".
23-Mar-2019 12:11:PM by: arjun
I have changed the line which substrings header title to $(this).contents().first()[0].textContent=$(this).text().substr(6); Check the result.
23-Mar-2019 07:51:AM by: bozo030
Hi All, Issue Type: Unable to getting HTML part in header level. I am trying to display one Image Icon beside my column header but It is not appearing when I use below code. ```select ename,deptno,sal,job|| case when job IN ('MANAGER' ) then '<a href="'||APEX_UTIL.PREPARE_URL('f?p=&APP_ID.:35:&SESSION.::NO:35,RIR,CIR:P35_TEST_USE_PK,P35_ARJUN_PK,P35_HOME_PK:'||1||','||2||','||3||','||4)||'">' ||'<img src="apex_world/r/100/files/static/v2808/S_deactive.png" height="13" width="13" />' ||'</a>' else null end as job from emp;``` Report Type: Interactive Report Control Break Column: Job Added below code in dynamic action(after refresh the region) for header style: ```$('div#ARJUN_ARJUN_data_panel th.a-IRR-header.a-IRR-header--group').each(function( index ) { $(this).text($(this).text().substr(6)); $(this).css("font-size","14px"); $(this).css("color","#056abf"); $(this).parent().next().hide(); }); $('div#ARJUN_ARJUN_control_panel').hide(); $('.wrlabel').parent().css('width','60%') ``` Workspace: arjun_ind Username: arjun_ind Password: arjun_ind Url: https://apex.oracle.com/pls/apex/f?p=64539:1:4884205128675::::: How to get the Image Icon beside the header column ?? Please let me know what I miss in this. Thanks.
23-Mar-2019 05:55:AM by: arjun
Not really. See my previous response on using database links to work with multiple databases from a single APEX install.
22-Mar-2019 05:10:PM by: rich.soule
Zahid, Database links are the answer. If, for some reason you can't use database links, then you could investigate using REST services.
22-Mar-2019 05:09:PM by: rich.soule
I can guess ... in the link you are setting the value of P41_SKILL_PARENT. So I would expect you to use that item in your query (and not P41_ID which is - probably - NULL anyway).
22-Mar-2019 06:50:AM by: roelhartman
@roelhartman I am trying to implement the link we were discussing. Because I have multiple edit types, I created a Link column in the iReport. The link has a form page as the target. The link Set Items include P41_SKILL_PARENT, #ID#. Clear Cache for that page (this link), and Advanced has Request = REDEFINE On the edit page (41), I have a process defined. It is in the same band that process for AUTO RowFetch was placed: Type: PL/SQL code. Source is (simplified): SELECT null ID, Field2, Field3, :P41_ID as SKILL_PARENT INTO :P41_ID, :P41_Field2, :P41_Field3, :P41_SKILL_PARENT FROM source_table ST WHERE ST.ID = :P41_ID ; When I click the link, the only fields that are populated is the redord ID (which should have been NULL) and another field which is set through another process. The PL/SQL does is not being executed. Can you guess what I am doing wrong?
21-Mar-2019 07:49:PM by: Marc Visconte
is there any way that we could set app DB at runtime?
21-Mar-2019 05:39:PM by: Zahid Waheed
Is there an easier way in Oracle to allow all types of Alphacharacters? I.e. accented characters and other languages?
21-Mar-2019 10:59:AM by: Ross Henderson
i want to connect my apex application with multiple databases, please guide me how to get there?
21-Mar-2019 07:48:AM by: Zahid Waheed
Or you could also have a look at the dropzone plugin
20-Mar-2019 10:33:PM by: maxime_tremblay
thought that might be the case. thanks Maxime.
20-Mar-2019 10:33:PM by: trevorh
@trevorh instead of an inline dialog you could use a standard page dialog Then on dialog close you could refresh anything that needs to be on the parent page
20-Mar-2019 10:32:PM by: maxime_tremblay
@roelhartman Thank you, Roel. I just saw your response. I'm looking for information on that today, but I'm still trying to recover from other errors I created earlier, so, I may not have that totally digested for a little bit. I think that what I'm hearing from you and Maxime is, I have been approaching incorrectly (due to not understanding how the intrapage stuff is done). I appreciate the help.
20-Mar-2019 10:31:PM by: Marc Visconte
Any known work around for this?
20-Mar-2019 10:30:PM by: trevorh
There is no error if I do not select a file to upload.
20-Mar-2019 10:30:PM by: trevorh
apex 5.1. Trying to use a 'File Browse" item in a "Inline Dialog". Save button triggers a DA that has a Pl/SQL block which gets and saves values, but I'm getting a 404 error. "server/wwv_flow.ajax not found". I assume that means there is a server side error (which I have no access to)?
20-Mar-2019 10:30:PM by: trevorh
I would simply have two parameters for your two use cases P2_ID : would be used to edit a current record P2_COPY_FROM_ID would be used to copy from another record Then in your form page load processes you can fetch the values from either the record or the record to copy There’s no need to pass all values. You only need the ID :wink: Then if you ever change the table you only need to change it at the form page level And not for every place you have your link
20-Mar-2019 03:41:PM by: maxime_tremblay
Yes, there is. Just pass the ID (and maybe a request “COPY”) and define a Process in that Edit page to fetch the record data based on the passed in ID.
20-Mar-2019 03:38:PM by: roelhartman
> *itemNames* >Comma-delimited list of item names used to set session state with a URL. > >*itemValues* >List of item values used to set session state within a URL. To pass a comma in an item value, enclose the characters with backslashes. For example: > >\123,45\ >Every character sequence except backslash comma (\,) can be enclosed with backslash.
20-Mar-2019 12:30:PM by: maxime_tremblay
@Marc Visconte have a look at this https://docs.oracle.com/en/database/oracle/application-express/18.2/htmdb/understanding-url-syntax.html#GUID-D5510BFC-AF94-4AAD-8B82-FF780A47601D
20-Mar-2019 12:29:PM by: maxime_tremblay
I ran into an issue I didn't see coming: Some of the data in one VARCHAR field has embedded special characters. Possibly TAB, but probably CR and LF. When I passed this field to an APEX FORM page, the result was that the containing ITEM field showed only partial data, subsequent ITEMs contained remaining data, and all of the rest of the ITEM fields had their data pushed down a similar amount. ?? What is the simplest to PREVENT this? The data comes from records, shows up in an iReport, and gets passed to the form page through the page link: Name: P41_DESCRIPTION, Value: #DESCRIOPTION#, etc. Can I used functions in the link field? (I suspect not) [ Note: After looking at the report content, the characters that are breaking this are ... COMMAs. How the heck can COMMAs be causing this much grief? Is this going to happen with OTHER "special characters"? Some of the descriptions have double-quotes (") and single-quotes/appostrophes (') ! And what will happen if there are embedded #, &, or : ? Oy! ]
20-Mar-2019 03:44:AM by: Marc Visconte
Any one has idea
19-Mar-2019 09:52:PM by: Guangyu Mao
-
19-Mar-2019 07:34:PM by: dgielis
Hi All, Issue Type: Oracle APEX AOP I have created and IR report using `case` statement and I want to download as excel by using AOP plugin. In my SQL query two `case` statements are there but pulgin is returning only one column values. I need to download all the column which are contain in IR. I have created sample demo in http://apex.oracle.com|apex.oracle.com. Kindly any one help me in this. https://apex.oracle.com/pls/apex/f?p=44885:23:101145695605043::::: workspace:arjun_ind username:arjun_ind password:arjun_ind Application:44885 Page:23 Excel output; Apex R & :anguished: Custom Excel Template {#aopireportdata} {ENAME} {DEPTNO} {MY_SAL} {/aopireportdata} {aaaa_region_name} In this `less sal` column data is not showing if I add manually template not working properly.(column don't have any conditions)
19-Mar-2019 06:38:PM by: arjun
Try to set up a language selection page like that on my app. Anyone have idea how to create page like that. Any source that I can follow with. Thank you for any help.
19-Mar-2019 06:31:PM by: Guangyu Mao
I thought as much, but thanks for confirming! :slightly_smiling_face:
19-Mar-2019 08:42:AM by: Ross Henderson
original est is column 1 and revised est amt is column 2 when tabular form coming from clicking of create button then original est is editable and revised est amt is uneditable and when it's coming from cliking on revised button then original est amt is uneditable and revised est amt is editable . this will solve using this qurey is it the correct method @maxime_tremblay begin for i in 1..apex_application.g_f01.count loop update test set REVISED_EST_AMT = apex_application.g_f05(i) where PROJECT_id = apex_application.g_f03(i) and flex_id=apex_application.g_f04(i); --and nvl(revised_est_amt,0)=0; end loop; end;
19-Mar-2019 05:20:AM by: Amit
Did anyone know how to fix it?
19-Mar-2019 02:45:AM by: Guangyu Mao

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
user585404
25-Mar-2019 06:57
Calling Apex Screen from oracle EBS
Link
0 replies
3251601
25-Mar-2019 05:31
integrated apex with in EBS.we are unable to login
Link
1 replies - last reply: - by:
benton
25-Mar-2019 05:06
Interactive Grid Action
Link
0 replies
Siberia
25-Mar-2019 03:35
how to keep left column report always visible between pages
Link
2 replies - last reply: 25-Mar-2019 03:35- by: Siberia
ReemaPuri
24-Mar-2019 18:10
how to run .a-IRR-controlsContainer { display: none; } in dynamic action on apex item value d
Link
6 replies - last reply: 24-Mar-2019 18:10- by: ReemaPuri
Eslam_Elbyaly
24-Mar-2019 17:48
A process that does not execute
Link
2 replies - last reply: 25-Mar-2019 04:05- by: Eslam_Elbyaly
study-feng
24-Mar-2019 16:04
Sometimes apex can not access with 500 internal server error
Link
0 replies
ReemaPuri
24-Mar-2019 14:28
how to fetch the index in this loop -apex 18.2
Link
2 replies - last reply: 24-Mar-2019 16:35- by: ReemaPuri
Laury
24-Mar-2019 13:11
Standard Report Column type in Page Designer
Link
2 replies - last reply: 24-Mar-2019 16:04- by: Franck N
Laury
24-Mar-2019 12:43
Display BLOB (image) as download field in tabular form
Link
5 replies - last reply: 24-Mar-2019 17:56- by: fac586
Laury
24-Mar-2019 10:06
Cascading LOV in Tabular Forms
Link
4 replies - last reply: 24-Mar-2019 17:53- by: Laury
Eslam_Elbyaly
23-Mar-2019 17:41
Redirect to and Passing values to a page
Link
2 replies - last reply: 24-Mar-2019 12:26- by: Eslam_Elbyaly
gkthomas
23-Mar-2019 15:56
Dashboard page take long time to load
Link
1 replies - last reply: 24-Mar-2019 09:53- by: fac586
fe*429113*je
23-Mar-2019 04:58
How to resolve ORA-29278: SMTP transient error: 421 Service not available?
Link
1 replies - last reply: 25-Mar-2019 05:09- by: Billy~Verreynne
melinda_f
22-Mar-2019 18:32
interactive grid error on add-row
Link
1 replies - last reply: 24-Mar-2019 16:18- by: Eslam_Elbyaly
ReemaPuri
22-Mar-2019 18:26
how to get rid of public report named display when public report selected
Link
3 replies - last reply: 25-Mar-2019 02:53- by: Ashish Sinha-Oracle
d.n.kurashkin
22-Mar-2019 13:28
Get column settings in a Region Plugin
Link
3 replies - last reply: 24-Mar-2019 20:39- by: John Snyders-Oracle
PhilMan2
22-Mar-2019 10:30
Custom Authentication failed after upgrade to Apex 18.2
Link
2 replies - last reply: 24-Mar-2019 11:55- by: PhilMan2
user1151568
21-Mar-2019 12:20
Apex 5.1 POST to GET method interchangeable - vulnerability
Link
1 replies - last reply: 21-Mar-2019 12:20- by: user1151568
854391
21-Mar-2019 10:54
In Apex-Unable to get the value for apps.icx_sec.getsessioncookie from instance having sso authentio
Link
4 replies - last reply: 21-Mar-2019 10:54- by: 854391
Laury
21-Mar-2019 08:52
Tabular form with Oracle APEX 5.x
Link
7 replies - last reply: 23-Mar-2019 14:09- by: fac586
Ahmed Haroon
21-Mar-2019 07:39
Apex 5.1: how to add Search in "Form on a Table" single record Form
Link
5 replies - last reply: 22-Mar-2019 08:44- by: fac586
Jose Aróstegu
20-Mar-2019 23:16
Interactive Grid dependant Select List items
Link
1 replies - last reply: 20-Mar-2019 23:16- by: Jose Aróstegui
RobV62
15-Oct-2018 14:28
remove selection interactive grid
Link
6 replies - last reply: 23-Mar-2019 18:47- by: Pierre Yotti
Franck N
05-Apr-2018 06:45
Ajax Tree child-Nodes
Link
5 replies - last reply: - by:

News

X
    
 
ImageNewsFavoriteForward
Marc Sewtz    Other
apex.oracle.com now on 19.1
APEX 19
Link
16-Mar-2019 17:42:44 by: Juergen Schuster
Marc Sewtz    Other
Office Hours: Social Media Login
Login, OAuth2
Link
22-Mar-2019 22:27:00 by: Juergen Schuster
Michelle Skamene    
Support Packages
Support
Link
22-Mar-2019 22:12:39 by: Juergen Schuster
Martin D'Souza  
Speed up your development with Classic Reports
Reports
Link
21-Mar-2019 16:51:47 by: Juergen Schuster
JMJ Cloud Austin  
Social Sign-In used differently
Authentication, SSO
Link
21-Mar-2019 15:58:41 by: Juergen Schuster
Matt Mulvaney  
Make it clear which Workspace you log in
Link
21-Mar-2019 15:53:52 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: UK, Bognor Regis, permanent
Jobs
Link
20-Mar-2019 12:00:43 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Germany, Hamburg, permanent, onsite
Jobs
Link
19-Mar-2019 19:58:25 by: Juergen Schuster
Carsten Czarski  
Loading data in existing tables with 19.1
APEX 19, Data Loading, Excel
Link
18-Mar-2019 17:34:31 by: Juergen Schuster
Jeffrey Kemp  
Workspace Manager, VPD and APEX
Security
Link
18-Mar-2019 00:26:11 by: Juergen Schuster
Jaydip Bosamiya  
Custom is_authorized function
Authorization
Link
14-Mar-2019 09:10:25 by: Juergen Schuster
GPM Factory France    
New Plug-in: Resource Diagram
Plug-ins
Link
14-Mar-2019 02:59:02 by: Maxime Tremblay
Denes Kubicek    Other
apex.oracle.com will be upgraded to 19.1 on March 15
APEX 19
Link
13-Mar-2019 21:14:06 by: Juergen Schuster
Roel Hartman  
Filtering in Interactive Grid
Interactive Grid
Link
12-Mar-2019 18:09:43 by: Juergen Schuster
Roel Hartman    
New Plug-in: Interactive Grid, add and delete filters
Interactive Grid, Plug-ins
Link
12-Mar-2019 14:50:26 by: Juergen Schuster
Carsten Czarski  
Super-Easy CSV, XLSX, JSON or XML parsing
APEX 19, API
Link
11-Mar-2019 14:29:21 by: Maxime Tremblay
Joel Kallman    Other
apex.oracle.com runs now on 18c
Cloud
Link
09-Mar-2019 20:06:12 by: Juergen Schuster
Maxime Tremblay  Other
New Job: Oracle, India, New Delhi, Permanent, Onsite
Jobs
Link
08-Mar-2019 14:02:52 by: Maxime Tremblay
Jackie Mcilroy    Other
New Podcast: New Jobs for Everybody! #LowHighPodcast
Podcast
Link
07-Mar-2019 23:22:27 by: Jackie Mcilroy
Ronny Weiß    
New Plug-in: Everything you want from a Rich Text Editor
Plug-ins, Rich Text Editor
Link
07-Mar-2019 20:32:14 by: Juergen Schuster
Trent Schafer  
Formatting Datepicker as Uppercase
JavaScript
Link
07-Mar-2019 00:00:40 by: Maxime Tremblay
Peter Raganitsch  
Tomcat Reverse Proxy APEX and ORDS
Installation, ORDS
Link
06-Mar-2019 23:48:55 by: Maxime Tremblay
Joel Kallman  
Quick SQL
Quick SQL
Link
06-Mar-2019 19:31:52 by: Maxime Tremblay
Angel Flores Torres  
Installing APEX on XE on Windows
Installation, XE
Link
06-Mar-2019 19:27:56 by: Maxime Tremblay
Jackie Mcilroy    Other
Live #LowHighPodcast: March 7th, 12pm ET, join and participate
Link
20-Feb-2019 14:38:59 by: Jackie Mcilroy
Marc Sewtz  Other
Office Hours: Social Login, March 7th
Webinar
Link
05-Mar-2019 01:37:42 by: Maxime Tremblay
Hilary Farrell  Other
New Job Offer: Oracle, APEX Dev Team, Continuous Integration, permanent
Link
06-Mar-2019 10:33:32 by: Juergen Schuster
Carsten Czarski  
Report and Form on a REST Service
Form (APEX), REST
Link
05-Mar-2019 01:33:18 by: Maxime Tremblay
Paul Jones    Other
Video: Choosing the Right Report
Reports, Videos
Link
05-Mar-2019 01:30:28 by: Maxime Tremblay
Maxime Tremblay  Other
New Job Offer: Oracle, India, Karnataka, Bangalore, Permanent
Jobs
Link
04-Mar-2019 14:03:40 by: Maxime Tremblay
Adrian Png    Other
Member of the Month, February: For his incredible APEX Challenge Coins and 2 great Blog Posts
Member of the Month
Link
03-Mar-2019 18:59:17 by: Maxime Tremblay
Adrian Png  
Oracle Cloud for APEX - Part 2
Cloud, Hosting
Link
03-Mar-2019 18:46:35 by: Maxime Tremblay

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20