Slack

@thomas yes it will do the job
19-Nov-2017 11:30:AM by: vinit
Hmm, I see how the sample did it. The way it is our application is we have a classic report of the attachments. Do I simply add a column with a link that executes a PLSQL code when clicked?
19-Nov-2017 01:49:AM by: thomas
@maxime_tremblay I appreciate the guidance. I'll check it out myself
19-Nov-2017 01:26:AM by: thomas
@thomas Of course it can be done :slightly_smiling_face: I would recommend you have a look at the "Sample File Upload and Download" packaged application
19-Nov-2017 01:17:AM by: maxime_tremblay
Hey guys happy weekend. I have a general question, so in my application I have it where users are able to upload file attachments. Is there a way for those users to delete those attachments? Thank you. Much love.
18-Nov-2017 11:04:PM by: thomas
Thank you very much. This definetely helps!
18-Nov-2017 07:07:PM by: steven
Thanks
18-Nov-2017 04:59:AM by: merv
Branching perhaps !!
17-Nov-2017 06:21:PM by: ashwinrao
Hi, is there an option in APEX to redirect to a page using the new ID after inserting a new record?
17-Nov-2017 05:06:PM by: merv
See whether this helps : http://roelhartman.blogspot.nl/2013/05/using-ldap-for-authentication-and.html
17-Nov-2017 11:16:AM by: roelhartman
Hey Guys, does anybody know how I can delate a Private Report View in a Interactive Grid from Users?
17-Nov-2017 10:07:AM by: martin_wolz
How to disable tabular form POPUP LOV?
17-Nov-2017 10:00:AM by: muhammadubaid
@lokeshsurana Have a look here https://www.slideshare.net/nielsdb/mt-ag-howtosingle-signonforapexapplicationsusingkerberos-46435415 https://www.slideshare.net/nielsdb/single-signon-for-apex-apps @nielsdb has done alot of work in this area
17-Nov-2017 06:39:AM by: shaun.mauer
Happy to help!
16-Nov-2017 08:29:PM by: doug.a.gault
It worked perfect, thank you very much @doug.a.gault :clap:
16-Nov-2017 08:29:PM by: galeanomario
What are only numeric values. Your query is returning HTML. You need to make sure the column displaying that is not Escaping Special characters. In the SECURITY section of the attributes for the column look at the “Escape Special Characters” attribute. It should be set to “NO”.
16-Nov-2017 08:06:PM by: doug.a.gault
@doug.a.gault they are only numerical values
16-Nov-2017 08:03:PM by: galeanomario
You also need to make sure the report column isn’t escaping special characters.
16-Nov-2017 07:58:PM by: doug.a.gault
CASE WHEN UPPER(sd2.D2_QTDAFAT)= 0 THEN '<i class="fa fa-check fa-2x" style="color: green;"></i>' ELSE '<i class="fa fa-remove fa-2x" style="color: red;"></i>' END Estado,
16-Nov-2017 07:53:PM by: galeanomario
This is my sql query
16-Nov-2017 07:53:PM by: galeanomario
OK thank you very much
16-Nov-2017 07:43:PM by: galeanomario
Hi Required guidance We have application desktop shortcut As user clicks it needs to open application by authenticating windows machine user name password Don’t want user enter username password We using LDAP AD. It’s same functionality of SSO But it’s required multiple application server install Is there any quick way we can have this without installing multiple authentication server or minimum install which free available Thanks
16-Nov-2017 07:07:PM by: lokeshsurana
Thanks! That's what I'm doing at the moment, but as that computation is part of a report, end users can't manipulate that column to create, f.e., a sum of those ammounts... I was wondering if there exists a better option, but thanks for your reply!!
16-Nov-2017 08:01:AM by: ingolmo
Thanks for the mention Alex. Here’s a technique I’ve used: https://github.com/rimblas/jtlitem It’s a combination technique and plugin. It works really well for many situations. What it doesn’t do, is translate for you, someone still needs to know the translation and type it in.
15-Nov-2017 11:19:PM by: rimblas
Any issues while using Apex_mail.add_attachment?
15-Nov-2017 05:37:PM by: ashwinrao
pretty sure @rimblas has done this. Saw a demo at kscope :slightly_smiling_face:
15-Nov-2017 04:44:PM by: turntablez
does PL/SQL or by using Apex API's can we achieve this? or is there a workaround for this in Pl/SQL I'm using APi's like APEX_MAIL.SEND, APEX_MAIL.ADD_ATTACHMENTS..
15-Nov-2017 02:37:PM by: rajeshreddy469
Hi everyone, i been trying to write a procedure in which the user has to be emailed with an attachment of BIP report. I was able to send out an email with "shared report link" of BIP report in email, but requirement is to send that report as an attachment instead of the link.. so to avoid showing users the URL and eliminating the steps of clicking the link and opening it in a browser were the report would run and downloaded to there local machine.. we are using oracle apex 5.1.3 oracle BI publisher 11g
15-Nov-2017 02:32:PM by: rajeshreddy469
these two posts might be helpful http://www.explorer.uk.com/web-services-part-1/ http://www.explorer.uk.com/ordsoauth2-web-services-in-apex-part-2/
15-Nov-2017 02:25:PM by: maxime_tremblay
is anyone made any translator screen ? that translate input text on runtime ... guide me
15-Nov-2017 11:47:AM by: ahmed193
I´m sorry but I don´t use JasperReport so I can´t help you there
15-Nov-2017 08:56:AM by: apex_student
Is anyone out here, who has experience with the integration of APEX (via REST) with Microsoft Graph? In fact I need a secure OAuth2 connection which I would love to sync up with an LDAP login for my APEX-app, so I would be able to write to the database and Microsoft Graph e.g. SharePoint at the same time. Any hints or resources appreciated!
15-Nov-2017 08:45:AM by: steven
Hi @maxime_tremblay we are using Application Express 5.1.3.00.05
15-Nov-2017 06:42:AM by: cremy
BTW, this is a form based on one table, it has an CLOB col, rest col are just varchar2 and number.., this error happened when user save the changes. I checked and none col is actually having more than 4000 characters, which is kind of wired
14-Nov-2017 09:31:PM by: mike286
Apex5 ORA-01461, how to find the offending col: I had a old form that has been running long long time and I got this error today, I am trying to find the offending col which caused this error but had a hard time, I remember once that there is a place where you can see the actual sql behind the screen but I kind of forgot where/how to get it, anyone know how to find the offending col? Thanks
14-Nov-2017 09:27:PM by: mike286
when subtracting two timestamps the result is a INTERVAL DAY so you'll need to use the EXTRACT function to display the difference something like this: ```select abs(extract(hour from diff)) || ':' || to_char(abs(extract(minute from diff)), 'FM00') d from (select systimestamp - to_timestamp('14/11/17 13:00:00.000', 'dd/mm/rr HH24:MI:SS.FF3') DIFF from dual) ```
14-Nov-2017 09:07:PM by: maxime_tremblay
Thank you @maxime_tremblay for all your help! :+1:
14-Nov-2017 06:27:PM by: kimada
can you explain further what is not working?
14-Nov-2017 05:34:PM by: maxime_tremblay
@maxime_tremblay I tried that as well, but it also did not work.
14-Nov-2017 05:31:PM by: kimada
you'll need to do it using a dynamic action instead of using the condition on the item itself create an onchange dynamic action on the item you referenced in the condition you previously had define client side condition (Value of Item/Column in Expression 1 = Expression 2) then define a true and a false action the true action will show the textarea, and the false will hide it
14-Nov-2017 05:23:PM by: maxime_tremblay

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
Ud_smith
18-Nov-2017 20:49
APEX_ITEM.CHECKBOX CHECK ALL AND PRESERVE CHECKBOX
Link
1 replies - last reply: 18-Nov-2017 22:42- by: LA County APEX
marussig
18-Nov-2017 19:27
Can not connect to apex.oracle.com
Link
0 replies
MD. MASUD
18-Nov-2017 16:39
How to use Next & Previous Button for moving cursor in classic Report
Link
1 replies - last reply: 18-Nov-2017 23:04- by: LA County APEX
NicoB
18-Nov-2017 15:23
change background color of APEX app login page
Link
4 replies - last reply: 18-Nov-2017 16:56- by: NicoB
Gor_Mahia
18-Nov-2017 11:50
Create template using bi API for word and load into Apex shared component
Link
1 replies - last reply: 18-Nov-2017 20:05- by: LA County APEX
Turlock22
18-Nov-2017 01:29
Server-side conditions on dynamic actions
Link
1 replies - last reply: 18-Nov-2017 07:16- by: fac586
MMaring
17-Nov-2017 21:50
Manage static file cache
Link
0 replies
3001577
17-Nov-2017 19:13
APEX run faster
Link
5 replies - last reply: 17-Nov-2017 20:42- by: InoL
Sgodavar-Orac
17-Nov-2017 19:05
Rich Text field in Tabular form/Interactive grid
Link
2 replies - last reply: 17-Nov-2017 19:21- by: Sgodavar-Oracle
BillC
17-Nov-2017 17:40
GRID bug? -Modal Dialog only shows 40 rows.
Link
0 replies
Efarah-Oracle
17-Nov-2017 17:36
APEX - Open LDAP
Link
2 replies - last reply: 17-Nov-2017 19:58- by: Efarah-Oracle
pawuyulan
17-Nov-2017 15:56
Standard way to show a list of images to be chosen?
Link
2 replies - last reply: 17-Nov-2017 18:20- by: fac586
SteveO222
17-Nov-2017 14:36
Exporting uploaded files to a new server.
Link
3 replies - last reply: 18-Nov-2017 10:45- by: fac586
ICeT
17-Nov-2017 14:28
pdf printing using xsl-fo and ORD (formating issue with CLOB column)
Link
3 replies - last reply: 17-Nov-2017 17:49- by: Mike Kutz
Carlos Codria
17-Nov-2017 14:02
Application with apex 5.1.0 deploy well with custom theme, apex 5.1.3 deploys it badly
Link
3 replies - last reply: 18-Nov-2017 12:01- by: fac586
Tviz21
17-Nov-2017 13:57
Interactive Grid and bulk updates
Link
4 replies - last reply: 18-Nov-2017 01:46- by: John Snyders-Oracle
Vedant
17-Nov-2017 10:29
Disable / Editable Column in Tabular Form
Link
1 replies - last reply: 18-Nov-2017 20:34- by: LA County APEX
user5108636
17-Nov-2017 02:04
email csv with some records in APEX.
Link
3 replies - last reply: 17-Nov-2017 19:54- by: Mike Kutz
VANJ
16-Nov-2017 22:04
List of Values - Disabled options
Link
1 replies - last reply: 17-Nov-2017 16:58- by: VANJ
Soukaina IDRI
15-Nov-2017 13:06
Trouble clicking the button maximize in standard template
Link
3 replies - last reply: 17-Nov-2017 13:48- by: Yog
Emily-feng-Or
15-Nov-2017 07:44
About data types that can be referred to in APEX
Link
3 replies - last reply: 18-Nov-2017 15:02- by: fac586
Kam_oracle_ap
14-Nov-2017 08:13
Enable/Disable Interactive Grid Column (APEX 5.1.3)
Link
5 replies - last reply: 17-Nov-2017 16:44- by: J-Lig
Runrig
03-Oct-2017 21:00
Apex 5.1 : Session State of Modal Dialog not updating. Debug shows different value ?
Link
4 replies - last reply: 17-Nov-2017 17:29- by: BillC
Sjuzer
19-Sep-2017 11:39
Creating data load wizard for multiple tables
Link
17 replies - last reply: 18-Nov-2017 12:57- by: Sjuzer
Bernhard Fisc
06-Jun-2017 12:54
Success Message to fade
Link
13 replies - last reply: 17-Nov-2017 17:31- by: BillC

