Slack

@maheshdm http://joelkallman.blogspot.co.uk/2014/03/yet-another-post-how-to-link-to.html
15-Dec-2017 02:46:PM by: turntablez
@zootolo You can create form page based on table having blob column (in which you want to store uploaded file) and then you can select 'Blob column specified in Item Source attribute; as storage type in File Browse item.
15-Dec-2017 10:57:AM by: maheshdm
Hello, How to set file-name while downloading file from blob column of a table? I am using this SQL in classic report --> select FILE_NAME as "File Name", sys.dbms_lob.getlength(blob_content) as "Get File" from RC_X_FILES; With this 'file name just comes as 'download' but I want 'something.docx'. Any idea?
15-Dec-2017 10:37:AM by: maheshdm
hello apex beginner here, I'm having trouble uploading BLOB files to my database. I've searched for awhile and thus far, I've only found the following solution: - Use the file browse item to upload the file to APEX_APPLICATION_TEMP_FILES, and then in a 'After submit' process, retrieve values from the APEX_APPLICATION_TEMP_FILES and insert them into my own table. Even though the above solution does seem to somewhat work, I have to go through an extra table to upload a single file. I was wondering if there is an easier way to pull this off. thanks in advance :slightly_smiling_face: APEX v5.0.4
15-Dec-2017 09:11:AM by: zootolo
Navigate to the column in question, in the property pallet there are attributes that will allow you to change the alignment of header and column value
15-Dec-2017 08:28:AM by: alex.nuijten
Could some one please help me out?
15-Dec-2017 05:04:AM by: sgtlaxman
Hi Everyone, I have an issue with interactive reports Column heading and Value alignment. This happens when I create computed columns, the column heading is center and value is right left aligned. Dont see any way to adjust them.
15-Dec-2017 05:04:AM by: sgtlaxman
@pierre here is a bit of code that can get you close to the amount of DB space that the app is using in apex but this is precision-guesswork so no guarantee on accuracy.
14-Dec-2017 07:59:PM by: jaughenbaugh
yeah just change that to select or the option at the top if the drop-down
14-Dec-2017 07:58:PM by: jaughenbaugh
remove the type condition and it should work
14-Dec-2017 07:57:PM by: jaughenbaugh
sounds like the type condition is nullifying the button condition
14-Dec-2017 07:56:PM by: jaughenbaugh
Could someone explain this.. I am working on a DELETE button. Under Server-side condition, When-button Pressed=DELETE, Type= REQUEST != VALUE, VALUE=DELETE. What is this means? Thx.
14-Dec-2017 07:55:PM by: cwong
@pierre if you are worried about the size of the export, you could split up your app into several ones. In that case the exports will be smaller. You might even need to deploy just one or two of those “sub-apps” instead of the big chunk.
14-Dec-2017 07:32:PM by: roelhartman
@pierre another consideration is that the app export is really just the script to install the application so it has extra amounts of code to facilitate this. The data in the database is smaller by any measure. So the quest to ask is are you looking for the amount of storage your app is taking in the DB or in the flat file format of the export?
14-Dec-2017 05:58:PM by: jaughenbaugh
I think you are probably going to have to create a procedure that iterates through the hierarchy or APEX tables. I’m not sure what you want in terms of “size”, though.. Number of pages, regions, items, buttons? that won’t give you the size of the export file, but would give you an idea of the size of the overall application.
14-Dec-2017 03:30:PM by: doug.a.gault
Thanks @doug.a.gault my question is not just for export. How to see the size on an application without necessarily exporting it. .. maybe there is a view where we can see the size of pages, regions, items, and the attributes....? Or maybe we can write a procedure that automatically calculates it, without to export it ?
14-Dec-2017 03:28:PM by: pierre
@pierre - because the definition for an application is all metadata that lives inside the APEX tables, and reconstituting that metadata requires calls to the APEX API’s you can’t “know” the size of an export until it’s created. It all depends on the number of pages, regions, items, and the attributes of said components. Can I ask why you need to know the size prior to export?
14-Dec-2017 02:59:PM by: doug.a.gault
thanks @maxime_tremblay . It is important for me to know how much my application weighs. Unfortunately I have to export it to know that
14-Dec-2017 02:32:PM by: pierre
@pierre the filesize of an exported application cannot be determined without actually exporting the file why do you need to know the size of the file?
14-Dec-2017 02:28:PM by: maxime_tremblay
Hi, Someone know if there is an apex view to see how much the application weighs? currently to see how much the application weighs, I am forced to export it. thank you in advance
14-Dec-2017 01:20:PM by: pierre
@muhammadubaid here is the apex 5.0 Version https://github.com/allipierre/session-timeout
14-Dec-2017 11:47:AM by: pierre
The release notes will be available as part of the patch. So be patient...
14-Dec-2017 10:00:AM by: roelhartman
@roelhartman is the list of fixed bugs :ant: / changes already available or will I have to wait for the roll out?
14-Dec-2017 09:58:AM by: p.ettinger
It will be available for download (through myoraclesupport) very soon. I guess later this week or next week. Either way … before Christmas.
14-Dec-2017 09:49:AM by: roelhartman
@maxime_tremblay can i use in apex 5.0 version?
14-Dec-2017 05:15:AM by: muhammadubaid
Hey @shaun.mauer, I'll do it but it's kinda easy to see that. If you go to https://apex.oracle.com/pls/apex/f?p=42:1907 (http://apex.oracle.com/ut|apex.oracle.com/ut) and aim into Tabs Region (Example 1) while refreshing the page you'll see "Tab 2" and "Tab 3" jumping...
14-Dec-2017 12:00:AM by: trevis
@trevis Could you possibly use ScreenToGif (http://www.screentogif.com/) to record what it is doing and upload it here so we can see?
13-Dec-2017 11:01:PM by: shaun.mauer
Any other suggestion?
13-Dec-2017 10:57:PM by: trevis
I'm thinking to initially have the Tab Container hidden and then display it after the "jumping" finishes... not sure how to detect "jumping done" or if that is actually the best approach.
13-Dec-2017 10:56:PM by: trevis
Hey guys, does someone else also get annoyed when, using `Tab Container` template region, you see all sub-regions jumping from below region to inside the region? I have few sub-regions and it isn't nice seeing them jumping every time user loads the page.
13-Dec-2017 10:53:PM by: trevis
@thomas what do you mean by table? DB table, or HTML table, or something else?
13-Dec-2017 09:24:PM by: maxime_tremblay
hey I'm not sure how to ask this question but is there any way to grab all the rows in a table and put into a javascript array?
13-Dec-2017 07:57:PM by: thomas
@maxime_tremblay thanks. It works.
13-Dec-2017 06:38:PM by: mingat.dalai
if using an IR, this should work ```.a-IRR-table tr.highlight td { background-color: blue; color: white; }``` when you have a look at the UT CSS, you can see that the background color and text color are defined at the td level you had your CSS defined at the row level so the td's CSS is going to override whatever you have at the tr level
13-Dec-2017 06:33:PM by: maxime_tremblay
@mingat.dalai if possible don't use important, you should adjust the CSS so that you override the correct classes/selectors
13-Dec-2017 06:27:PM by: maxime_tremblay
@mingat.dalai try ```.highlight { background-color: blue !important; color: white !important; }``` I guess your CSS is overwritten by color definitions from Universal Theme
13-Dec-2017 06:11:PM by: matze276
Any idea why it is not working as expected? THanks.
13-Dec-2017 05:36:PM by: mingat.dalai
and using ``` $("#rgnMasterInst table").on('click','tr', function(e) { $(this).addClass('highlight'); })``` to hightlight the row when it is clicked.
13-Dec-2017 05:36:PM by: mingat.dalai
hi I defined a css in Header: ``` <style> .highlight { background-color: blue; color: white; } </style>```
13-Dec-2017 05:35:PM by: mingat.dalai

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
PegasoSeiya
16-Dec-2017 00:00
HI- HOW TO GO TO THE LAST RECORD
Link
0 replies
user7661173
15-Dec-2017 21:44
Adding thousand seprator to a number field in Apex Interactive grid when tabs out from the field in
Link
0 replies
Runrig
15-Dec-2017 18:58
Apex 5.1 Modal Dialog is inheriting size from Wizard Dialog. Most annoying
Link
1 replies - last reply: 15-Dec-2017 20:44- by: Runrig
C Patel
15-Dec-2017 17:20
APEX RESTful Service Resource Handler Query Not Displaying Added Column
Link
0 replies
MD. MASUD
15-Dec-2017 16:40
How to set/ use simple checkbox in interactive report.
Link
0 replies
Idkfa2
15-Dec-2017 15:43
Processes not working after 2nd trigger created
Link
2 replies - last reply: 15-Dec-2017 18:41- by: Idkfa2
Soukaina IDRI
15-Dec-2017 12:27
How and where to custom error page 'THIS SITE IS INACCESIBLE PAGE'
Link
0 replies
Schuriik
15-Dec-2017 12:24
Sending iCalender event via mail
Link
0 replies
VukMNE
15-Dec-2017 10:59
Images not appearing on Apex Public Page
Link
3 replies - last reply: 15-Dec-2017 13:57- by: VukMNE
Soukaina IDRI
15-Dec-2017 10:06
How to use process row of external table/view
Link
2 replies - last reply: 15-Dec-2017 17:15- by: Justin Warwick
arminia
15-Dec-2017 09:39
ApEx 5 style column width
Link
4 replies - last reply: 15-Dec-2017 12:54- by: jozzh
Prashanth Raj
15-Dec-2017 09:21
Application Item - Not retaining value in session state inside scheduled Job
Link
4 replies - last reply: 15-Dec-2017 13:55- by: Pavel_p
Test2
14-Dec-2017 21:24
How to Set IG item to null on focus
Link
4 replies - last reply: 15-Dec-2017 18:41- by: John Snyders-Oracle
4ec521da-6362
14-Dec-2017 19:59
Use of Cursor to display query results
Link
5 replies - last reply: 15-Dec-2017 14:46- by: 4ec521da-6362-4197-92f0-13fd708f0983
989592
14-Dec-2017 19:49
How to change position of the Login screen?
Link
3 replies - last reply: 15-Dec-2017 16:54- by: Justin Warwick
TexasApexDeve
14-Dec-2017 19:38
ORDS crashes when trying to download a file..
Link
4 replies - last reply: 15-Dec-2017 20:19- by: TexasApexDeveloper
Anson_of_2772
14-Dec-2017 00:32
Reference original/old values before submitting Report page
Link
2 replies - last reply: 14-Dec-2017 04:29- by: LA County APEX
sect55
13-Dec-2017 21:14
Interactive Grid - Duplicate duplicates the wrong row
Link
4 replies - last reply: 15-Dec-2017 19:31- by: sect55
58d69614-3551
13-Dec-2017 13:27
Refreshing page item after session state changed
Link
2 replies - last reply: 15-Dec-2017 15:38- by: Neil Clare
trishl
11-Dec-2017 20:01
APEX 5.1 using desktop Application on ipad
Link
1 replies - last reply: 15-Dec-2017 17:07- by: Justin Warwick
Jeff Kemp
11-Dec-2017 05:37
Quick SQL: some improvement needed
Link
1 replies - last reply: 16-Dec-2017 00:18- by: Jeff Kemp
Raj_insight
10-Dec-2017 05:04
How to customize the application URL?
Link
12 replies - last reply: 15-Dec-2017 20:35- by: Raj_insight
Khalequzzaman
08-Dec-2017 16:28
Apex 5.2 classic report column width
Link
3 replies - last reply: 15-Dec-2017 12:50- by: jozzh
ESVK
07-Dec-2017 19:14
Display Image in Classic Report link for Type = "Download Blob"
Link
10 replies - last reply: 15-Dec-2017 18:30- by: ESVK
Rotan
06-Dec-2017 06:40
Freeze first 2 columns in Tabular form
Link
2 replies - last reply: 15-Dec-2017 22:02- by: Rotan

CSS for Home-Pages 1,10,20