Slack

Is there a way to preserve leading zeroes in an Interactive Report?
22-Jan-2019 12:07:PM by: Ross Henderson
Will explore that and get back to you @maxime_tremblay
22-Jan-2019 12:02:PM by: Kiran D
>This example shows how you can control the ability to update or delete on a per row basis. See the CTRL column that implements a simple rule that managers and presidents cannot be edited or deleted. This column is selected in attribute Edit: Allowed Row Operations Column. Remember to set Source: Query Only to Yes for any column that is an expression that cannot be updated. > >Rows that cannot be edited are show in a darker color when in edit mode.
22-Jan-2019 12:00:PM by: maxime_tremblay
Have a look at the sample interactive grid package application The example “Protected Rows” is exactly what you want
22-Jan-2019 11:59:AM by: maxime_tremblay
Ok :wink:
22-Jan-2019 11:58:AM by: maxime_tremblay
Sorry, rows*
22-Jan-2019 11:57:AM by: Kiran D
You want to disable the columns or rows?
22-Jan-2019 11:56:AM by: maxime_tremblay
Hi All, My scenario is I have to disable "deptno 10" related columns in IG and rest of the department columns should be editable. How to achieve this in IG??
22-Jan-2019 10:54:AM by: Kiran D
You will need to use a REST service to do it. It's normally really quite easy to do.
21-Jan-2019 09:29:AM by: Ross Henderson
Hi ,bug in apex18.2 : when i use popup lov colums in interactive grid for label in chart show me this error 'no_data_found'
20-Jan-2019 09:28:PM by: meysam
:joy:
19-Jan-2019 02:58:PM by: Nadine Bri
2 hours lifetime wasted for a non-existent option :ballot_box_with_check:
19-Jan-2019 02:57:PM by: Nadine Bri
Must be an error :sweat_smile:
19-Jan-2019 02:53:PM by: maxime_tremblay
:see_no_evil:
19-Jan-2019 02:53:PM by: maxime_tremblay
I checked again. It's really there in the documentation, see screenshot. Here the URL: https://docs.oracle.com/en/database/oracle/application-express/18.2/htmig/upgrading-from-previous-Oracle-application-express-release.html#GUID-0E9AC015-883E-406C-96C5-FCAB7CD54CD1
19-Jan-2019 02:11:PM by: Nadine Bri
Ah, OK, thanks. I read in the documentation somewhere that I should have 18.2 in the selection. Therefore I thought that something went wrong...
19-Jan-2019 02:05:PM by: Nadine Bri
5.1/18.1 is the latest so you should go with that one
19-Jan-2019 02:04:PM by: maxime_tremblay
I did some time ago and it’s working :wink:
19-Jan-2019 02:00:PM by: maxime_tremblay
Hi all, I upgraded APEX to 18.2. However, in the app settings compatibility mode, I cannot set the compatibility mode to the current version. There is no 18.2 or 'current version' entry in this dropdown field. Maximum is 5.1 / 18.1. According to documentation, there should be an entry for current version. I already searched the instance settings for a global option which prevents me from doing this, and I also upgraded all offered application items in the app utilities, but without result. Any ideas on this?
19-Jan-2019 10:35:AM by: Nadine Bri
Thanks Maxime! I read this and it sounds like a solution. However, I did not try it out yet.
19-Jan-2019 10:29:AM by: Nadine Bri
Hi, Does anyone have experience sending SMS using APEX application?
18-Jan-2019 09:54:PM by: Didou
Hello !! How create the page of reset password on apex5 ??
18-Jan-2019 11:23:AM by: ERICKP
I don't think there is a way to get the MAC-address. You can run this in the SQL Command window, to see what kind of CGI information you might get. begin owa_util.print_cgi_env(); end;
18-Jan-2019 11:16:AM by: svenweller
Good idea! The log seems to have the info, but it is dificult to distinguish between the various developers. Apex_application_pages is also promising. But it seems empty when looking at it from inside an app. I could grant access to the base tables, but that option limits its usefullness to environments where we can set such a thing up. Also there is the cookie ORA_WWV_REMEMBER_UN which often has the info I want.
18-Jan-2019 11:03:AM by: svenweller
Hello all. if i have multiple Interactive Reports on one page and I need to have an export to CSV button for each of them instead of using the download option under actions. I know I can use this link f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.:CSV: if I have one report on a page. Does anyone know how I can modify this link to work on multiple IR's on one page, each having its own Export to CSV button? thank you!
17-Jan-2019 09:15:PM by: abul_feed
you could try to query apex_workspace_activity_log
17-Jan-2019 07:02:PM by: peterraganitsch
My default solution for this problem is to use two items. One to display which is not stored and one hidden to store.
17-Jan-2019 06:21:PM by: svenweller
From inside an apex app, is there a way to find out which developer is currently logged on/working? Like the APP_USER of the page designer app itself.
17-Jan-2019 06:13:PM by: svenweller
Colleague got it working, I made a mistake (y)
17-Jan-2019 10:54:AM by: Ross Henderson
It doesn't seem unfortunately. I forgot to mention that the key is generated on page load by returning a random 16 digit string via a function. So if I call it again by the computation it will return a new key, not the one that's displayed.
17-Jan-2019 10:16:AM by: Ross Henderson
Thanks Maxime, I'll give it a go today!
17-Jan-2019 08:47:AM by: Ross Henderson
the trick is to set the display item's save session state attribute to no then you will still have the DA populate the displayed value on page submit you will need to have an after submit computation that will set the corresponding value using the same process used to display the value
16-Jan-2019 04:39:PM by: maxime_tremblay
Hey guys, stupid question. I'm trying to generate a key that gets insert into a display only page item, because I don't want the user to be able to edit it. I then I want to use this value to insert into a table via an ARP. But if I insert it using a DA it breaks the session state, and if I use a page load procedure it keeps overwriting it with null. Read Only text-fields also don't work. What silly thing am I doing wrong?
16-Jan-2019 04:33:PM by: Ross Henderson
there’s the article I mentioned https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/6401/index-en.html hope this helps
16-Jan-2019 04:08:PM by: maxime_tremblay
I'll keep that in mind. Luckily, with a closer look at the documentation, I found my error in passing a URL parameter to the web service. Thanks for the help though!
15-Jan-2019 07:39:PM by: jhaut
When I did this I used prepare_url to pass ALL the items back in.
15-Jan-2019 03:13:PM by: Ross Henderson
You should be able to integrate a jquery plugin easily in your app Or even better create a plugin for it
14-Jan-2019 10:28:PM by: maxime_tremblay
Do you have the ORDS debugging option enable and printing to the page? This might also be able to help you https://www.thatjeffsmith.com/archive/2018/10/preventing-500-status-codes-with-oracle-rest-data-services/
14-Jan-2019 10:27:PM by: maxime_tremblay
There is a way to do it but it requires some work You will need to change some attributes of the CKEditor regarding the file manager you will also need to create an APEX page that will handle the file upload and select And on top of that you will need to have a rest service that will handle the file downloading There was an article about how to do all of that
14-Jan-2019 10:23:PM by: maxime_tremblay

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
Eslam_Elbyaly
22-Jan-2019 10:52
Selection doesn't change automatically - Is it a bug?!
Link
0 replies
3417553
22-Jan-2019 10:12
Apex connection problem
Link
1 replies - last reply: - by:
AhmedHelmy
22-Jan-2019 09:44
Jet Chart Stacked Tooltip
Link
1 replies - last reply: - by:
Martijnke
22-Jan-2019 08:53
migrate from apex 3.2 to 18.2
Link
3 replies - last reply: - by:
ar_dev_mea
22-Jan-2019 06:43
PDF generated file store in physical location(oracle directory)
Link
0 replies
user6248358
22-Jan-2019 01:58
Apex Mail
Link
1 replies - last reply: 22-Jan-2019 02:24- by: Scott Wesley
K Cannell, TH
21-Jan-2019 20:16
APEX 18.2 Data Load Wizard w date format - no data found
Link
5 replies - last reply: 22-Jan-2019 04:58- by: K Cannell, TH Tech
Hoek
21-Jan-2019 20:07
APEX 18 - Social sign-in Google keeps on giving "Null username passed to login procedure"
Link
1 replies - last reply: 21-Jan-2019 22:56- by: Scott Wesley
LukeT
21-Jan-2019 18:27
IR report slower in 18.2
Link
0 replies
AmitK05
21-Jan-2019 17:51
Interactive Grid report display in APEX
Link
1 replies - last reply: 21-Jan-2019 20:32- by: Jorgelina
Eslam_Elbyaly
21-Jan-2019 15:06
Debugging in Apex
Link
5 replies - last reply: 22-Jan-2019 04:54- by: Angel Flores T.
Eslam_Elbyaly
21-Jan-2019 15:03
Debugging in Apex
Link
1 replies - last reply: 22-Jan-2019 04:54- by: Angel Flores T.
92e9890f-f55d
21-Jan-2019 14:51
APEX_APPLICATION_PAGES missing
Link
3 replies - last reply: 21-Jan-2019 17:02- by: 92e9890f-f55d-40ae-ad89-c13cf308ff52
Eslam_Elbyaly
20-Jan-2019 18:26
Hosting an apex based website
Link
7 replies - last reply: 21-Jan-2019 20:00- by: Eslam_Elbyaly
ebenwalker
20-Jan-2019 16:16
Tab Key control on an Interactive Grid
Link
1 replies - last reply: 22-Jan-2019 05:02- by: K Cannell, TH Tech
Ananda Basak
18-Jan-2019 19:40
How to set value of a page item on Mouse enter on a report column
Link
6 replies - last reply: 21-Jan-2019 17:50- by: Ananda Basak
Lauricio
18-Jan-2019 11:29
APEX 5.1 send mail
Link
4 replies - last reply: 22-Jan-2019 05:07- by: Angel Flores T.
NelsonMendes
17-Jan-2019 20:32
How to create a validation between 2 date picker fields :PA cannot be > then :PB
Link
9 replies - last reply: 21-Jan-2019 16:43- by: Franck N
PraveenSwa
16-Jan-2019 15:48
Oracle Apex 18.2 - Issue with LoV, Text with Autocomplete and DA
Link
7 replies - last reply: 21-Jan-2019 16:25- by: Jorgelina
idrees
16-Jan-2019 06:03
oracle apex architecture and suggestions for ORDS or Embedded PL/SQL Gateway
Link
2 replies - last reply: 22-Jan-2019 05:14- by: idrees
AhmedHelmy
14-Jan-2019 13:36
Pie Chart Title
Link
5 replies - last reply: 21-Jan-2019 16:12- by: Hilary Farrell-Oracle
Bradley Burge
12-Jan-2019 21:20
Email URL to populated page
Link
2 replies - last reply: - by:
Fahd Bahoo
03-Jan-2019 19:20
Hide Action Button from Interactive Grid
Link
13 replies - last reply: - by:
ouadaz
13-Dec-2018 08:42
Apex 18.1 Bubble Chart label not displayed
Link
1 replies - last reply: 21-Jan-2019 18:03- by: Hilary Farrell-Oracle
Eslam_Elbyaly
09-Dec-2018 10:09
Master-Detail between a form on a table and an interactive grid
Link
12 replies - last reply: 21-Jan-2019 14:50- by: Oleh Tyshchenko

