Slack

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
Hello all. is there a way to export an Interactive Report with a subtotal row that was created using Actions > Format > Aggregate?
18-Mar-2019 09:18:PM by: abul_feed
I am having this trouble. So when a new user requests for a new workspace and thet get an email saying Workspace Request Approved, I click on Create workspace. It takes me to this page.But when I click on Continue to Sign in screen, it does not redirect to anything. Background - I am trying to run wwv_flow_api.set_security_group_id (p_security_group_id => apex_util.find_security_group_id (p_workspace => 'ROSYPARMAR1') ); APEX_180200.wwv_flow_fnd_developer_api.f4050_55_provision_workspace(p_provision_id => i.id,p_approval_message => 'Approved',p_acceptance_message => 'Approved'); wwv_flow_api.set_security_group_id (p_security_group_id => 10 ); -- security group id of admin user APEX_180200.wwv_flow_fnd_developer_api.f4700_73_provision_workspace ( p_provision_id =>i.id, p_sign_in_url => l_url, p_msg => l_msg);
18-Mar-2019 07:04:PM by: rosyparmar
server side will not generate the region at all in the html whereas using a dynamic action will simply hide it and its html will still be available to the user when using the server-side condition you will not have to process what is in that region, so page would load a little bit faster if you need to show or hide the region dynamically according to let’s say an item’s value, then the dynamic action is probably what you need otherwise you should probably use a server-side condition
18-Mar-2019 05:08:PM by: maxime_tremblay
which one is column 1 and which one is column 2? are they both editable?
18-Mar-2019 05:05:PM by: maxime_tremblay
@Amit I haven't tried this w/ a tab form, but for a regular form, I would: Create a dynamic action for PG#_Field_1, ON CHANGE of pg#_field_1, with a TRUE action of SET VALUE, of whatever "Set Type" you prefer. "Items to Submit" would be pg#_field_1. Affected Elements would be Item(s), pg#_field_2 The Set Type I use is SQL Query, and I usually want to CASE WHEN :pg#_field_2 IS NULL as part of my query.
18-Mar-2019 04:49:PM by: Marc Visconte
When showing/hiding regions, what is the best practice: Using the Server-Side Conditioning or is using Dynamic Actions okay as well?
18-Mar-2019 04:31:PM by: Ross Henderson
10 is also come automatically in revised est amt column.
18-Mar-2019 09:38:AM by: Amit
Hi All, i am using tabular form in oracle apex 5.0 and i have a requirement like what ever values in Column 1 that exactly copy to column 2 and when column 1 values is changed by user then column 2 values also changed while submit the tabular form. how can i achive this one. i am also using some java script but it's not full fill the requirement. @maxime_tremblay
18-Mar-2019 09:38:AM by: Amit
@svenweller Thanks i was try but didn't fetch mac. after i used this procedure owa.cgi_var_name('Parameter Name') ;
15-Mar-2019 12:38:PM by: aditya_shah3592
Got the easiest solution :grinning: .Download all the static files as zip. Remove the folder which are not required in the downloaded file.Delete all the static files by clicking on "Delete All Files".Then upload the zip file again.
15-Mar-2019 07:36:AM by: Pk
Hi Guys,I have uploaded a zip file in the "Static Application Files" by creating directory "TEMP".The zip file have many folder and sub folder.I want to delete all the files in the TEMP directory instead of deleting individual file .Is there a way to delete it.Any plsql code which will delete the files ?
15-Mar-2019 05:00:AM by: Pk
@demahA https://community.oracle.com/thread/4132968
14-Mar-2019 01:08:PM by: fahad qadir
Hi, How can i change the font of my Oracle Apex Application?
14-Mar-2019 12:31:PM by: demahA
Hi Guys, I am trying to post file using slack web api (files.upload method) to slack channel through rest services. I am facing this response - "invalid_form_data" on running this. Any help/suggestion on this would be appreciated. I would like to know how to pass the parameters to this api. Reference link : https://api.slack.com/methods/files.upload. I am following the article https://emoracle.wordpress.com/2014/11/14/oracle-plsql-integration-with-slack/. Thanks.
14-Mar-2019 08:24:AM by: ashwinrao
Here’s what I would check No need to move the plsql action in an Ajax callback yet, unless you want to have only one JavaScript action or that you want to have it in a pure javascript way (no dynamic action) Make sure that the items you set in the JavaScript action are also define in the plsql action “items to submit” attribute This will make sure as Swen suggested that you have the new values in session state for the plsql action If it still does work I would add some logging in the two actions to be able to trace everything `console.log` for the JavaScript action and `apex_error.message` for the plsql
13-Mar-2019 01:32:PM by: maxime_tremblay
I've been using ORDSYS.ORDImage to resize some images in an old apex application. The application is being moved onto a new database where Oracle Multimedia is not installed. Any ideas on alternatives?
12-Mar-2019 10:23:PM by: trevorh
1. Remove the WHEN OTHERS part. If an error happens you want to see everything, not just the part that you grabed with SQLERRM. 2. The problem most likely is that the javascript actions sets the page items, but those values are not in the database session state. Just think that both actions run at the same time. The solution to that is to use a single javascript action. First create an on demand process (can be on page level) with your update and then call it via apex.server.process inside the same javascript action that sets the values. https://docs.oracle.com/database/121/AEAPI/javascript_api.htm#AEAPI29523 You can set the values either by saveing the pageitems or by sending them via X01, X02.
12-Mar-2019 05:46:PM by: svenweller
I have list of tables and want to know the usage of them in apex application. I can use application sea rch feature but is there any way that I can find out through any query ?
12-Mar-2019 05:32:PM by: vramkishore
It is not working maxime and not getting any errors
12-Mar-2019 04:14:PM by: arjun
is it working or not? do you get any error?
12-Mar-2019 04:07:PM by: maxime_tremblay
I usually join the tables as well
12-Mar-2019 04:06:PM by: maxime_tremblay
I am going to be moderating an APEX Panel on Thursday and am in need of some filler questions if we dont get enough from the attendees. What are some good questions? The skill levels of the people attending range from experienced to novices, so really anything is good. I can always post back answers if people are interested in them.
12-Mar-2019 03:41:PM by: Alan Quigley
Hi All, How to achieve "auto save" interactive report data. https://apex.oracle.com/pls/apex/f?p=1610:1:106623805720845::::: Workspace:arjun_ind Username:arjun_ind Password:arjun_ind I have followed below process. Report Query. SELECT ename,deptno,job,mgr, comm, APEX_ITEM.TEXT(p_idx => 4, p_value => sal, p_size => 10 , p_attributes => 'onblur="javascript:apex.event.trigger(document, ''onChangeField'', [{sal:this.value, wr_type:'''||sal||'''}]);void(0);"') as sal FROM emp; Dynamic Action. Event:Custom Custom Event:onChangeField Selection Type: JavaScript JavaScript Expression:document True Action1 :apex.item( "P1_SAL_CHANGED" ).setValue(this.data.sal); apex.item( "P1_TEST" ).setValue( this.data.empno); True action2:DECLARE NO_UPDATE EXCEPTION; PRAGMA EXCEPTION_INIT (NO_UPDATE, -20233); BEGIN UPDATE EMP SET SAL = :P1_SAL_CHANGED WHERE EMPNO = :P1_TEST; if(SQL%ROWCOUNT =0)then RAISE NO_UPDATE; end if; EXCEPTION WHEN NO_UPDATE THEN RAISE_APPLICATION_ERROR(-20233,'EMPNO NOT FOUND.'); WHEN OTHERS THEN RAISE_APPLICATION_ERROR(-20234,'ERROR '||SQLERRM); END; Kindly let me know if I miss any thing. Thanks
12-Mar-2019 03:41:PM by: arjun
I usually join the tables in the query. Its quick and easy and displays all the data that is needed.
12-Mar-2019 03:36:PM by: Alan Quigley
Hi guys. Our team is currently having a discussion, what is the best way to display data in a report. a) Using display output of LOVs, b) joining the tables in the query to get the display output. What's your thoughts?
12-Mar-2019 03:05:PM by: Ross Henderson
Is there any way to get the query used to get the results that is used in apex when we search for any string in apex application search ?
12-Mar-2019 06:49:AM by: vramkishore
there is uploading file functionality where user can upload file that file save into database that increase size of database let assume for a single project user will uploaded more than 50 pdf file so all stored in database. i want to solve this issue. Database size is not going to increase what method i have choose. @maxime_tremblay
12-Mar-2019 05:05:AM by: Amit
No error. The instance setting is set to Return an Error Page but this is an Ajax request. I am using the Dropzone plugin. Seems the plugin’s author realized this limitation and built a chunked mechanism to break up the file into separate requests in a future version. But I am still wondering why this limit exists.
12-Mar-2019 01:54:AM by: Ryan Gallimore
do you get an error in your server’s log?
12-Mar-2019 12:46:AM by: maxime_tremblay
I don’t understand what you’re trying to do could you give more details regarding what you need to do
12-Mar-2019 12:22:AM by: maxime_tremblay
Hi, I am trying to post a 40 mb file using apex.server.plugin and the f01 parameter. It fails with a 400 HTTP Error; smaller files are fine. Is this a known limit with this function?
11-Mar-2019 09:05:PM by: Ryan Gallimore
url
11-Mar-2019 09:03:PM by: lavanya.seshadri
also tried with the URl
11-Mar-2019 09:01:PM by: lavanya.seshadri
i specified the static id in anchor
11-Mar-2019 09:01:PM by: lavanya.seshadri
i put a static id for the region on page 1 where it was supposed to return after the processing on page 4
11-Mar-2019 09:01:PM by: lavanya.seshadri
iam using the anchor
11-Mar-2019 08:59:PM by: lavanya.seshadri
yes
11-Mar-2019 08:59:PM by: lavanya.seshadri
what’s your link? are you using an anchor?
11-Mar-2019 08:34:PM by: maxime_tremblay

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
YoCo WIS
19-Mar-2019 11:34
APEX 18/5 Navigation lists ("target="_blank) in URL target
Link
0 replies
3911618
19-Mar-2019 11:31
Can we Display the output which we got from procedure in apex pages
Link
3 replies - last reply: 19-Mar-2019 12:28- by: fac586
3d464f25-f2c9
19-Mar-2019 11:15
APEX 18.2 - How to add horizontal scrollbar in item
Link
0 replies
hemant_k
19-Mar-2019 10:01
command window unresponsive
Link
1 replies - last reply: 19-Mar-2019 10:17- by: Gaz in Oz
Arthur R.
19-Mar-2019 08:49
[APEX5.1] File Browser
Link
0 replies
3902061
18-Mar-2019 20:37
Help with insert / update process (low level)
Link
3 replies - last reply: 19-Mar-2019 06:33- by: 3902061
Eslam_Elbyaly
18-Mar-2019 20:15
Getting sum of column item
Link
1 replies - last reply: 18-Mar-2019 23:50- by: John Snyders-Oracle
user4200252
18-Mar-2019 13:51
how to pass parameters to bi publisher PDF report ?
Link
2 replies - last reply: 19-Mar-2019 07:23- by: user4200252
ar_dev_mea
18-Mar-2019 12:04
how to get IR search value to pass(log table)
Link
3 replies - last reply: 19-Mar-2019 09:44- by: fac586
SwaZ
18-Mar-2019 11:19
Shuttle Item Values
Link
2 replies - last reply: 19-Mar-2019 09:47- by: SwaZ
Volker Heisel
18-Mar-2019 09:54
Item validation: no type "Item is NULL"?
Link
2 replies - last reply: 19-Mar-2019 07:53- by: Volker Heiselmayer
M.bro
18-Mar-2019 06:46
Material apex 5.1.3 to 18.1 Up-gradation error
Link
0 replies
sk*419893*er
17-Mar-2019 20:17
Image viewer widget
Link
2 replies - last reply: 18-Mar-2019 21:59- by: sk*419893*er
andreml
16-Mar-2019 12:52
apex.oracle.com, 19.1, Install of "Sample Trees" failes
Link
4 replies - last reply: 18-Mar-2019 16:09- by: andreml
3911618
15-Mar-2019 11:28
How to send group sms and mails through oracle apex 5.0
Link
4 replies - last reply: 19-Mar-2019 02:48- by: Scott Wesley
Fabrizio Dell
14-Mar-2019 14:27
dynamic table in a from clause
Link
3 replies - last reply: 19-Mar-2019 07:52- by: Fabrizio Delli Priscoli
AllenS.
14-Mar-2019 05:18
How to get the APEX Theme 20 (Traditional Blue) back?
Link
5 replies - last reply: 19-Mar-2019 02:19- by: AllenS.
Hoek
13-Mar-2019 15:16
Apex 18.2 - Centered position for enlarged Application Logo
Link
4 replies - last reply: 13-Mar-2019 15:16- by: Hoek
niki71
12-Mar-2019 08:22
Javascript Code Size Limit
Link
12 replies - last reply: 18-Mar-2019 19:43- by: fac586
DSteele41
11-Mar-2019 18:02
Page Layout Columns Rows
Link
9 replies - last reply: 19-Mar-2019 12:28- by: DSteele41
Kavi
06-Mar-2019 06:06
Saving a custom report, when going back to select it, the Saved report drop-down has two arrows
Link
4 replies - last reply: 19-Mar-2019 05:20- by: Kavi
3902061
01-Mar-2019 17:23
checking data in other table, then providing a result
Link
1 replies - last reply: - by:
Eslam_Elbyaly
25-Feb-2019 19:48
Setting IG's PopUp lov item value using model.setValue
Link
4 replies - last reply: 18-Mar-2019 23:42- by: John Snyders-Oracle
rajk5
12-Feb-2019 21:54
Apex 5.1.3 submitting form
Link
2 replies - last reply: 19-Mar-2019 04:07- by: Scott Wesley
3669331
11-Sep-2018 13:58
To write dynamic action using apex item
Link
2 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
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
John Snyders  
Mega Menus
Navigation
Link
03-Mar-2019 18:45:01 by: Maxime Tremblay
Ming Lei  Other
New Job Offer: Canada, Quebec, Longueuil, permanent, onsite
Jobs
Link
02-Mar-2019 01:49:37 by: Maxime Tremblay
David Anderson    
New XE APEX Hosting
Hosting, XE
Link
02-Mar-2019 01:40:55 by: Maxime Tremblay
Matt Nolan    Other
New Podcast: Matt Nolan, 150 Plug-ins
Plug-ins
Link
01-Mar-2019 20:16:30 by: Juergen Schuster
Dimitri Gielis  
Images in Emails
Email, Images
Link
01-Mar-2019 11:58:41 by: Maxime Tremblay
Sven Weller  
Logging Tips
API, Debugging, Logging
Link
01-Mar-2019 03:24:10 by: Maxime Tremblay
Scott Wesley  
Configuration 404 Error
Debugging, Error, Installation
Link
28-Feb-2019 18:37:02 by: Maxime Tremblay

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20