News

X
    
 
ImageNewsFavoriteForward
Tim Halbach  
Buttons in Reports
Reports
Link
18-Nov-2017 09:32:04 by: Juergen Schuster
David Anderson    Other
New APEX Trainings available
Trainings
Link
17-Nov-2017 04:49:27 by: Juergen Schuster
John Keymer  
Security Risk: List of Values
LOVs, Security
Link
13-Nov-2017 16:47:59 by: Juergen Schuster
COLIN ARCHER  
ORDS, OAuth2 & Web Services Part 2
OAuth2, REST
Link
13-Nov-2017 15:25:41 by: Juergen Schuster
Juergen Schuster  Other
New Job-Offer: UK, Leads, permanent, onsite
Jobs
Link
13-Nov-2017 11:47:34 by: Juergen Schuster
Juergen Schuster  Other
New Job-Offer: Germany, Bensheim, permanent, onsite, with Mr. APEX Denes Kubicek himself
Jobs
Link
10-Nov-2017 13:34:22 by: Juergen Schuster
Juergen Schuster  Other
New Job-Offer: Germany, Dresden, Permanent
Jobs
Link
10-Nov-2017 09:34:23 by: Juergen Schuster
Juergen Schuster  Other
New Projekt-Offer: Germany, Frankfurt, onsite, 250 days
Jobs
Link
09-Nov-2017 17:33:58 by: Juergen Schuster
Adrian Png  
Write high quality JavaScript in APEX
JavaScript
Link
09-Nov-2017 06:03:26 by: Juergen Schuster
John Snyders  
Internal Insights about APEX JavaScript
JavaScript, Plug-ins
Link
08-Nov-2017 22:39:35 by: Juergen Schuster
Patrick Cimolini    Other
New Book: APEX by Design
Books
Link
08-Nov-2017 07:10:38 by: Juergen Schuster
Alexander Warkus    
New Plug-in: FancyTree
Plug-ins, Tree
Link
07-Nov-2017 07:21:22 by: Juergen Schuster
Ronny Weiß    
New Plug-in: Avent Calendar
Plug-ins
Link
06-Nov-2017 20:41:30 by: Juergen Schuster
Roberto Capancioni  Other
Quick SQL
Quick SQL
Link
02-Nov-2017 20:30:43 by: Juergen Schuster
Steven Feuerstein  
Don't repeat LOVs
LOVs, PL/SQL
Link
02-Nov-2017 13:26:27 by: Juergen Schuster
Marko Gorički    
New Plug-in: Extend Interactive Grid Toolbar
Interactive Grid
Link
01-Nov-2017 22:07:56 by: Juergen Schuster
Shakeeb Rahman    Other
Sneak Peak 5.2 Page Designer
APEX 5.2, Page Designer
Link
01-Nov-2017 16:54:47 by: Juergen Schuster
Joel Kallman    Other
In past week on @Oracle's internal corporate instance of #orclapex: 4,479,719 page views, 3,356 apps, 36,942 users. Real & proven solutions!
Press
Link
01-Nov-2017 16:52:29 by: Juergen Schuster
Juergen Schuster    Other
Newsletter #17 is out!
Newsletter
Link
01-Nov-2017 15:24:28 by: Juergen Schuster
Roel Hartman    Other
Member of the Month: October for excellent 2 Plug-ins, 2 Blog-Posts, ODTUG Board of Directors
Member of the Month
Link
01-Nov-2017 15:22:04 by: Juergen Schuster
Roel Hartman  
Using multiple Authentication Schemas for the same APEX App
Authentication
Link
31-Oct-2017 18:20:06 by: Juergen Schuster
Vincent Morneau    
New Plug-in: Animate APEX components
Plug-ins
Link
30-Oct-2017 18:30:23 by: Juergen Schuster
Juergen Schuster    Other
apex.world On Air Show: All about Security Part 2
On Air, Security, Webinar
Link
30-Oct-2017 16:28:09 by: Juergen Schuster
Juergen Schuster    Other
apex.world On Air Show: All about Security Part 1
On Air, Security, Webinar
Link
30-Oct-2017 16:26:36 by: Juergen Schuster
Maxime Tremblay    Other
5.2 EA2 coming soon
APEX 5.2
Link
30-Oct-2017 16:00:05 by: Juergen Schuster
Martin D'Souza  
Reset Authorization Cache
Authorization
Link
30-Oct-2017 15:53:35 by: Juergen Schuster
Martin D'Souza  
Using Listagg in Interactive Report Sums
Interactive Grid
Link
30-Oct-2017 15:48:32 by: Juergen Schuster
COLIN ARCHER  
ORDS, OAuth2 & Web Services Part 1
OAuth2, ORDS, REST
Link
30-Oct-2017 10:37:08 by: Juergen Schuster
Vincent Morneau    
The Best Alternative to Universal Theme
Universal Theme, User Interface
Link
27-Oct-2017 15:54:28 by: Juergen Schuster
Sven Weller  
Interactive Grid Customize Toolbar Buttons
Interactive Grid
Link
27-Oct-2017 15:50:51 by: Juergen Schuster
Joel Kallman    Other
Customer Success Story (Video)
Customers, Videos
Link
27-Oct-2017 11:23:47 by: Juergen Schuster
David Anderson    Other
13 New APEX Trainings
Trainings
Link
25-Oct-2017 20:09:02 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20