That's it, Thank you
13-Dec-2018 08:50:PM by: Praveen
in the IR, go in the column's attributes there will be an attribute "escape special characters" set it to no
13-Dec-2018 08:49:PM by: maxime_tremblay
> you will also need to remove the special character escaping for that column (under the column's attributes)
13-Dec-2018 08:48:PM by: maxime_tremblay
not the actual hyperlink
13-Dec-2018 08:48:PM by: Praveen
<a href=""></a>
13-Dec-2018 08:48:PM by: Praveen
thanks for the reply, I tried that option but the results n IR shows as
13-Dec-2018 08:48:PM by: Praveen
easiest is probably to use a case when like this: you will also need to remove the special character escaping for that column (under the column's attributes) ```case when upper(your_column) like 'HTTPS%' then '<a href="' || your_column || '">' || your_column || '</a>' else your_column end```
13-Dec-2018 08:36:PM by: maxime_tremblay
Hi Everyone, I am looking for a solution for below, I have a table column that has values starting with http and other not starting with http. If the value starting with http, in IR report I want to show it as a hyperlink and other just text (not hyperlink), How can I achieve this ?
13-Dec-2018 08:25:PM by: Praveen
nope, doesn't work
13-Dec-2018 05:58:PM by: aldocano29
:smile: :+1:
13-Dec-2018 05:17:PM by: maxime_tremblay
Nice to know. Thank you. First post on slack got simple and elegant solution in very less time. Very helpful community.
13-Dec-2018 05:17:PM by: vramkishore
my pleasure the same concept can apply when displaying an icon. You have the icon as the display value and a text/description column as the filtering values
13-Dec-2018 04:57:PM by: maxime_tremblay
@maxime_tremblay working like a charm. Thank you so much. Appreciate your time and help :+1:
13-Dec-2018 04:56:PM by: vramkishore
ow wow! Thanks @peterraganitsch!
13-Dec-2018 03:47:PM by: Sullivan
I think I tried it... lemme double check
13-Dec-2018 02:56:PM by: aldocano29
I don't know much about this. But could you just set it to 5.0 compatibility mode?
13-Dec-2018 02:55:PM by: Ross Henderson
I know the import process changes some parameters, but I was wondering if there was some kind of mysterious workaround to downgrade that application
13-Dec-2018 02:55:PM by: aldocano29
Hello, is there a way to bring an application that was initially developed in apex 5 but then importes to apex 18, back to apex 5?
13-Dec-2018 02:54:PM by: aldocano29
end result
13-Dec-2018 01:26:PM by: maxime_tremblay
Here’s one way to work around that you will need to have two columns, one for the number value and one with the to_char using your currency’s format e.g. ```select val, format, to_char(val, format) formatted_value from ( select 123456 val, 'FM999G990' format from dual union select 345678 val, 'FML999990' format from dual )``` From what I understood, you will probably be using a case when in the to_char format depending on the currency. then what you need to do is -set the formatted column as “hidden” -set the html expression attribute of the number column to `#FORMATTED_VALUE#`
13-Dec-2018 01:23:PM by: maxime_tremblay
Hi everyone, my team is building an app for developers where we have to enter a PL/SQL anonymous block into a text area, so we need a kind of code editor text area. I'm aware of the already available plugins, but was wondering if I could use some built in (undocumented) Apex API from the application builder. Anyone have some experience with this?
13-Dec-2018 01:08:PM by: Sullivan
Hi. Anyone got an example of an APEX application used for Skills/Resource Management?
13-Dec-2018 01:05:PM by: Sorin
Can we apply conditional format mask in interactive report columns. Example have 2 columns currency and price. Price mask should be applied on basis of currency. Presently we are doing to_char on report query itself but IR between filter is not working as it treating as char
13-Dec-2018 07:14:AM by: vramkishore
Hi trying to make a webservice request using apex web service passing formdata is there any good example onhow to send multi part formdata in a post call
12-Dec-2018 03:47:PM by: deep
Hi. Anyone got any good examples of password protecting a file using PL/SQL. More specifically password protecting a ZIP file. We make use of both APEX_ZIP and Anton Schiffers AS_ZIP ( I did find a forum post, but it doesnt seem to be encrypting the files when I add them. (
12-Dec-2018 09:50:AM by: shaun.mauer
hi all
11-Dec-2018 08:47:PM by: Vinayak
Thank you very much guys! It’s always a pleasure :slightly_smiling_face:
11-Dec-2018 01:20:PM by: maxime_tremblay
Hi all, I have created a Bar chart in Oracle APEX. In Y-axis it is automatically getting sorted alphabetically, even I have used Order by clause. How can I off this automatic sorting. Thank you.
11-Dec-2018 12:53:PM by: Saurabh Sagar Sinha
Seconded! thanks @maxime_tremblay. You are setting an awesome example!
11-Dec-2018 10:03:AM by: Sullivan
Hello everyone. this morning I woke up with the desire to say thank you to @maxime_tremblay for the person he is. indeed, he is always there to help people to move forward he is reactive and thanks again for that.
11-Dec-2018 09:24:AM by: Souleman
You can use javascript:apex.navigation.openInNewWindow() and construct the APEX URL that way.
11-Dec-2018 09:19:AM by: Ross Henderson
Hi All, I have a modal dialog in my application. On click of a button opens this modal dialog which has a classic report in it. This Classic report contains a Link column. Onclick of this link the control closes the modal dialog and navigates to the target link in the parent. My requirement is to open the link of the Classic report in a New tab instead of navigating it to a parent page. When I use in my link it open a blank window in new tab. How can I fix this? Thanks in advance.
11-Dec-2018 09:16:AM by: Prashanth
@shaun.mauer - not that I am aware. I am working on a project now where we would like to do that with 20+ applications. The best we've come to making it happen is to attempt to put what we can into stored procedures/packages and then call that from all of the page zeros. Even though we have multiple page zeros, we have one place to maintain the code.
10-Dec-2018 03:37:PM by: Shane Bentz
@Dominique Denie how about: SELECT APEX_ITEM.SELECT_LIST_FROM_QUERY(3,job,<your function call returning query as varchar2 string text>)job FROM emp
10-Dec-2018 12:11:PM by: Sullivan
Is it possible to have a common page 0 across multiple applications in the same workspace? So have it defined in a "master" application and then all other applications "inherit" that page 0, like we can do with themes and plugins?
10-Dec-2018 11:27:AM by: shaun.mauer
What plugin exactly are you using? I’ve seen some that were able to use a callback function instead of having everything in the title attribute
09-Dec-2018 03:12:PM by: maxime_tremblay
@Souleman Actually, I am not posting a big clob, the return string is of approx. 4200 characters, just a bit above limit. I am having a simple HTML table, summary of some form items and their values
09-Dec-2018 03:38:AM by: eureka7
Hi. for me, posting a clob in a tooltip is not a good approach. Now if you have to do it like that, you could only get the first 4000 characters using SUBSTR.
08-Dec-2018 01:02:PM by: Souleman
Hi All, I am using APEX Tooltip Plugin Item and I have more than 4000 characters in the text to display inside tooltip (which is returned by a function). It's displayed on classic report column. I am getting `buffer too small error`. If I declare as CLOB then I get `inconsistent data type`. ```select task_processed_by ,task_processed_on ,'<span class="req-overview" title="'||get_request_overview(case_id)||'"> <a href="#">'||regexp_replace(comments,'<p>|</p>')||'</a> </span>' as text ,case_id from wf_processing_record``` what to do?
07-Dec-2018 10:15:PM by: eureka7
07-Dec-2018 05:02:PM by: Gcon
07-Dec-2018 12:47:PM by: Souleman
Thanks, I was able to achieve it using JS functions.
07-Dec-2018 12:46:PM by: Prashanth

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
13-Dec-2018 18:14
How to create addtional column in classic report ?
0 replies
13-Dec-2018 16:16
Open an PDF stored in a BLOB in a New tab
0 replies
13-Dec-2018 16:00
Prepare url on remote database
0 replies
13-Dec-2018 15:21
Interactive Grid: Dynamic Action when deleting a row
1 replies - last reply: 13-Dec-2018 16:21- by: John Snyders-Oracle
13-Dec-2018 15:20
How can i call database function return value in HTML button click in SQL query
1 replies - last reply: 13-Dec-2018 16:17- by: Franck N
13-Dec-2018 15:00
APEX Migration to OCI
0 replies
Fernanda JB
13-Dec-2018 13:47
Doubts - how does the sample application "Survey Builder" save the survey responses?
1 replies - last reply: 13-Dec-2018 16:35- by: John Snyders-Oracle
13-Dec-2018 12:51
Displaying images in a grid-like view
1 replies - last reply: 13-Dec-2018 13:02- by: fac586
13-Dec-2018 12:30
1 replies - last reply: 13-Dec-2018 12:41- by: Manjunath666
bhatt t
13-Dec-2018 12:07
Apex on Cloud.
1 replies - last reply: 13-Dec-2018 12:36- by: fac586
bhatt t
13-Dec-2018 12:06
Cloud for Apex
1 replies - last reply: 13-Dec-2018 15:07- by: InoL
13-Dec-2018 11:35
APEX 5 LOV ORA-01722: invalid number
0 replies
13-Dec-2018 09:58
Apex 18.2 Tabular Form issue with varchar2(32767) data
1 replies - last reply: 13-Dec-2018 12:20- by: Carsten Czarski-Oracle
CJ Bell
13-Dec-2018 09:40
Menu based values in a DB table
1 replies - last reply: 13-Dec-2018 13:50- by: fac586
13-Dec-2018 09:40
Apex 18.1 Bubble Chart with X-Axis as Date
2 replies - last reply: 13-Dec-2018 13:59- by: ouadah
13-Dec-2018 08:57
P-Track of APEX, Create Project.Then the Chrome page is blank. Please help me,Thank you!
0 replies
13-Dec-2018 08:44
Apex Scatter Chart : changing the size of the marker
9 replies - last reply: 13-Dec-2018 15:33- by: ouadah
13-Dec-2018 00:33
Interactive grid conditional LOV
1 replies - last reply: 13-Dec-2018 17:48- by: Sgodavar-Oracle
12-Dec-2018 19:15
IG with authorisation shows hidden ROWID column (bug?)
3 replies - last reply: 13-Dec-2018 13:31- by: InoL
12-Dec-2018 12:29
How to create link in classic report column which will redirects to multiple pages based on conditio
6 replies - last reply: 12-Dec-2018 12:29- by: Manjunath666
11-Dec-2018 17:57
Client Certificate Authentication - Apex_Web_Service
10 replies - last reply: 13-Dec-2018 17:00- by: CInglez
09-Dec-2018 09:59
Interactive grid
2 replies - last reply: 13-Dec-2018 12:58- by: Eslam_Elbyaly
07-Dec-2018 21:22
Oracle APEX 18.2 with Oracle XE 18 - Low performance
18 replies - last reply: 13-Dec-2018 14:16- by: M.Emmanuel
Soukaina IDRI
10-Nov-2018 19:59
How to create dynamic overview of customer 360 degree
9 replies - last reply: 13-Dec-2018 16:33- by: Soukaina IDRISSI
30-Oct-2018 13:05
Validate Interactive Grid to ensure at least one row submitted
4 replies - last reply: 13-Dec-2018 15:09- by: 3761021


Saeed Hassanpour  
Persian Datepicker Options
14-Dec-2018 02:01:31 by: Jackie Mcilroy
Dick Dral  
Styling Lines in Classic Reports
14-Dec-2018 01:57:43 by: Jackie Mcilroy
Peter Raganitsch  
APEX upgrade in 3 minutes
12-Dec-2018 10:25:41 by: Juergen Schuster
Adrian Png  Other
Video: Blockchain in APEX
Blockchain, Videos
12-Dec-2018 10:21:27 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Massachusetts, Boston, permanent
11-Dec-2018 19:14:56 by: Juergen Schuster
Kevin Rutten    
New Plug-in: PDF from SQL Query
11-Dec-2018 08:57:05 by: Juergen Schuster
Simon Boorsma    
New Plug-in: Oracle Digital Assistant Chat Box
10-Dec-2018 18:06:51 by: Juergen Schuster
Marko Gorički  
Bug with duplicating radio groups
10-Dec-2018 12:21:18 by: Juergen Schuster
Denis Savenko  
Installation Guide P2
09-Dec-2018 17:36:43 by: Juergen Schuster
Francis Mignault  
Forms Modernization
Forms (Oracle Forms)
07-Dec-2018 18:08:18 by: Juergen Schuster
Learco Brizzi    Other
New Conference: APEX World 10th jubilee, March 25,26th, Rotterdam, Netherlands
07-Dec-2018 13:15:33 by: Juergen Schuster
Niels de Bruijn  
Single Sing On for APEX
07-Dec-2018 06:16:18 by: Juergen Schuster
Souleman DEMBELE    
New Plug-in: Get plain numbers out of formated numbers
05-Dec-2018 21:14:58 by: Juergen Schuster
Adrian Png    
Low Code Development Systems
05-Dec-2018 21:11:39 by: Juergen Schuster
Jackie Mcilroy    Other
Newsletter #30 is out!
Newsletter, Press,
05-Dec-2018 17:26:19 by: Jackie Mcilroy
Jackie Mcilroy    Other
New Podcast: Never Apologize! #LowHighPodcast
Podcast, Press,
05-Dec-2018 15:17:56 by: Jackie Mcilroy
John Snyders  
Thoughts on Progressive Web Apps (PWA)
Progressive Web Applications
05-Dec-2018 03:42:12 by: Jackie Mcilroy
Sam Khalaf  
Integration with AWS Simple Email Service
05-Dec-2018 03:37:37 by: Jackie Mcilroy
Lucas Rayner  
Show Alerts with Dynamic Actions
Dynamic Actions
04-Dec-2018 09:35:42 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Florida, Orlando, contract, on-site
03-Dec-2018 18:25:32 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: California, San Francisco, contract, on-site
03-Dec-2018 18:24:09 by: Juergen Schuster
Ronny Weiß    Other
Member of the Month November: Consistent delivery of high quality Plug-ins
Member of the Month
01-Dec-2018 12:42:59 by: Juergen Schuster
Oleksii Vykhrystiuk    Other
Internet Use Case with APEX
Applications, Internet
01-Dec-2018 12:22:06 by: Juergen Schuster
Matt Mulvaney    
Application Archives
Installation, Versioning
30-Nov-2018 20:46:40 by: Juergen Schuster
mike hichwa    Other
What do you use APEX for?
30-Nov-2018 20:43:09 by: Juergen Schuster
Vincent Morneau  Other
Video: Progressive Web Apps (PWA)
Mobile, Videos
29-Nov-2018 23:15:00 by: Juergen Schuster
Joel Kallman    Other
29-Nov-2018 16:15:35 by: Juergen Schuster
Jackie Mcilroy    Other
Video: Dynamic Actions for Beginners
Dynamic Actions, Videos
29-Nov-2018 15:50:45 by: Juergen Schuster
Adrian Png  
Quick Environment Setup with Lora
29-Nov-2018 11:04:45 by: Jackie Mcilroy
Ronny Weiß    
New Plug-in: QR-Code Scanner
28-Nov-2018 23:44:43 by: Juergen Schuster
Juergen Schuster    Other
Recorded beginners training 5.1 in Hindi
28-Nov-2018 11:13:39 by: Juergen Schuster
Ezequiel Portela    
New Plug-in: Number Fields
27-Nov-2018 01:50:55 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20