|
| 07:59:03 | Eric | Is that the view from your office? |
| 08:02:37 | * Marc Sewtz | https://www.facebook.com/orclapex/posts/1794313377318073 |
| 08:03:40 | Denis Savenko | What is EECS? |
| 08:03:55 | * David Peake | Exadata Express Cloud Service |
| 08:05:50 | * Marc Sewtz | bit.ly/office_hours_survey |
| 08:06:58 | Denis Savenko | Why only one version of APEX can be choosed? I have instances with 5.1 and 18.1 |
| 08:07:00 | Denis Savenko | ^) |
| 08:17:58 | * Marc Sewtz | https://apex.oracle.com/pls/apex/f?p=81870:LOGIN_DESKTOP:106527127371005::::: |
| 08:18:02 | * Marc Sewtz | demo/demo |
| 08:18:37 | Zia ur's iPhone | workspace name ? |
| 08:19:15 | * David Peake | You don’t need the workspace name as only running the app |
| 08:19:17 | rajb | Cool |
| 08:19:38 | * David Peake | Zia, you don’t need the workspace name as only running the app |
| 08:20:09 | Zia ur's iPhone | ok got it thanks |
| 08:21:00 | * David Peake | As Marc is talking about features please don’t hesitate to add questions to the chat window. I will be asking Marc the incoming questions during the Q&A section |
| 08:21:33 | * Marc Sewtz | http://hardlikesoftware.com/weblog/2018/03/30/apex-18-1-jquery-jquery-ui-and-jet-upgrade/ |
| 08:23:05 | Sheetal Kulkarni | Oracle JET is used only for charts? |
| 08:23:20 | Denis Savenko | Talking of JET - is it possible to use not only the charts which are powered by JET in APEX, but other regular components of it? And if yes, then what's the easiest way of `how`? I'm not a javascript hero, and it's not clear how to mix require.js with APEX app custom javascript |
| 08:23:55 | Denis Savenko | And not inly require.js, but knockout as well |
| 08:24:04 | rajb | JET was newly introduced from version 5.0 |
| 08:24:31 | Sohail Nawaz | The recordning of this session will be available later on .. |
| 08:24:35 | * Hilary Farrell | JET was introduced with APEX 5.1 - based on JET 2.0.2 |
| 08:24:48 | * Hilary Farrell | Re Pyramid Charts - Pyramid charts are useful for visualizing hierarchical, proportional and foundation-based relationships, process steps, organizational layers or topics interconnections |
| 08:25:14 | * Hilary Farrell | JET is also used for the AutoComplete item type that Marc already mentioned, and demo'd earlier in the session |
| 08:25:32 | * Chaitanya Koratamaddi | Yes, the recording will be available. |
| 08:26:33 | Sohail Nawaz | How it will be notified once it will be available? through e-mail or twitter ? |
| 08:26:41 | * Chaitanya Koratamaddi | On https://apex.oracle.com/officehours/ you will see a Watch Recording link |
| 08:26:53 | Dush | Can we program a drill-down link with the Gantt chart? |
| 08:27:04 | Sohail Nawaz | Thanks for the clarification .. |
| 08:27:12 | * Chaitanya Koratamaddi | Twitter |
| 08:27:50 | * Hilary Farrell | Hi Dush - no, unfortunately it's not yet supported by the ojGantt API to allow for drilling down - https://docs.oracle.com/en/middleware/jet/4.2.0/reference-api/oj.ojGantt.html |
| 08:28:27 | Pete K | Is there a way to declaritivly create a gantt with multiple tasks per row as per the example here: http://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=gantt&demo=multipleTasks The sample app doesn't seem to support that layout so I was wondering if its possilble to reproduce it in apex? |
| 08:28:36 | * Marc Sewtz | apex.oracle.com/ut/ |
| 08:30:02 | * Hilary Farrell | but we do have an enhancement request open with the JET team, to hopefully support drilling on Gantts in a future release of JET |
| 08:31:19 | * Marc Sewtz | http://bit.ly/apex-movie-sample |
| 08:31:20 | * Hilary Farrell | Hi Pete - yes multiple tasks per row is declaratively supported - I've got a demo of one in the Sample Charts app. Please note that the link you're going to is the JET Cookbook for the latest version of JET, release 5.1.0 - and with APEX 18.1 we ship with JET 4.2.0, so the APIs are different |
| 08:32:17 | * Hilary Farrell | ...and one such difference between 4.2.0 and 5.1.0 is the visibility of images in the row axis (to the left of the gantt) |
| 08:32:40 | * Marc Sewtz | https://twitter.com/shakeeb/status/1011275880855953408 |
| 08:34:29 | Dush | ok, that will be great Hilary if it supports drill-down out of the box. thanks |
| 08:34:29 | Pete K | Hi Hilary, thanks for that. When I first tried out 18.1 I couldn't reproduce something similar. I'll check the latest chart app and have another go. Appreciate the jet cookbook is a different version, it was the particular layout of tasks I wanted not worried about images etc. many thanks! |
| 08:34:35 | Sheetal Kulkarni | Can you please elaborate on steps for publishing oracle Apex application as an app for iPhone or iPad? |
| 08:36:32 | * Hilary Farrell | no worries, Pete - yes the general layout should definitely be achievable with gantt in APEX 18.1 - and I've updated the Sample Charts app for our next release, to demo how to include the red 'Reference Object' line that's visible on that example you were referring to |
| 08:37:13 | * Hilary Farrell | no problem, Dush - the JET team are very open to enhancement requests, so if there's other functionality that you'd like to see supported, please let us know |
| 08:37:15 | Zia ur's iPhone | any new enhancement for SOAP services |
| 08:37:17 | gspears | Can websources use Parameters? |
| 08:38:05 | Jason Straub | No new enhancements for SOAP in 18.1 |
| 08:38:50 | Alastair | Does the auto-complete textbox in 18.1 use result values as well as display values? |
| 08:39:34 | skouakou | @alastair Yes |
| 08:40:57 | Dush | Ok Hilary, could you tell if I can display an additional data column(or many)? |
| 08:41:10 | Kevin Zhang | will APEX 18.1 provides the same features for Oracle database 11.x vs database 12c? A related question: Oracle 12c has lots new enhancement and features to support JSON ... These features are not in database 11g ... Will future of Oracle APEX (e.g. 18.x or 19.x) requires database must be 12c? |
| 08:41:40 | Eric Olson | Can authentication and authorization be put on top of the REST enabled SQL? |
| 08:42:18 | * Hilary Farrell | Hi George - yes, re your q on parameters |
| 08:43:23 | Eric Olson | There's a lot of Javascript behind the IG and it's MVC (?) architecture, is there going to be better documentation on it? |
| 08:43:27 | Andrew Mcgugan | when will IG support rich text columns? |
| 08:43:37 | DeeDee.Anders | for the deprecated templates, 1-26, 50, etc. Will those NOT WORK at all in 18.1? |
| 08:43:42 | Eric Olson | welp, nevermind |
| 08:44:22 | * Hilary Farrell | Hi Alaistair, the answer re your autocomplete q is no |
| 08:45:18 | Alastair | Thanks, do you know if it ever will? |
| 08:45:36 | Pete K | I like the strikethrough on 'never' items - a simple change but very useful. |
| 08:45:56 | Martin M | Is the spotlight search within an application only or does it search across all applications in the workspace? |
| 08:45:59 | * Christina Cho | @DeeDee.Anders, the deprecated themes will still work in 18.1. You will not be able to create new app using old themes. Also, you will not be able to add some new components in 18.1 (i.e. Features) |
| 08:46:02 | * Hilary Farrell | Hi Alaistair, the answer is "possibly" :-) |
| 08:46:28 | rajb | Social Auths Is WOWW ..... waiting since long |
| 08:46:40 | * Hilary Farrell | Hi Martin, the search is across your app and workspace |
| 08:47:01 | Alastair | I'll keep my fingers crossed :) |
| 08:47:01 | * Hilary Farrell | ...and all apps within that workspace, obviously |
| 08:47:21 | Martin M | Excellent, thanks Hilary. |
| 08:47:34 | * Hilary Farrell | No probs, Martin |
| 08:47:40 | * Chaitanya Koratamaddi | the slide deck is available under presentations at https://apex.oracle.com/en/learn/resources/ |
| 08:47:48 | Eric | Dont know if this is a good question for this office hours but is there anything planned to discuss protecting apex for exposure directly to the web |
| 08:47:56 | Kevin Zhang | will APEX 18.1 provides the same features for Oracle database 11.x vs database 12c? A related question: Oracle 12c has lots new enhancement and features to support JSON ... These features are not in database 11g ... Will future of Oracle APEX (e.g. 18.x or 19.x) requires database must be 12c? |
| 08:49:54 | Alastair | Oracle SE and APEX on AWS, will 12.2c or APEX 18.1 be supported any time soon? |
| 08:49:55 | * Christina Cho | @Kevin Zhang, we do expose 12c specific features in some wizards. For example, you can create table with JSON CLOB type in Spreadsheet upload. Email monitor report contains extra columns only provided in 12c, etc. |
| 08:49:59 | * John Snyders | To depend on require use this syntax when adding a JS file: Use this syntax if the file has a dependency on RequireJS. This will automatically load RequireJS before this file. [require requirejs]/myjs/main.js |
| 08:50:46 | * John Snyders | I don't recommend using knockout with APEX but some people have blogged or presented about how to use it with APEX. |
| 08:52:47 | * Hilary Farrell | ...and to follow on from John's comments, take a look at the JET Legend plug-in that's included in the Sample Charts app, or even Roel Hartman's chart plug-ins on apex.world, which are really helpful when working out how to integrate JET components that aren't declaratively available in APEX (but they don't use knockout!) |
| 08:52:53 | Kevin Zhang | When will APEX plan to desupport release new version of APEX for Oracle DBMS 11g .. |
| 08:53:26 | rajb | How do you use Team Development feature to help in projects? |
| 08:53:53 | Denis Savenko | I talked about require and knockout since they're the parts of JET along with the JET webcomponents library. And if we look into the JET cookbook - the examples there require a particular strict structure. So, my question was manly about how and when to `embed` this structure to an APEX application to start using JET's combobox, i.e? (which has much more capabilities than APEX's SELECT) |
| 08:54:34 | Denis Savenko | @Hillary, that's a good advice, thanks! |
| 08:54:56 | Sheetal Kulkarni | Can we build our own plugin for lower Apex version to read data using rest webservices using API, JSON functions or any other way? |
| 08:54:58 | rajb | Can we make intra workspace applications loging using once? |
| 08:55:26 | Martin M | That's great though that you can filter the search for specific applications or global. Great! Thanks for showing that. |
| 08:55:42 | Richard Smith | Thanks! |
| 08:55:43 | Hillsborough County, FL | btw, Hillsborough County represted by 6 people today watchgin |
| 08:55:46 | rajb | Thanks Marks |
| 08:55:46 | Martin M | Thanks! |
| 08:55:47 | Hung Ta | thank you |
| 08:55:47 | Kenny Wang | thanks! |
| 08:55:52 | Ahmad Khattab | Thank you |
| 08:55:55 | Kevin Underwood | thank you |
| 08:55:55 | Ross Henderson | Thanks guys, loving the series so far, |
| 08:55:55 | Rebekah Smith | Thank you! :D |