06:55:01 | Denis Savenko | Familiar people... from Twitter) |
06:55:16 | * Joel Kallman | It's one big happy enthusiastic global community. |
06:55:19 | * Joel Kallman | Oh....and cool! |
06:55:27 | Jayson Hanes | =) |
06:55:41 | Denis Savenko | 48 people! That's the record! |
06:55:51 | Denis Savenko | From my memory on Office Hours) |
06:55:51 | monik | Here we are! |
06:55:52 | AE Leeds | Hello Everyone from Leeds UK. |
06:56:13 | Holger | there will be more :-) |
06:56:14 | * Joel Kallman | Hello Leeds - we're glad you could make it. |
06:56:46 | skouakou | hello |
06:56:53 | * Joel Kallman | Denis - believe it or not, that's not true. |
06:56:59 | * Joel Kallman | The .NET Office Hours had more than 100. |
06:57:03 | * Joel Kallman | The first one. |
06:57:09 | Jayson Hanes | thanks David! |
06:57:11 | Hany Ghareb | Hello APEX Expert team, i am very happy to join this session |
06:57:19 | Sohail Nawaz | Thanks David |
06:57:52 | Sohail Nawaz | Good to see all APEX Team |
06:57:57 | andrdobr | Hello Team :) glad to be here |
06:59:03 | * David Peake | Please keep your videos turned off, so you can see the APEX Team |
07:00:09 | Michael Hichwa | We can hear you joel |
07:00:39 | Hany Ghareb | voice not clear |
07:00:58 | icodealot | Sounds OK on my end. |
07:01:14 | Andre de Souza | This Apex Office Hours is the best thing Oracle came up with since apex 5 =) |
07:01:41 | adediu | yes, I have a questions regarding interactiv grid |
07:01:46 | Prashanth Raju | Good to see APEX Advancing... |
07:01:47 | adediu | *question |
07:03:11 | Denis Savenko | Just 4 more and we beat 100! |
07:03:20 | Denis Savenko | 2! |
07:09:52 | lskalais | hello |
07:09:59 | Michael Hichwa | yes |
07:10:00 | icodealot | yeo |
07:10:01 | Prashanth Raju | Yes |
07:10:04 | Dumitru Puscasu | НУЫ |
07:10:07 | Muhanna Ghaleb | hello |
07:10:09 | QCOM-BTD | hi |
07:10:09 | Dumitru Puscasu | yes |
07:10:37 | Muhanna Ghaleb | I am Muhanna from Yemen |
07:12:08 | Prashanth Raju | Wow.. |
07:12:12 | Steven Feuerstein | Great view, but where’s the apex sticker on the hill? |
07:12:27 | Vinicius Damarques | haha |
07:12:40 | Prashanth Raju | ha ha . Apex everywhere |
07:14:34 | Richie V | #darkmode |
07:14:54 | Connor McDonald | Bob does all the elegant tasteful design you see on Oracle sites. Of course, if you need any *inelegant distasteful* design, then I'm probably your guy :-) |
07:15:40 | Cathy's iPhone | hi, This is Cathy from China. APEX is a great tool, should promote more to Chinese developers |
07:16:04 | cloudtwitter | Hi |
07:16:26 | Connor McDonald | Catch Chaitanya on the ODevYathra tour in July! http://odevcyatra.in |
07:16:28 | Juergen Schuster | @Cathy: Create a Meetup and register it on apex.world and let us know what help you need? |
07:16:47 | Denis Savenko | DevOps automation... Wow! Have many question on it) |
07:17:08 | * Chaitanya Koratamaddi | thanks Connor! Yep, touring in different cities across India speaking on 18.1 |
07:17:12 | Muhanna Ghaleb | My name is Muhanna Ghaleb |
07:17:17 | Muhanna Ghaleb | I am from Yemen |
07:17:17 | Steven Feuerstein | Mad scientist doctor with that hair! |
07:17:20 | Muhanna Ghaleb | Actually we build ERP System using Apex 5.1 |
07:17:27 | Steven Feuerstein | Is David unmuted? :-) |
07:18:35 | Sheetal Kulkarni | Please elaborate on DevOps Automation for Apex. Any examples, use cases for same is documented? |
07:19:03 | Juergen Schuster | @Steven: No he got a military hair cut now :-) |
07:19:41 | Jason Straub | Was that HAL? |
07:19:47 | Denis Savenko | Mr. Robot) |
07:20:02 | Juergen Schuster | He is from a different planet anyway :-D |
07:20:02 | Rich Soule | Borg? |
07:20:17 | laoliveira | hahaha |
07:20:18 | Allan Sitterson | Intergalactic Planetary, Planetary Intergalactic |
07:20:25 | Connor McDonald | Apex will assimilate you |
07:21:31 | Forest | Hi :) |
07:21:47 | Olivia Ding | hahaha |
07:21:48 | Cathy's iPhone | Hi Kyle |
07:21:56 | Juergen Schuster | The serious guy :-D |
07:22:48 | Kyle Hu | I am? |
07:23:04 | Juergen Schuster | No Marc :-) |
07:23:16 | Steven Feuerstein | And Mike is Joel’s boss. :-) |
07:23:22 | Kyle Hu | Good to know! |
07:23:23 | Muhanna Ghaleb | -ORDS; Universal Theme; reporting (interactive report-classic report); printing using(layouts) |
07:23:26 | * Shakeeb Rahman | Mike's 30 years at Oracle was yesterday! |
07:23:38 | Denis Savenko | Looks like he's in charge of everything in Oracle) |
07:23:50 | Steven Feuerstein | Mike is the developer tools guy |
07:24:06 | Steven Feuerstein | THIRTY YEARS! |
07:25:10 | Juergen Schuster | Mike is Merlin who forged APEX :-) |
07:25:11 | Olivia Ding | Patrick help to answer so many questions of mine. Thanks |
07:25:36 | Prashanth Raju | Same here. A big thanks to Patrick and John |
07:26:02 | Patrick Wolf | You are welcome |
07:26:53 | Kenny Wang | glad to see so many live faces on twitter. |
07:27:18 | Steven Feuerstein | If you are watching this session as part of a group please tell us how many of you are present physically (but only counted as “1”) in Zoom! |
07:27:44 | Holger | 134 people in here ? wow |
07:28:00 | Peter Nosko | Hello Steven. We are 4, waiting on a 5th. |
07:28:46 | wydot | 5 of us |
07:29:13 | Steven Feuerstein | First time “your zipper” has been mentioned on an AskTOM Office Hours session |
07:29:52 | Juergen Schuster | How many presidents came from Ohio? ;-) |
07:30:24 | Greg | thanks for introducting everyone! |
07:31:43 | Earl | heard a rumor that you won’t be supporting use of Glassfish for the app server in the future. true? |
07:31:50 | Greg | how does it compare/contrast with authorization scemes? |
07:32:22 | Forest | My apex5.04 can work with tomcat 7.057. My ords version is 3.011. It can work with glassfish. Who can tell me how to solve the issue? |
07:32:39 | Greg | thanks |
07:33:05 | Forest | My apex5.04 can't work with tomcat 7.057. My ords version is 3.011. It can work with glassfish. Who can tell me how to solve the issue? |
07:33:14 | Mahesh | I would like to know, possibility of workflow in Apex. At least ready integration with any existing tool like Camunda, etc. possible ? |
07:33:16 | Muhanna Ghaleb | we use apex5.04 with tomcat 7 and ords 2 it works fine |
07:34:17 | Juergen Schuster | @Maresh: http://douggault.com/2018/06/20/reading-and-rabbit-holes-the-workflow-project-gone-astray/ |
07:34:52 | * Doug Gault | @mahesh - Niels de Bruijn did a Presentation about Integrating Camunda with APEX. https://www.slideshare.net/nielsdb/affordable-workflow-options-for-apex |
07:35:09 | Adedeji Adeeko a00298139 | Hi Chaitanya, I make use of the email approach but my concern is I have to divide the approval type to different regions |
07:36:30 | * David Peake | Please ask questions publicly please, not privately to me so everyone can see the question |
07:36:42 | SENTHIL | how does APEX compare to other low code platforms like OutSystems? |
07:36:43 | Juergen Schuster | @Adedeji: It’s a DB task problem, actually not much to do with APEX. You should be able to solve that business logic in PL/SQL |
07:37:27 | Mahesh | Thanks @Juergen Schuster and @Doug Gault |
07:37:30 | Geert De Paep | I have never understood how item values are populated. More specifically when you go to a page on which you have an item: you can specify a default value, you can set source to static value or do nothing. You can call the page without any items or call it saying ..:::ITEMX:ValueX. Then when you have a query on the page using this item, in what cases does it use the default or any other value when calling this page? Usually I do a computation on page load to populate the item, to be sure the default value is there, but probably that is not the best option. Or I write in my query "where column = nvl(:MY_ITEM,'<my_default>')" just to be sure I have the default when the item is still empty. Probably related to this, is there an explanation of the column 'Status' of an item when you click on 'session state'? Is there good documentation about the logic of all this, or can it be provided? |
07:38:13 | Juergen Schuster | @Geert: https://www.talkapex.com/2018/04/apex-page-item-source-vs-default/ |
07:38:37 | Steven Feuerstein | To those asking new questions that may not get answered today: we will go through the chat log so we can follow up in future sessions. |
07:38:43 | Geert De Paep | Thanks, I'll have a look at this |
07:39:10 | Richard Dalvi | speaker's voice is breaking. anybody else experience this? or only me... |
07:39:19 | * Marc Sewtz | APEX white papers: http://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-white-papers-1866964.html |
07:39:22 | icodealot | Sound is OK here. |
07:39:54 | * Chaitanya Koratamaddi | @Richard Dalvi there is no issue with sound |
07:40:02 | Denis Savenko | You're flattering me) |
07:40:16 | Richard Dalvi | okay, thanks Chaitanya |
07:40:17 | Steven Feuerstein | Plus at least 60 people more watching physically via 4 zoom sessions. |
07:40:22 | wydot | can we export theme roller changes from one workspace to another |
07:40:45 | * Chaitanya Koratamaddi | For the question on low code, see https://apex.oracle.com/en/platform/low-code/ |
07:41:11 | Adrian P | There is an implementation of TOTP in OOS Utils (https://github.com/OraOpenSource/oos-utils). |
07:41:34 | Eric Olson | Are there any plans to include any sort of Windows integrated authentication/single sign on as an authentication method in Apex? |
07:42:01 | * Shakeeb Rahman | @wydot: You can copy Theme Roller changes using your the JS Console. Please see the guide on http://apex-theme-styles.com/ |
07:42:20 | Kenny Wang | Question: Is there any plan for apex team to handle MySQL database as same as Oracle database within apex? Not only through REST, but also support MySQL for all apex components? |
07:42:22 | Richard Dalvi | how about O365 integration for authentication? |
07:42:32 | Juergen Schuster | @wydot: http://max-tremblay.blogspot.com/2016/04/copy-theme-roller-theme-from-one.html |
07:43:21 | * David Peake | @Kenny Wang - No plans to work with MySQL directly |
07:43:46 | Greg | Any chance someone could speak about how to use the JS API for apex.model namespace? If I call the save method what do I do on the server side to handle? |
07:44:13 | Sohail Nawaz | Can we use APEX with non-oracle databses like (MS SQL Server and MySQL) ? |
07:44:30 | Juergen Schuster | For Themes look at: https://apex-theme-styles.com/ords/f?p=800:1:::::: |
07:44:41 | hvarman | video on debugging would be helpful |
07:44:43 | Denis Savenko | @Sohail: Through REST API |
07:44:53 | Adrian P | @Richard Dalvi: In 18.1, use Social Sign In authentication scheme. Prior to that, you can use a module for Apache HTTPD and SAML2. |
07:45:05 | Brenda.Todd | @David - VIDEO - Colour (Universal theme) |
07:45:43 | Carsten Czarski | I can't |
07:45:59 | Richard Dalvi | Thanks @Adrian any document or link to implement in Apache HTTPD. could you please share |
07:46:05 | * John Snyders | apex.model currently can only be saved to a IG on the server side. Good question to ask for follow up on OTN forums |
07:46:11 | John Dent | video - Hi @David, customizing tree widget initialization for drag/drop etc would be great! |
07:46:19 | Kenny Wang | question 2: is there any plan of apex team to support wechat integration in apex? |
07:46:25 | HEIFI | video -offline capabilites |
07:46:27 | Carsten Czarski | https://www.thatjeffsmith.com/archive/2017/09/post-up-a-blob-to-an-oracle-table-via-rest/ |
07:46:32 | * Shakeeb Rahman | @Brenda.Todd: I encourage you to watch this video on Theme Roller + UT: https://www.youtube.com/watch?v=BGtJCayvHaI |
07:46:36 | christian.neumueller@oracle.com | Re Windows Authentication, that's better done at the web server. We do not have the necessary APIs in PL/SQL. There is an Apache module that you can use and you can set that up in ORDS, too. |
07:47:06 | Izzy | Hi, are there any future plans to improve the integration between Apex and eBusiness Suite ? |
07:47:10 | Adrian P | @Richard https://insum.ca/saml2-single-sign-on-with-oracle-application-express/ |
07:47:41 | Richard Dalvi | @Adrian thanks a lot |
07:48:08 | Adrian P | @Richard my pleasure |
07:48:40 | Kenny Wang | @David Peake thanks. |
07:48:41 | * Chaitanya Koratamaddi | @Izzy yes, tweeted today https://twitter.com/joelkallman/status/1012113148931764224 |
07:48:57 | Richard Dalvi | FILE ATTACH: storing the files as BLOB inside DB or in the File System, which is the best method? |
07:49:03 | Vinicius Damarques | is there any trick to work with ORDS in weblogic ? It keeps throwing 401 error when I try to get the token credentials on /oauth/token |
07:49:28 | Juergen Schuster | @Izzy: https://twitter.com/joelkallman/status/1012113148931764224 |
07:49:58 | Kyle Hu | To Kenny Wang: we will look into the WeChat integration |
07:50:01 | Patrick Wolf | @wydot unfortunately not, but you can grab the JSON stored for the theme style (Shared components -> Themes -> Theme Styles -> Theme Roller JSON Configuration), copy it over into your other workspace and then run the app and open up Theme Roller to regenerate the CSS |
07:50:09 | Andre de Souza | Question: Is there any plans to absorve plugins and/or custom packages that the community is creating ? Because for most of big companies with a lot of concerns about security would not let me use anything that is not “oracle certified” meaning if it is not within apex you cannot install it/use it. |
07:50:51 | Kenny Wang | @Kyle Hu thanks buddy. |
07:50:56 | Greg | Thanks Oracle/Apex for doing this! |
07:51:09 | wydot | thanks patrick |
07:51:44 | Juergen Schuster | @Andre: From my point of view that will never happen, Oracle will never take responsibility for foreign code. Thats your decision to use it and you can check it by yourself. But I agree with the thinking that you are dependable on one guy using his Plug-in |
07:52:43 | Greg | @Andre and @Juergen .. maybe a best practices checklist from Oracle we could point to for our QA? |
07:52:44 | * Doug Gault | @Andre - It would be very difficult to do from a legal perspective as well as Oracle doesn’t “own” the code from external plugins. |
07:53:53 | Earl | where/how do we ask questions in advance? |
07:54:07 | Andre de Souza | Maybe they could revise/integrate/maintain inside APEX the top X plugins every year or something like that |
07:54:09 | Earl | don’t see it on the office hours page |
07:54:25 | Kenny Wang | Question 3: how to leverage git for apex development? |
07:54:42 | Geert De Paep | about git: good question! |
07:54:52 | Denis Savenko | Legalizing could be different. Google or Apple don't own apps in the marketplaces, but they're still there. What I/m driving at - we want our plugin and application marketplace along with Packaged Applications repositiry =) |
07:55:00 | Greg | git...I mean good luck ;-) |
07:55:34 | Juergen Schuster | @Andre: The restriction Doug mentioned is true just for ONE single Plug-in. Less amount does not change anything ;-) |
07:55:38 | Vinicius Damarques | how APEX team use version control in APEX development? |
07:56:05 | Denis Savenko | @Vinicius - I have the same question! |
07:56:43 | * Chaitanya Koratamaddi | http://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-life-cycle-management-wp-3030229.pdf |
07:57:01 | hvarman | is it ok to include html code in our pl/sql select statement for an interactive report? what is the best practise in this case? how we can achieve the same look and feel if it is not ok to include html lines? |
07:57:26 | Steven Feuerstein | Hey I didn’t add that code, somebody else did! :-) |
07:57:45 | Jayson Hanes | @hvarman use html expression on the column |
07:57:45 | * Doug Gault | @Vinicius @Denis - There are really no surprises on how the APEX team uses Version Control . @Chaitanya just linked to a great white paper. but basically all the SQL Scripts, PL/SQL, Javascript libs, etc are kept in VCS as are the individual Applications. |
07:57:49 | Steven Feuerstein | And Carsten helped us get to the source of the problem quickly, thanks! |
07:58:17 | * Christina Cho | @hvarman, it's best use column html expression if you need to embed HTML in interactive |
07:58:29 | Juergen Schuster | @hvarman: Use HTML Expression instead #Security |
07:59:07 | hvarman | thanks for the suggestions everyone..i will look into it |
07:59:27 | Andre de Souza | There you go, I dont want to apply my own mask plugin, the ideal would be its provided inside apex. |
08:00:15 | Andre de Souza | But I understand how complicated things like this would be |
08:00:49 | Carsten Czarski | @hvarman: that does not only apply to interactive reports, but to all APEX components: Try to use declarative attributes as much as possible - and try to avoid embedding HTML code into SQL queries or PL/SQL code. That includes "HTML Expression", but also e.g. using templates for classic reports to satisfy special display requirements. |
08:01:04 | Richard Dalvi | @Chaitanya, we are really missing the audio. it will be great you can organize recorded session available. thank you. |
08:01:22 | * Chaitanya Koratamaddi | Richard Dalvi, recording will be available shortly |
08:01:31 | Richard Dalvi | Awesome |
08:01:35 | Juergen Schuster | @Andre: We have 150 Plug-ins on apex.world hard to decide what to implement internally and thats the point of Plug-ins that you can extend the App-Builder by yourself. |
08:01:43 | Denis Savenko | =) |
08:01:44 | * Chaitanya Koratamaddi | apex.oracle.com/officehours stay tuned for the recording |
08:02:17 | John Norman | Any ETA for updating the workshop in the GitHub Oracle Learning Library for Apex 18.1? |
08:02:18 | * Doug Gault | The whole point of having the plugin architecture is so that developers can extend the functionality of APEX. |
08:02:44 | * Joel Kallman | Thank you everyone for joining. I am completely enthused that the global APEX community *CRUSHED IT*....again! |
08:03:03 | Kenny Wang | anybody can let me know how to leverage git to apex? |
08:03:04 | * David Peake | @John Norman we are working on it but will take some time as including the presentations in a markdown format |
08:03:18 | Denis Savenko | Once on OTN forums we with MAX discussed the matter - and he actually implemented an app to GENERATE SELECT2 style |
08:03:19 | Denis Savenko | http://max-playground.no-ip.org/ords/f?p=SELECT2_STYLE |
08:03:22 | Elizabeth | @hvarman - using HTML embedding in your SQL exposes you to SQL injection of XSS. Like @Christina mentioned, use column HTML expressions |
08:03:22 | Denis Savenko | It's here |
08:03:34 | Juergen Schuster | We did a perfect integration of Select2 in Universal Theme |
08:03:35 | Denis Savenko | But there's only one for that specific plugin |
08:03:39 | Richard Dalvi | @Joel this is a great initiative, useful for global APEX Professionals...thanks a lot |
08:03:46 | Denis Savenko | I'd like to see more UNIVERSAL guidelines |
08:03:55 | Denis Savenko | as documentation or something.. thanks |
08:04:08 | * Shakeeb Rahman | Absolutely. |
08:04:16 | * Shakeeb Rahman | Thank you to everyone for attending! |
08:04:27 | * Chaitanya Koratamaddi | Thanks everyone! |
08:04:28 | Richie V | Are all those sessions at 10am? |
08:04:31 | Hany | Big Thanks |
08:04:35 | Jayson Hanes | thanks all! |
08:04:35 | Prashanth Raju | Thanks to all APEX EXPERTS!! |
08:04:36 | * John Snyders | There was one interactive grid question we didn't get to. There will be an interactive grid session later in the year where I can answer such questions. |
08:04:36 | John Dent | Thanks so much to the whle team - as ever, tremendous! |
08:04:37 | Michael Hichwa | Check online |
08:04:37 | AmeyaN | thank you to the Apex team.. |
08:04:38 | Anca | Thank you! |
08:04:41 | Sagar Patravale | Many thank you! |
08:04:41 | Kenny Wang | thx |
08:04:42 | Denis Savenko | Thanks, team! |
08:04:45 | Vinicius Damarques | thank you joel! |