News

X
    
 
ImageNewsFavoriteForward
Jackie Mcilroy    Other
First Live #LowHighPodcast: Feb. 6th, 12pm ET, join and participate
Podcast
Link
17-Jan-2019 19:32:49 by: Juergen Schuster
Jaydip Bosamiya  
Custom Nested Reports
Reports, jQuery
Link
22-Jan-2019 07:41:54 by: Juergen Schuster
Scott Wesley  
Customizing Session Expiry
Session
Link
22-Jan-2019 02:56:39 by: Jackie Mcilroy
Marc Sewtz    Other
Webinar: Municipal Open Data APIs, Feb. 7th
REST, Webinar
Link
21-Jan-2019 18:38:17 by: Juergen Schuster
Dimitri Gielis  Other
Advantages and Disadvantages of APEX new release system
APEX 18, Installation
Link
21-Jan-2019 15:14:17 by: Jackie Mcilroy
Tobias Arnhold  Other
APEX Competition 2019
Press
Link
21-Jan-2019 14:59:05 by: Jackie Mcilroy
morteza mashhadi  
intro.js quick help
Help
Link
19-Jan-2019 12:08:08 by: Juergen Schuster
Carsten Czarski  
Interactive Grid on Web Source Modules Part 2
Interactive Grid, REST
Link
18-Jan-2019 20:15:39 by: Juergen Schuster
Niels de Bruijn  
New Kerberos SSO version
Authentication, SSO
Link
18-Jan-2019 16:19:06 by: Juergen Schuster
morteza mashhadi  
Alternative Reporting in Stimulsoft
Charts, Reports
Link
18-Jan-2019 06:53:37 by: Juergen Schuster
Carsten Czarski    Other
Office Hours: Fuzzy Search, Jan, 24th
Webinar
Link
17-Jan-2019 19:58:11 by: Juergen Schuster
Scott Wesley  
Switch authentication schemes at runtime
APEX 18, Authentication
Link
17-Jan-2019 17:55:35 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: USA, Salt Lake City, permanent, on site
Jobs
Link
17-Jan-2019 15:56:45 by: Juergen Schuster
Scott Wesley  
Social Sign-in Authentication
Authentication, SSO
Link
17-Jan-2019 03:40:09 by: Jackie Mcilroy
Scott Wesley  
Application Session Sharing
APEX 18, Authentication
Link
17-Jan-2019 03:35:48 by: Jackie Mcilroy
Juergen Schuster  Other
New Job Offer: Germany, Munich, permanent, Working Visa
Jobs
Link
15-Jan-2019 20:38:50 by: Juergen Schuster
Juergen Schuster    Other
New Slack Channel: #aop for the free unsupported cloud tier, join
Slack
Link
14-Jan-2019 16:16:04 by: Juergen Schuster
Dimitri Gielis    Other
AOP 19.1 is out, Free to use Development Mode on Cloud
Printing
Link
14-Jan-2019 16:08:31 by: Juergen Schuster
Craig Sykes  
Use Oracle's Apiary to document your Webservice
REST
Link
14-Jan-2019 15:15:29 by: Juergen Schuster
Martin Nielsen  
Maximize JET Charts
JET
Link
13-Jan-2019 19:44:15 by: Juergen Schuster
Andrei Radzetski    
New Plug-in: Load Files from local file system directly to 3rd party cloud providers
File Upload, Plug-ins
Link
11-Jan-2019 18:03:42 by: Juergen Schuster
Patrick Wolf    Other
Video Office Hours: Page Designer
Page Designer, Videos
Link
11-Jan-2019 16:34:47 by: Juergen Schuster
APEXUTIL Wrocław  
Store Files outside the DB into public cloud
File Upload
Link
11-Jan-2019 15:50:03 by: Juergen Schuster
Connor McDonald  
ORDS 404 Error connecting to APEX
Error, ORDS
Link
11-Jan-2019 15:32:16 by: Juergen Schuster
Craig Sykes  
Creating an online leaderboard
Applications
Link
10-Jan-2019 19:58:16 by: Juergen Schuster
Patrick Wolf  Other
Webinar: Page Designer Deep Dive, Office Hours, January 10th
Webinar
Link
10-Jan-2019 03:14:08 by: Jackie Mcilroy
Joel Kallman    Other
New Podcast out: Joel Kallman, Make Oracle Cool Again ( MOCA )
Podcast
Link
09-Jan-2019 19:45:15 by: Juergen Schuster
Juergen Schuster    Other
Newsletter #31 is out!
Newsletter
Link
07-Jan-2019 15:40:08 by: Juergen Schuster
Jackie Mcilroy    Other
New Podcast: Don't Delete the Package! #LowHighPodcast
Podcast, Press, apex.world
Link
06-Jan-2019 17:52:19 by: Jackie Mcilroy
Alexis Galdamez    Other
New Video Training in Spanish
Trainings
Link
05-Jan-2019 00:31:05 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Oracle, USA, San Francisco, permanent
Jobs
Link
04-Jan-2019 20:37:44 by: Juergen Schuster
Simon Boorsma    
New Plug-in: Post-it Stickers
Plug-ins
Link
03-Jan-2019 15:23:16 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20