|
| 07:58:15 | Elis | or publish integrator data automatically on APEX? |
| 08:01:13 | Elis | It is the tool used by analyst ( it is a Clover ETL tool) |
| 08:01:56 | * David Peake | @Elis - Not aware of that tool |
| 08:01:59 | Kevin Zhang | anyone from Chicago area? |
| 08:02:18 | * Doug Gault | @Geert - It’s probably better to ask specific technical questions in the Forums |
| 08:02:31 | * Joel Kallman | @Kevin - Columbus, Ohio. That's almost Chicago (250 miles away). ;) |
| 08:03:49 | Kevin Zhang | Is it possible the future APEX (e.g. APEX 19.x) will stop support for Oracle DB version 11 and only support for DB v12 or above? |
| 08:05:52 | * David Peake | @Kevin - DB Support is based on the DB version being supported. For example we stopped supporting installation into 11gR1 when it was no longer supported. APEX may work in older versions but we don’t do any testing so we don’t support the older DB versions |
| 08:06:03 | Jacob Overgaard Madsen | I would like to ask, what the recommended way of creating token-based login to APEX. I need to create a token-based login, where the token is generated from Oracle Forms and then submitted to APEX, and then the user is logged in, without having any login page displayed. Do you use the Sentry Function, Invalid Session function, or how do you create something like this? All the token validation functions are already in the database. Thanks in advance. |
| 08:06:33 | * David Peake | @Jacob - Plz ask non chart questions on the APEX OTN Discussion forum |
| 08:07:28 | Kevin Zhang | For APEX 18.x: does it work for IE version 11? my company is still use IE v11 as standard browser; |
| 08:07:47 | * David Peake | @Jacob https://community.oracle.com/community/database/developer-tools/application_express |
| 08:08:14 | Jacob Overgaard Madsen | I already tried doing so several times without really getting a response. |
| 08:08:17 | * David Peake | @Kevin, Yes APEX 18.x does work with IE11 or MS Edge |
| 08:08:18 | Ahmad Khattab | Are these charts downloadable ? |
| 08:08:37 | christian | @Jacob please post a link to the discussion |
| 08:09:35 | Kevin Zhang | Will future APEX version (e.g. 19.x +) plan to stop support IE11? Is there a planned date to desupport using IE11 for APEX application? |
| 08:10:00 | Geert De Paep | If I have a page with some table data and one or more charts, what would be the best option to convert it into a pdf document? |
| 08:10:16 | Seetharaman R | Why Data Visualization for Apex ? |
| 08:10:17 | * David Peake | Could everyone please keep their videos turned off as we are recording this session |
| 08:10:17 | * Doug Gault | @Kevin - Joel already answered your question.. APEX Support is based on whether the version of the DB is still supported by Oracle. |
| 08:11:00 | Jacob Overgaard Madsen | I can't get on the forum right now. "Experiencing technical difficulties". |
| 08:11:04 | Kevin Zhang | Is the Sample/Demo APEX application in this session downloadable? If Yes, can you provide instruction for the download? Thanks! |
| 08:12:00 | * David Peake | @Kevin - Yes go to Packaged Apps > Sample Charts |
| 08:12:51 | * Doug Gault | @Geert - There are various options for this depending on how much control you want and how much code you want to write. PL/PDF allows you to write code to generate PDFs in PL/SQL. APEX Office Print is more a plugin based generation engine. There are also a few open source libraries out there to generate PDF’s but most require you to write code and query the APEX data dictionary. |
| 08:12:59 | * David Peake | That is the standard sample app that shows all the different chart types |
| 08:13:14 | Sven Weller | What is the main customizations/changes from original JET to apex JET. I'm thinking especially in terms of css adoptions. |
| 08:14:13 | Yvan | 能发中文吗，大胸弟 |
| 08:14:27 | Kevin Zhang | What other Oracle product is also using Oracle JET as the DV engine? |
| 08:14:52 | gspears | With IG, the javascript Initialization area is incredibly limited in size (4K maybe). Is that the same for Charts? |
| 08:15:13 | Sven Weller | @Kevin: Many. Visual Cloud Build Service, for example. |
| 08:16:35 | Kevin Zhang | can Oracle JET generate Heat Map chart? |
| 08:16:35 | Kyle Hu | @gspears best practice is to have your logic outside the Initialization area, for example, in your core.js and call the function name only in initialization area, like myApp.initChart() |
| 08:18:42 | * Doug Gault | @Kevin - The full list of JET charts is available on the JET site. http://jet.us.oracle.com/5.2.0/jetCookbook.html?component=dataVisualizations&demo=gallery |
| 08:19:10 | * Doug Gault | However, all of those charts are not necessarily supported in APEX declaratively |
| 08:20:05 | * Doug Gault | @Kevin - Check the Charts Sample App to see all the charts supported declaratively in APEX |
| 08:21:46 | Sven Weller | @Kevin: There are several chart types in Jet that can create heatmap like vizualisations. Here is one example using pictocharts: http://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=dataVisualizations&demo=horizontalBlockCalendar |
| 08:22:13 | Kevin Zhang | Oracle JET latest version support Heat Map ... now question is: Can we generate heat map in Oracle APEX 18.x? |
| 08:22:34 | Sven Weller | Unfortunatly pictocharts are not directly usable in Apex. But the source libararies are all there and can be referenced. But might need a while to understand how to do it. |
| 08:24:05 | Alastair | Can I see a Gantt chart example please |
| 08:24:24 | gspears | You can have a filter with IR... I assume you can do the same with IG? |
| 08:25:27 | * Doug Gault | @gspears - Not a chart question, but if I understand the question, I believe the answer is yes |
| 08:25:30 | Kevin Zhang | I see the Code Editor has a black color as background? Is this standard behavior in APEX 18.x? |
| 08:25:55 | * David Peake | @George - Actually you can not use URL filtering on IGs |
| 08:26:41 | gspears | @doug - Hilary just showed clicking a chart, and filtering to IR. My question is ... can I click on a chart and go to a filtered IG as a drilldown... |
| 08:27:23 | * David Peake | @GSpears - No that functionality (= URL Filtering) is not available with Its … it is planned for a future release |
| 08:27:23 | * Doug Gault | @gspears Ah.. I think David answered that. IG’s don’t currently support URL filtering like Its do. |
| 08:27:27 | * Doug Gault | IRs |
| 08:27:40 | * David Peake | IGs |
| 08:28:36 | Sven Weller | Please focus on that IG url-filtering. It hurts that this is still missing. |
| 08:29:23 | Kevin Zhang | Can you demo a "cool" chart in APEX? so far, the demo is all for some basic chart ... Can you show some cool chart so that I can explain to my boss why APEX chart should be considered ... |
| 08:30:38 | * David Peake | @Kevin- Re:Code Editor you can change the color scheme used by clicking on the Settings within the editor … there are a large number of different color schemes you can select |
| 08:30:43 | Kevin Zhang | again: the background of Code Editor is black, which is very good ... my question is: is this a standard feature in APEX 18.x or Hilary is using some sort of plugin to change the default theme for the code editor? |
| 08:31:16 | * Doug Gault | @Kevin - Jumping right to the “cool” charts without understanding how the basics work would kind of defeat the purpose of the Office Hours . She may be able to do it toward the end. |
| 08:31:17 | Kevin Zhang | Thanks for the answer for the Code Editor color scheme .. this is very good feature .. |
| 08:31:58 | * Joel Kallman | @Kevin - if you want to see "cool" charts, go to https://apex.oracle.com/charts |
| 08:32:20 | Kevin Zhang | There are so many thenique can generate chart these days ... if you can demo an amazing chart that can be done easily using APEX along with JET, that will make APEX shining ... |
| 08:32:35 | * Joel Kallman | @Kevin: https://apex.oracle.com/charts |
| 08:34:38 | Kevin Zhang | if in future APEX release, apex Code Editor can do some similar feature like VS Code editor, that will be super. Such as: multiple cursor, quick duplicate lines and move lines around etc ... |
| 08:34:56 | Sven Weller | I think multi cursor already works |
| 08:36:39 | Kevin Zhang | I will try out "multi cursor" .. I haven't try APEX 18.1 .. I am waiting release of 18 XE... then I will play APEX 18.x in 18 XE db ... I think it is coming soon ... |
| 08:36:59 | * David Peake | @Kevin - Sign up on apex.oracle.com and test today |
| 08:37:01 | * Joel Kallman | @Kevin - FYI, APEX 18.1 is available on https://apex.oracle.com today. |
| 08:37:09 | * Joel Kallman | @Kevin - free for everyone |
| 08:37:54 | Sven Weller | Just confirmed Multi Cursor works already in 5.1.3. And probably before that. |
| 08:37:55 | amit_kumar05 | Please suggest if we have used Jet Charts developed in Apex for any oracle cloud SaaS customization in Finance or SCM standard pages. |
| 08:38:14 | * Joel Kallman | @Kevin - as you probably know, 18c XE isn't targeted until October (so says Gerald Venzl, the PM for XE): https://twitter.com/GeraldVenzl/status/1022270359318360064 |
| 08:39:03 | * Joel Kallman | @Amit - sorry, I don't quite understand your question. Can you please clarify? |
| 08:39:04 | * David Peake | @Amit - SaaS does not include APEX. However, some are starting to incorporate JET charts directly. I’m not sure which specific products are already using JET Charts |
| 08:39:05 | gspears | How well does Jet Charts handle region resize? For example, if I collapse the APEX menu on the left, or resize the browser window, does the chart resize? |
| 08:39:25 | * David Peake | @GSPears - Yes JET Charts are responsive |
| 08:40:49 | Aravindan | Is there legend is clickable??? |
| 08:41:05 | Administrator | @gspears 属性可以设置 |
| 08:42:08 | * David Peake | @Aravindan - Yes Hilary is clicking on the Legend and it hides / shows that group rendering |
| 08:42:42 | Sven Weller | @Aravindan Yes, there is an option to make a legend clickable and make charts react on those clicks. There is an example in the Sample Charts app I think. |
| 08:43:09 | amit_kumar05 | Please suggest how we can monitor APEX page performance and any UI available for same to monitor specific dahboard and know the code performances. |
| 08:43:44 | * David Peake | @AMit - Please ask non chart questions on the APEX OTN Forum |
| 08:43:50 | Seetharaman R | Can we edit SQL in front end ? |
| 08:45:20 | Michael Patton | Will there be a future opportunity to Fill Gaps and provide a custom sort? |
| 08:45:35 | * Doug Gault | @Seetharaman - Not directly, but charts do allow you to create a chart on a function returning a SQL Query. You could create a function to read what the user enters, parse it (to make sure it’s a valid sql) then return it to the chart. |
| 08:46:01 | * David Peake | @Seetharamman - Not by end users for Charts. Install Packaged Apps > Data Reporter for allowing end users to define reports, etc |
| 08:49:35 | Seetharaman R | Are the packages available within apex or to be done by our own ? |
| 08:49:58 | Jerry Sidler | I have a dashboard with about 16 charts... Even though each chart is almost fully displayed a scrollbar is showing up. Is there a way to force scrollbars off |
| 08:49:59 | * David Peake | Packaged Apps are part of the APEX Distribution |
| 08:51:39 | Sven Weller | @Kevin: The dark background is build into Apex 18. You have a choice of more than 10 different styles for the editor then |
| 08:53:34 | Ghyslain Laramée | Where can we get the Slides? |
| 08:54:11 | Seetharaman R | Could you share about JET Plugins? |
| 08:54:45 | gspears | FYI - I have used D3 with Apex, and it appears to work fine... |
| 08:54:54 | Stephen.Cloete | Any plans to provide an Export/download Charts within IR and IG ? |
| 08:56:08 | * Joel Kallman | @Ghyslain - we'll make sure we publish them in the next day or so. If you follow @OracleAPEX on Twitter, we'll make sure they're announced from there. |
| 08:56:35 | Venkat | It seems there is lot of learning curve to configure in order to produce good quality charts, when comparing with standard reporting/data visualization tools. |
| 08:56:55 | Olivia Ding | no twitter in China... |
| 08:57:07 | * Joel Kallman | @Olivia - I'll email you directly. ;) |
| 08:57:16 | Olivia Ding | thank you |
| 08:57:44 | Ghyslain Laramée | Thanks! will do |
| 08:57:45 | * Doug Gault | @Venkat - This is a programming tool as opposed to an end user tool. Therefore more programatic options are exposed. |
| 08:58:07 | gspears | With JET version 5.2.0 being released, any idea when we see that in APEX? |
| 08:58:34 | Sven Weller | @gspears: You can use it now. https://svenweller.wordpress.com/2018/08/21/add-jet-5-1-5-2-to-apex-via-cdn/ |
| 08:58:58 | Kevin Zhang | Can you consider support Heat Map chart in the future APEX version? Heat Map is very popular and useful chart type these days ... |
| 08:59:23 | Venkat | @Doug, agreed. But components like IR/IG are much better than what you get from standard reporting tools used by super users. |
| 08:59:32 | Seetharaman R | Difference between APEX & JET charts ? |
| 08:59:36 | Anca | Thank you! |
| 08:59:38 | Kevin Zhang | Thank you for this nice session!!!! |
| 08:59:42 | Daxlai | very good presentatioo |
| 08:59:42 | * Joel Kallman | Thanks for attending! |
| 08:59:44 | Juan Wall | thanks! |
| 08:59:45 | mentzel iudith | Thanks :) |
| 08:59:48 | Sven Weller | bb |
| 08:59:49 | Seetharaman R | Thanks mate Cheers |
| 08:59:49 | Olivia Ding | thank you ~~~ |