Slack

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="http://xxxx.com.us.oracle.com:27011/console">http://xxxx.com.us.oracle.com:27011/console</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 (https://technology.amis.nl/wp-content/uploads/2010/06/as_zip10.txt). I did find a forum post, but it doesnt seem to be encrypting the files when I add them. (https://community.oracle.com/message/10735886#10735886)
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 window.open 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
Great
07-Dec-2018 05:02:PM by: Gcon
:wink::+1::skin-tone-3:
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
TRM
13-Dec-2018 18:14
How to create addtional column in classic report ?
Link
0 replies
Amorimpersona
13-Dec-2018 16:16
Open an PDF stored in a BLOB in a New tab
Link
0 replies
user12031801
13-Dec-2018 16:00
Prepare url on remote database
Link
0 replies
3761021
13-Dec-2018 15:21
Interactive Grid: Dynamic Action when deleting a row
Link
1 replies - last reply: 13-Dec-2018 16:21- by: John Snyders-Oracle
TRM
13-Dec-2018 15:20
How can i call database function return value in HTML button click in SQL query
Link
1 replies - last reply: 13-Dec-2018 16:17- by: Franck N
User806476-Or
13-Dec-2018 15:00
APEX Migration to OCI
Link
0 replies
Fernanda JB
13-Dec-2018 13:47
Doubts - how does the sample application "Survey Builder" save the survey responses?
Link
1 replies - last reply: 13-Dec-2018 16:35- by: John Snyders-Oracle
Eslam_Elbyaly
13-Dec-2018 12:51
Displaying images in a grid-like view
Link
1 replies - last reply: 13-Dec-2018 13:02- by: fac586
Kayal
13-Dec-2018 12:30
Reg ACL
Link
1 replies - last reply: 13-Dec-2018 12:41- by: Manjunath666
bhatt t
13-Dec-2018 12:07
Apex on Cloud.
Link
1 replies - last reply: 13-Dec-2018 12:36- by: fac586
bhatt t
13-Dec-2018 12:06
Cloud for Apex
Link
1 replies - last reply: 13-Dec-2018 15:07- by: InoL
1975966
13-Dec-2018 11:35
APEX 5 LOV ORA-01722: invalid number
Link
0 replies
fme
13-Dec-2018 09:58
Apex 18.2 Tabular Form issue with varchar2(32767) data
Link
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
Link
1 replies - last reply: 13-Dec-2018 13:50- by: fac586
ouadah
13-Dec-2018 09:40
Apex 18.1 Bubble Chart with X-Axis as Date
Link
2 replies - last reply: 13-Dec-2018 13:59- by: ouadah
48ce1dc1-5abb
13-Dec-2018 08:57
P-Track of APEX, Create Project.Then the Chrome page is blank. Please help me,Thank you!
Link
0 replies
ouadah
13-Dec-2018 08:44
Apex Scatter Chart : changing the size of the marker
Link
9 replies - last reply: 13-Dec-2018 15:33- by: ouadah
Sgodavar-Orac
13-Dec-2018 00:33
Interactive grid conditional LOV
Link
1 replies - last reply: 13-Dec-2018 17:48- by: Sgodavar-Oracle
InoL
12-Dec-2018 19:15
IG with authorisation shows hidden ROWID column (bug?)
Link
3 replies - last reply: 13-Dec-2018 13:31- by: InoL
Manjunath666
12-Dec-2018 12:29
How to create link in classic report column which will redirects to multiple pages based on conditio
Link
6 replies - last reply: 12-Dec-2018 12:29- by: Manjunath666
CInglez
11-Dec-2018 17:57
Client Certificate Authentication - Apex_Web_Service
Link
10 replies - last reply: 13-Dec-2018 17:00- by: CInglez
Eslam_Elbyaly
09-Dec-2018 09:59
Interactive grid
Link
2 replies - last reply: 13-Dec-2018 12:58- by: Eslam_Elbyaly
M.Emmanuel
07-Dec-2018 21:22
Oracle APEX 18.2 with Oracle XE 18 - Low performance
Link
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
Link
9 replies - last reply: 13-Dec-2018 16:33- by: Soukaina IDRISSI
3761021
30-Oct-2018 13:05
Validate Interactive Grid to ensure at least one row submitted
Link
4 replies - last reply: 13-Dec-2018 15:09- by: 3761021

News

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

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20