|
| 10:06:01 | jakob.m.christensen | You have the Exadata Express Cloud Service in the slide. We are currently using it but apparently its moving from PaaS to IaaS. Do we have a timeline for this? (I could seem to find the replacement) |
| 10:07:52 | Sven Weller | Does this mean in the future we will always have a new schema? Which in turn means more potential effort for us to upgrade on datbase level. I'm thinking about copying ACLs and connecting other stuff from the APEX schema to our local schemas. |
| 10:08:33 | christian | If you are on DB 12, APEX will automatically upgrade the ACL as well. |
| 10:08:42 | * Marc Sewtz | Webinar URL: https://www.odtug.com/online-education |
| 10:08:48 | * Joel Kallman | Sven - yes. New APEX schema with every new release. |
| 10:09:19 | Sven Weller | Ok, if you solve the ACL thing then thats fair. |
| 10:10:39 | S Boorsma | Can we also use dark mode within our own application? |
| 10:11:29 | CARDINALB | Should EA workspace emails be somewhat imediate? I requested workspace 2 days ago. Login still says it is pending. |
| 10:11:50 | * Doug Gault | S Boormsa - Dark Mode for that you’re seeing is only for the APEX Core. If you’re using Universal Theme, you can create and allow users to choose a Dark version and a light version of your theme. |
| 10:11:58 | * Joel Kallman | Brad - it should be immediate. |
| 10:12:14 | * Joel Kallman | You shoudl ensure your spam filter isn't blocking it. |
| 10:12:28 | * Joel Kallman | I'll adjust your request so you're sent another email, okay? |
| 10:12:35 | JESUS MORENO (TECNICA24) | What about to control if developers can do import/export? |
| 10:12:52 | Tim St. Hilaire | Jakob - EECS is fully supported at this time. New cloud offerings are always in the works. No changes to EECS have been announced. |
| 10:13:37 | CARDINALB | nada. we have a problem at our corporate level of some domains being blocked by security software. i'll request again from a public email address. |
| 10:14:09 | * Joel Kallman | Brad - see if you get an email in the next couple of minutes (from your earlier request). |
| 10:14:31 | * Joel Kallman | @Jesus - no plans to control if developers can import/export. |
| 10:15:57 | jakob.m.christensen | Ok, I just cannot find EECS as a product on cloud.oracle.com and the prices for it. It was the earlier... |
| 10:17:37 | Alastair Steele | Sorry did he just say the custom list attributes now work? |
| 10:19:26 | JESUS MORENO (TECNICA24) | Is there a site to write down which new features you would like to have apex? |
| 10:19:41 | * Joel Kallman | @Jesus - apex.oracle.com/vote |
| 10:20:43 | Paul | Personal Opinion: when NOT in the new dark mode I think the old icons for pages looked better, the new ones seem a little washed out: https://i.ibb.co/10n0Dx1/191.png |
| 10:21:12 | gopisera | Any features that REST handiling Dynamic Column report i.e., the rest call fields are dynamic. |
| 10:21:13 | Kevin Zhang | agreed ... |
| 10:21:15 | * Shakeeb Rahman | Hi Alastair Steele – the custom attribute labels will now be visible when editing the list entry via the Builder. |
| 10:21:34 | Sven Weller | Is there now a way to influence the top navigation menu via templates? |
| 10:21:54 | Juergen Schuster | still the beautiful yellow pencils #FontAPEX? |
| 10:22:12 | * Shakeeb Rahman | We're working on it, Jürgen! ;-) |
| 10:22:18 | Stephen Tiepel | Will restful be enabled for interactive in teh future? Is it part fo teh development roadmap? |
| 10:22:34 | Sven Weller | Honestly, I like the orange pencils. ;) |
| 10:22:48 | * Shakeeb Rahman | Sven: I'm not sure what you mean by influence. You can select the Tabs or Menu template. |
| 10:23:07 | Kevin Zhang | What is the "optimizer Hint" attribute? Is this new? |
| 10:23:10 | Juergen Schuster | Sure it is surely fitting in all you layout themes ;-) |
| 10:23:24 | Oliver Lemm | what about multiple regions relying on one source |
| 10:23:27 | Sven Weller | The top navigation menu, can not be influenced via a template. The template (html) settings are ignored, at least for sub menus. |
| 10:23:34 | * Anthony Rayner | @Stephen: Do you mean Interactive Grids? If so, that is the plan, but not for 19.1. |
| 10:24:16 | Alastair Steele | Sorry, to clarify I ran into this problem using 5.0.4 https://community.oracle.com/thread/3705593 Can't find anything suggest the situtaion has changed, can you confirm if this is the same in the latest versions of APEX? |
| 10:24:17 | zed | So can you use join queries in any clever way? |
| 10:24:30 | zed | as a form source |
| 10:24:46 | Sven Weller | The reason for the template issue is afaik the menu widget wich is used to open the sub list entries |
| 10:24:58 | Kevin Zhang | Any new sample applications in 19.1? Many existing sample applications look very similar for the UI ... I am looking forward to some next sample application ... |
| 10:24:59 | zed | or does it have to be say a key preserved view ot IOT |
| 10:25:52 | Eric | can the form be created on a sql query that references a table through a dblink? |
| 10:26:03 | * John Snyders | @sven Standard apex top navigation does not use templates, it uses the menu widget. |
| 10:26:11 | JESUS MORENO (TECNICA24) | If you use "PL/SQL function body returning sql" as a source for a Form, will it generate Items during runtime? |
| 10:27:45 | pmmedinab | I cannot see Carsten's screen |
| 10:27:55 | pmmedinab | is that happening to anyone else? |
| 10:27:56 | Kevin Zhang | Any new sample applications in 19.1? Many existing sample applications look very similar for the UI ... I am looking forward to some new sample application ... maybe a sample apex is mainly for mobile phone ... I wish the Movie apps (made by Shakeeb) can be included as sample apps in the APEX 19.1 |
| 10:28:42 | * Hilary Farrell | @Kevin Zhang - no new Sample Apps, but all of the sample apps are running with the latest version of UT....and many of the existing apps have been updated for 19.1, to demonstrate new features and functionality, in particular the UT Sample App, Sample Charts, Sample Interactive Grid |
| 10:28:55 | Sven Weller | @John, yes that is my pain. I want to add custom list attributes to the rendered menues, but can not, because those attribues are not picked up by the content used by the menu widget. |
| 10:29:35 | RajB | This is existing function which also in 18.0 |
| 10:29:43 | RajB | No new here |
| 10:29:47 | RajB | skip this plese |
| 10:30:12 | Pete K | I think you can download Shakeeb's movies app from somewhere - check his twitter feed. |
| 10:30:16 | * Hilary Farrell | @Kevin Zhang - Shakeeb made the Movies app available for download, which himself & Carsten worked on together: https://twitter.com/shakeeb/status/1011275880855953408?lang=en |
| 10:30:21 | jakob.m.christensen | When creating at new page it would be nice if it was possible to select the Sequence number in the menu. I always need to go and change it afterwards in shared components... |
| 10:30:28 | * Doug Gault | @RajB - This functionality has been extended in 19.1 so it’s worth going over |
| 10:30:31 | * Joel Kallman | @Jürgen - it's a bug that the yellow pencil was used for the Create Form wizard. In the CReate App, it uses Font APEX. I just filed feedback on this issue. |
| 10:31:05 | Sam Khalaf | I see the endpoint URI is a full URI including host name and such, but when you delploy code to QA/UAT/PROD, wouldn't that be adjusted? what is the best way to do that without hardcoding things? |
| 10:31:15 | Alastair Steele | +1 to what @Sven is saying, that was my question as well |
| 10:31:22 | Kevin Zhang | given "Movie Apps" is so popular and is well received, why not include it as a sample apps going forward ... |
| 10:31:34 | RajB | Any enhancement on REST Auth2.0 supporting. |
| 10:32:00 | RajB | Seems Google API & other API can't make Auth2.0 in apex.? |
| 10:32:08 | * Hilary Farrell | @Kevin Zhang - we may consider this option for a future release |
| 10:32:14 | * Joel Kallman | @RajB - what do you mean? |
| 10:32:22 | Kevin Zhang | We (citizen developer) are building applications by learning from existing one ... I hope there will be more different variaty of sample apps available ... |
| 10:32:33 | S Boorsma | i wonder as well, cant't get GoogleCalender working as websource for a calendar region |
| 10:32:45 | Sven Weller | What was that "external order by" attribute in the form properties? |
| 10:32:53 | RajB | Rest Services with Adding Auth2.0 for LinkedIn does not working. |
| 10:33:01 | RajB | Does any enhancement on same? |
| 10:33:46 | Elizabeth | Are there any good resources or documentation on how to integrate BI Publisher 12.2.1.3.0 with APEX to generate PDF reports? I am trying to use only the web client and hoping to eliminate the Word BI Publisher plugin. I know the basics, how to create a report query and layout and how to call the PDF. Just hoping to eliminate the need for the plugin, possibly calling the PDF report with the URL? |
| 10:33:57 | * Joel Kallman | @RajB - again, not sure what you mean. Are you saying that you're attempting to use an OAuth2 protected resource on LinkedIn, and use this as a WEb Source Module, and the authentication doesn't succeed? |
| 10:34:40 | Kevin Zhang | Any possibility that APEX will drop jQuery library in future? I mean can we assume jQuery will always be used by APEX? |
| 10:36:09 | * John Snyders | @sven can you ask the menu question on the APEX forums and @ me explain what visual effect you are looking for. |
| 10:36:22 | * Hilary Farrell | @Kevin Zhang - there are no plans to drop jQuery library support |
| 10:36:24 | Sven Weller | I will do. Thanks John. |
| 10:36:35 | HansL | is xlsx available? |
| 10:36:56 | Juergen Schuster | @HansL that’s what she said |
| 10:37:04 | * Doug Gault | @HansL - Yes.. |
| 10:37:06 | Juergen Schuster | And I saw it in the selection |
| 10:37:10 | HansL | she sai xls i thought |
| 10:37:26 | Jeffrey Kemp | Not XLS, only XLSX |
| 10:37:57 | Igor Sala | In 5.1, when a DA "page load" with Execute PL/SQL is triggered, if the item that receive the value is a “Lists of Values” with cascades, it not works without a "manually" jQuery action. Is there another solution in apex 19? Thank you. |
| 10:38:01 | jakob.m.christensen | Will that be added as page component (so it can be used in a application) |
| 10:38:31 | Sven Weller | I assume the xlsx loader also works for our custom data load wizards. Or is it sql workshop only? |
| 10:38:34 | * Anthony Rayner | @Kevin: Re ‘dropping jquery’, we have no current plans to drop, or remove jQuery. |
| 10:39:03 | Jeffrey Kemp | I asked Carsten about the data load wizard. Updating it to support XLSX is planned for a later release, but not 19.1 |
| 10:39:36 | Jeffrey Kemp | However, we will be able to build our own programs using a new APEX API PL/SQL API. |
| 10:39:55 | * Anthony Rayner | @Igor: Re: DA page load issue: I would suggest posting a test case to the OTN forums, and we can take a look for you. |
| 10:40:14 | sunil | Excel allows inserting extra info on the first line for csv files for delimiters as: "sep=," , is this automatically detected? |
| 10:40:17 | Sven Weller | Interesting, Jeff. |
| 10:40:30 | Stefanie | Is it planned for the future to add excel export to IR/IG? |
| 10:40:34 | JESUS MORENO (TECNICA24) | Will be APEX "free of charge" forever? |
| 10:40:50 | Carsten Czarski | we don't look for "sep=" yet. It detects the separator simply by looking at the data |
| 10:41:01 | Eric | So if the functionality is show in apexea.oracle.com it will be in the 19.1 release? |
| 10:41:06 | Igor Sala | @AnthonyRayner: I did, but no responses. |
| 10:41:06 | * Anthony Rayner | @Igor: Quite often, page load ‘execute pl/sql code’ logic can be rewritten to use standard page rendering logic (and avoid the need for another call to the server), but an example on the forums would help us. |
| 10:41:11 | * Doug Gault | @Jesus Moreno - APEX is a no-cost option of the Oracle database and will remain that way. |
| 10:41:15 | Jeffrey Kemp | safe harbour applies for apexea |
| 10:41:18 | JESUS MORENO (TECNICA24) | forever? |
| 10:41:23 | EJ Egyed | For the Load Data part of the presentation, it shows how to import to create a new table, but is it possible to load a file to load records into an existing table? |
| 10:41:28 | * Anthony Rayner | @Igor: Do you have a link? I’ll take a look. |
| 10:41:46 | * Doug Gault | @Jesus - there are no plans for that to change. |
| 10:41:47 | * Joel Kallman | @Eric - anything can change. EA is Early Adopter. |
| 10:41:52 | Jorge Rimblas | @jesus it has been for 15 years, what else do you need? |
| 10:41:54 | JESUS MORENO (TECNICA24) | Great!!! |
| 10:42:00 | Eric | @Joel - Thanks. |
| 10:42:29 | jakob.m.christensen | I look very good :) |
| 10:42:30 | JESUS MORENO (TECNICA24) | I have spent last 15 years with APEX happily and would like to go on! |
| 10:42:34 | Carsten Czarski | @EJEgyed: Loading into existing table is not supported yet. But you can always go to SQL Workshop afterwards and do an INSERT ... SELECT into your target table after data load |
| 10:42:53 | Sven Weller | @Eric: My experience from the past early adopters was, that sometimes there are features that didn't make it into the final version. |
| 10:43:13 | EJ Egyed | thanks! |
| 10:43:22 | S Boorsma | Are websheets applications gone? |
| 10:43:33 | Juergen Schuster | :-D |
| 10:44:01 | * Doug Gault | @Sven - With safe harbor in place, unless there is a major problem found with a feature that’s in EA, it’s very likely to make it to final production. |
| 10:44:12 | Igor Sala | @AnthonyRayner https://community.oracle.com/thread/4190951 Thank you! Just a update info, we’re trying to force the load data in Lov, with this jQuery action. |
| 10:44:16 | * Joel Kallman | @SBoorsma - Websheets are still there. |
| 10:44:20 | * Joel Kallman | ....for now. |
| 10:44:21 | * Doug Gault | @SBoorsma - No. Websheets are still there. |
| 10:44:32 | * Anthony Rayner | Thanks Igor, will take a look. |
| 10:44:34 | * Doug Gault | Beat me to it Joel |
| 10:44:40 | RajB | How do migrate tools any MS office db to APEX apps ? |
| 10:44:49 | Juergen Schuster | @Joel: I like the "for now" :-D |
| 10:45:11 | * Doug Gault | @Raj - SQL Developer has tools to help migrate databases (definitions and data) to Oracle. |
| 10:45:29 | Sven Weller | The apex_data_parser package looks highly usefull. May I get it now? ;) |
| 10:45:44 | * Doug Gault | Nice Try @Sven! :-) |
| 10:46:03 | * Joel Kallman | @RajB - that bug about LinkedIn Auth (from the discussion forum) should be fixed in A{EX 19.1 |
| 10:46:06 | Juergen Schuster | @Sven: How much Oracle stock do you hold :-P |
| 10:46:07 | * Joel Kallman | APEX 19.1 |
| 10:46:23 | Eric | @Doug - Me too! |
| 10:46:31 | Jeffrey Kemp | @Sven there was a leak of an older version of apex_data_parser that can read xlsx files .... :) |
| 10:47:05 | EJ Egyed | How does the APEX_DATA_PARSER package handle XLSX files that have multiple sheets? Does it just read the first sheet? |
| 10:47:11 | Carsten Czarski | @Sven, @Jeffrey Kemp ... but that is *way* ... behind ... |
| 10:47:20 | Jeffrey Kemp | yes, needed a few bugfixes |
| 10:47:44 | Jeffrey Kemp | The parse function has a parameter which you set to the name of the sheet you want. |
| 10:47:45 | * Hilary Farrell | Everyone - please ensure you are on mute |
| 10:47:55 | Jens Kaschuba | @Sven: https://blogs.oracle.com/apexcommunity_deutsch/xlsx-upload-leicht-gemacht%3a-ein-einfacher-xlsx-parser |
| 10:47:58 | Carsten Czarski | @EJ Egyed: By default it reads the first sheet, but there is a parameter p_xlsx_sheet which allows you to choose a specific sheet. APEX_DATA_PARSER also contains a function which returns the existing sheet ... |
| 10:48:10 | EJ Egyed | great! thanks! |
| 10:49:09 | Kevin Zhang | different presenter likes different browser ... now Hilary is using Firefox ... |
| 10:49:37 | EJ Egyed | also using a Windows computer instead of a Mac :) |
| 10:49:44 | * John Snyders | its all about diversity |
| 10:50:01 | Paul | how much testing is done for new versions of APEX in IE? I believe IE is still currently certified for APEX? however I see more issues in IE with each new release of APEX (IG) and whenever they are raised by someone the response is "haha why are using IE?", Some people don't have a choice... I believe either more testing needs to take place in IE for new versions or the claim that it is certified for use with IE should be removed |
| 10:50:09 | Kevin Zhang | also using different OS ... some are iOS ... some are Windows 10 ... |
| 10:50:53 | Juergen Schuster | @Paul 42 :-) |
| 10:51:31 | Kevin Zhang | one thing confused me is the font: given font awesome is so popular, why Oracle APEX team want to re-invent the wheel with Font APEX? |
| 10:52:08 | sunil | @Kevin copyright issue maybe? |
| 10:52:09 | Juergen Schuster | @Kevin: When you ask this question you can’t see it yet :-) |
| 10:52:12 | * John Snyders | please no IE shaming |
| 10:52:14 | Jeffrey Kemp | I suspect it was because font awesome is missing lots of icons that are useful in APEX |
| 10:52:21 | RajB | Just non technical question , Oracle releasing RAPID APEX versions ? We are so much release in 2018. |
| 10:52:29 | Pete K | @paul - agree - all issues I've had with apex have been in IE - e.g. region display selector goes on the fritz regularly (no shame implied ;-) |
| 10:53:40 | * Doug Gault | According the the APEX End user guide the supported versions of IE for APEX 18.2 are 11 and EDGE.. |
| 10:53:58 | Sven Weller | A collegue of mine was very sad that the fa-rebel icon from font awesome was not anymore. |
| 10:54:03 | Kevin Zhang | if you are checking other web project (not Oracle APEX), all of them are using Font awesome ... only Oracle APEX is pushing for Font APEX ... as far as I know Font Awesome is by far the most popular free font (though it laso has paid professional fonts) |
| 10:54:26 | Jeffrey Kemp | You can use both |
| 10:55:13 | Juergen Schuster | @Kevin: Thats exactly the point, you don’t want to look like everybody else. Font APEX is much more crisp and modern ;-) |
| 10:55:28 | * Shakeeb Rahman | Kevin: Font APEX was created because Font Awesome didn't fully match the aesthetic we wanted for APEX |
| 10:55:34 | * Joel Kallman | @Jürgen - dont forget "clean" |
| 10:55:48 | Kevin Zhang | BTW, will SVG font available now for APEX 19.1? |
| 10:56:08 | * Shakeeb Rahman | You can use any icon library, and there are several competitors to Font Awesome as well – so really just depends on the style you want :) You can download Font APEX for free, its open source: fontapex.com |
| 10:56:28 | * Shakeeb Rahman | You can download all of the SVGs for FontAPEX from github. |
| 10:56:31 | Juergen Schuster | This was my favourite feature I integrated it in 5.0 even it was not provided there ;-) |
| 10:57:01 | RajB | When APEX release multilevel authentication / generic authentication API like ( OTP ) authentication? Or Current helps links. |
| 10:58:40 | Kevin Zhang | do we have "heat map" chart supported in APEX 19.1? |
| 10:59:56 | Sven Weller | @Kevin no. Also JET does not have a heatmap vizualisation. It have a heatmap possibility via a datagrid, if I remember correctly. |
| 11:00:36 | Kevin Zhang | heatmap is very useful .. I wish APEX can support this soon .. |
| 11:00:45 | iPhone | there is a heat map calendar plugin available... |
| 11:01:05 | mjs | On a side Note, will RAS Admin Application be upgraded to a newer version than Apex 5.x .. Cheers |
| 11:01:14 | Christoph | Are Gantt bars linkable? |
| 11:01:17 | Juergen Schuster | You want like that but try Highcharts same technology much more options much more mature ;-) |
| 11:02:09 | zed | 2 hetmap plugins I have seen |
| 11:02:17 | Jayson Hanes | Amazing work, Hillary! |
| 11:02:39 | zed | one on apex.world also one created by Mortan Braten |
| 11:02:45 | Jayson Hanes | can we export 19.1 apps to use in 18.1/2 without issue? |
| 11:02:52 | zed | on his GitHubsite |
| 11:03:27 | emobrien | Any enhancements to reports, especially IG, for Excel (not CSV) downloads? |
| 11:03:40 | * Hilary Farrell | @Jayson - thanks very much for the positive feedback, much appreciated |
| 11:03:54 | Juergen Schuster | @emobrien: Use AOP |
| 11:04:14 | sunil | +1 for AOP |
| 11:04:16 | colina | My EA request email took about 5 hours to arrive yesterday |
| 11:04:16 | * Doug Gault | @Jayson - No. you can;’t move apps backward. Apps are FORWARD compatible though. |
| 11:04:27 | Kevin Zhang | For all chart: is this possible: I define my "SELECT" statement in a table which I can have a UI to maintain it (change the SELECT if needed) .. then APEX can read "SELECT" statement from my table and parse and generate the chart .. Basically, I am asking feature to dynamiclly parse statement from a custom table (I define myself) and use it to generate the chart ... |
| 11:04:33 | * Hilary Farrell | @Christoph - the JET ojGantt API doesn't support drilling, like the other chart types which are based on a separate API, ojChart. We will look at options to support linking in a future release |
| 11:04:35 | JESUS MORENO (TECNICA24) | I can not imagine how many companies, Oracle customers, are today spending its time using other tools other than APEX! |
| 11:04:49 | Jayson Hanes | ok; was just thinking of developing in dark mode, then using the resulting working in current production until 19.1 is released/updated on prem |
| 11:05:33 | Kevin Zhang | For all chart: is this possible: I define my "SELECT" statement in a table which I can have a UI to maintain it (change the SELECT if needed) .. then APEX can read "SELECT" statement from my table and parse and generate the chart .. Basically, I am asking feature to dynamiclly parse statement from a custom table (I define myself) and use it to generate the chart ... |
| 11:06:15 | CARDINALB | signup email was blocked by our mail gateway because the FROM was my email address so it tripped a spoofing security rule. |
| 11:06:48 | Pete K | Same with office 365 - signup email went straight into spam bin! |
| 11:07:04 | colina | @CARDINALB Thankls |
| 11:08:19 | Jeffrey Kemp | thank you, all the speakers - much appreciated |
| 11:08:37 | Mr. X | Apex is getting mature day by day, In behalf of all the Developers/Fans I would like to Thank to the development team for the hard work behind. |
| 11:08:46 | Sven Weller | +1 |
| 11:08:56 | e+4BUGxZyup250PCCsLyzg== | +1 |
| 11:09:08 | marko | +1 |
| 11:09:11 | * Doug Gault | Don’t forget that if there are things that you would like to see in APEX, go log them or VOTE for them at: |
| 11:09:21 | * Doug Gault | apex.oracle.com/vote |
| 11:09:22 | Yvo Breuer | Any chance for including AOP in APEX in the (near) future? |
| 11:09:42 | Bernhard FW (DE) | ... and its community ! +1 |
| 11:09:43 | Elizabeth | Yes, my job gets easier with all new features in each release! |
| 11:10:09 | JESUS MORENO (TECNICA24) | Please tell Mr. Ellison to buy AOP for 10+ millions $ and put it free inside APEX! |
| 11:10:14 | Jeffrey Kemp | lol |