08:00:08 | Daxlai | Require one session for Reporting. means wish to print customized report or in pdf format. like invoice printing etc., |
08:04:11 | * Joel Kallman | Hi Daxlai - I'm sorry, but I don't understand the question. |
08:09:57 | Sukhraj | Is it possible to have multiple dynamically/programmatically generated editable Interactive Grids on a single page where the number you will require will depend on some searches/logic performed in a prior page e.g. to display separate data entry forms for separate employees? |
08:12:03 | * David Peake | @Sukhraj - You can not dynamically add regions to a page. You can have multiple regions that are shown / hidden using Dynamic Actions |
08:13:34 | Amjad Khan | Is there a way to get sum of a singly column of an interacive grid that can change on runtime without saving interactive grid or page. I have did it by using javascript but is there any declerative way to do it without using javascript ? |
08:14:37 | * David Peake | @Amjad - I will ask John during the Q&A |
08:14:50 | Amjad Khan | Thank you |
08:14:55 | * Anthony Rayner | @Sukhraj: To go on from David’s answer, if you are coming from a different page, you could even use standard Server Conditions based on the ‘logic performed on the prior page’, such that APEX doesn’t render the IG regions it doesn’t need to. |
08:15:45 | * Anthony Rayner | @Amjad: There is no way to do that declaratively currently. |
08:16:00 | Sukhraj | Thanks David/Anthony. Because we wouldn't know until page rendering how many forms there could be, we wouldn't be able to define the regions upfront to hide/show them. Would it be possible to achieve something like that in APEX at all, maybe building up separate forms and associated components using apex_item instead of IG's? |
08:16:42 | Kevin Zhang | Could IG support multiple cursor editing? |
08:16:51 | Yvo Breuer | Is it now possible to position a field and/or a button between the Add Row and Reset buttons? |
08:18:06 | * David Peake | @Kevin - Please elaborate on what you mean by multiple cursor editing |
08:18:23 | * Anthony Rayner | @Yvo: The toolbar can be customized to a certain extent, please see the toolbarData option: https://docs.oracle.com/database/apex-18.2/AEXJS/interactiveGrid.html#toolbarData |
08:18:36 | Scott Wesley | with regard to the lazy loading feature - loading data as you scroll down - would one be able to keep track of which records selected/shown? for auditing? |
08:18:40 | Yvo Breuer | Tnx |
08:19:39 | * Anthony Rayner | @Yvo: Also the sample IG app contains an example with a custom button in the toolbar, see ‘Add Toolbar Button’ page. |
08:20:31 | Jerry (Gerald) Sidler | I have an interactive grid where I want to be able to have the select several rows and then apply the same change to a single column in each row.. Is that possible? For example, showing a list of tickets, our customer service groups them by customer. After helping the customer we want to update all their ticket's status to resolved.. |
08:21:59 | Kevin Zhang | "multiple cursor editing", available in many edtor tool allow you have mutliple cursors at same time to edit different lines at same time ... For example, if in IG, I want to change a value from No to Yes for several rows: if it allows mutiple cursors, I can click each cell and hold a key (e.g. Alt) to insert another cursor to another cell, then start editing all cells at same time |
08:22:04 | * David Peake | @JScott - I will ask John during Q&A |
08:22:23 | Naveen Cheekoti | Filters not working for Icons |
08:23:41 | Scott Wesley | Thanks David, thinking of client with sensitive data. They have solution in Oracle Forms, exploring issues of web world. |
08:24:07 | Scott Wesley | seeing who's potentially seen what is important. |
08:24:32 | Eric Olson | The IG always displays at 100% width, which doesn't work very well if you have only a few columns. Is there any easy way to give an IG a max-width? |
08:26:51 | * Anthony Rayner | @Jerry: John’s cookbook app contains an example of doing a similar bulk update, you can download it from here (then see the ‘Update Selection’ page): http://hardlikesoftware.com/weblog/2018/01/01/apex-ig-cookbook-for-5-1-4/ |
08:27:07 | Naveen Cheekoti | How to display blob images in Interactive Grid |
08:28:48 | RGOOTAM | How to filter IG (URL based filter) same like IR we do have IR_COLUMNNAME |
08:29:44 | * Anthony Rayner | @Kevin: No multiple cursor editing directly, but we do have the ‘Selection > Fill > Copy Down’ can help with this. Also, the previously cited ‘Update Selection’ could help for bulk updates on selected rows. |
08:29:58 | * David Peake | @RGOOTAM - That is not possible for IGs it is planned to include such functionality in a future release <#safe_harbor> |
08:30:23 | RGOOTAM | Thanks |
08:30:41 | pratap | How we can have unique check validation on a colum to check duplicate before saving into table in IG on click on Save button? |
08:31:42 | Naveen Cheekoti | How to add custom validation before save into the table in Editable Interactive grid |
08:34:09 | Jens Kaschuba | What's about editing in cards mode? |
08:34:09 | Scott Wesley | these (mostly) read only looking IG seem interesting. |
08:34:25 | Denis Savenko | Sorry, having some issues with the connectivity, so we'll be eagerly waiting for the recording and for answers on my questions in it. |
08:34:26 | Denis Savenko | - |
08:34:28 | Denis Savenko | A question regarding IG JavaScript API. There's widget called `grid` in the documentation on APEX's JavaScript API. In 18.2 docs there's also new widget called `interactiveGrid`. The question is what is the relation between these widgets and the Interactive Grid APEX item itself? How one does use these widget to control JS-part of the IG item? |
08:34:29 | Denis Savenko | - |
08:34:41 | Denis Savenko | Is there a way to REDRAW the IG item with a different number of columns ON-THE-FLY using the JavaScript API of the item (as it's possible for the TABLE and GRID components of the JET toolset)? |
08:34:42 | Denis Savenko | - |
08:34:46 | Nikola | @John Snyders please show double grid example |
08:35:11 | Niels de Bruijn | Is there an inline reporting possibility for a row in an Interactive Grid? |
08:35:53 | Niels de Bruijn | Does IG support subtotals (sum displayed for a group of rows)? |
08:36:01 | Scott Wesley | Neils - like the pretius nested report plugin? |
08:36:13 | Ricardo Francisco | the popup for long text is only when IG is set editable? |
08:36:19 | Brenda.Todd | how can i get to this IG Cookbook John is using? |
08:36:25 | * David Peake | @pratap / Naveen - You can define validations against IG columns which execute prior to the process to insert / update records |
08:36:44 | Daxlai | how we get these plugins |
08:37:22 | Niels de Bruijn | Yep, just like the pretius nested report plugin. |
08:37:38 | toomi | can i get checkbox value of interactive grid with custom pl/sql when process the row ? |
08:37:54 | * Anthony Rayner | Here is the current URL for the cookbook, although John did say he would update it in the next few days so stay tuned: http://hardlikesoftware.com/weblog/2018/01/01/apex-ig-cookbook-for-5-1-4/ |
08:38:57 | Brenda.Todd | thanks for the URL @Anthony |
08:40:21 | Scott Wesley | that lazy load feature should be available to IR/Classic reports, too! |
08:40:35 | Daxlai | i am not getting clearly that what John describe now where those plugin we get? |
08:40:38 | Alastair | 2nd lazy load on IRs |
08:40:54 | Naveen Cheekoti | Filters not working for Report with icons like Rating column |
08:41:09 | * David Peake | @Scott - Unfortunately these components have a completely different architecture which doesn’t support lazy loading |
08:41:30 | Niels de Bruijn | Lazy loading should be used to load further content in the background while the user is working with the current data. This also implies more rows as visible on the page. |
08:41:42 | * Anthony Rayner | @Denis: The grid widget is a generic widget for grid functionality. The interactiveGrid widget orchestrates the grid widget, and a number of other widgets and modules, to provide the full IG capability required by APEX. For example, the IG widget adds the APEX-specific toolbar (search, actions menu, etc.), this is not part of the grid widget. John's architecture diagram here helps explain it: http://hardlikesoftware.com/weblog/2016/06/08/interactive-grid-under-the-hood/ |
08:41:58 | pratap | Thans @David, But is there a way access data one by one of a column and process in custom PL/SQL validation block. |
08:42:17 | MeierA | When will the filter dialog (over actions menue) get an user freindly shape and functionality. Currently it's very ugly and combersome. |
08:43:14 | Srihari R | Making one column read-only for a row, depending on values from other column from same row, does not work for rows that are being added newly. Is there any work around please? |
08:44:00 | Scott Wesley | David, as Maxime has demonstrated, we can build our own lazy loading - at least de-coupling from the page render, just like JET charts |
08:44:04 | * David Peake | @MeierA - If possible could you please provide a URL to a similar component that looks goos and is intuitive to use (We are always looking for ways to improve the UI and UX) |
08:44:48 | MeierA | Well like in IR for example :-) |
08:44:54 | Ajith Moni | Is this IG and form a custom code or available by default |
08:45:37 | * Anthony Rayner | @MeierA: We do have a specific enhancement request for improving IG dialog usability, so it’s definitely on our radar. |
08:45:55 | MeierA | e.g want to mark more then only one col and move it up/down ... |
08:46:39 | * David Peake | @Daxlai - Re: Where do you get the plugins — You can download the app and copy / subscribe any plugins used within the app |
08:47:35 | Daxlai | from where i download the app. is it inbuild in sample ? |
08:47:42 | MeierA | @Anthony: Thank you, that sounds quite good! Timeframe? :-) |
08:48:33 | Srihari R | When first 3-4 columns are freezed, and if we open IG page in smaller screens like tabs or mobile phone, then we hardly see the scroll bars. Is it possible to implement unfreeze the columns automatically on smaller screens? |
08:48:34 | * David Peake | @Daxlai - http://hardlikesoftware.com/weblog/2018/01/01/apex-ig-cookbook-for-5-1-4/ |
08:48:45 | Srihari R | Enable Edit mode by default - again possible by using JS. But it would be great if there is an out-of-box option in IG properties. |
08:48:56 | Srihari R | How to preserve IG row selection after page submit? There is some JS work-around, but if we can set a page item which defines current row selection somewhere in IG propertis, that would be great. |
08:48:57 | * Anthony Rayner | @MeierA: Not currently decided, but it has priority #safeharbour ;-) |
08:49:14 | Niels de Bruijn | It would be nice to see more options declarative for IG in APEX 19.x |
08:49:46 | * Anthony Rayner | @Neils: re: more declarative options, What would be your top ones? (Open question) |
08:50:14 | MeierA | @Anthony: fun, fun, fun :-) thanks ! |
08:50:32 | Niels de Bruijn | @Anthony: To change the menu options at least. |
08:51:18 | * Anthony Rayner | @Niels: Noted. |
08:51:28 | Sukhraj | Not exactly related to IG's, but can APEX 18.1/18.2 integrate with EBS 12.2 easily like v5.1 did? |
08:51:44 | Srihari R | @Anthony: Declarative option to show IG in edit mode by default. |
08:51:56 | * David Peake | @Sukhraj - Yes. Revised white paper should be available soon |
08:52:15 | garyp | Do you recommend allowing the grid to automatically run dml on tables or is it better to run stored procedures? |
08:52:15 | * Anthony Rayner | @Srihari: Noted. |
08:52:35 | Sukhraj | @David - thanks. Any changes to the approach or just being revised for updated version numbers? |
08:52:36 | Srihari R | @Anthony: Declarative option to select diferent color for read-only column headers |
08:52:57 | RGOOTAM | I am unable to expand last column width? |
08:53:31 | Srihari R | @Anthony: thank you :) |
08:53:41 | * David Peake | @Sukhraj - Please contact me directly at david.peake@oracle.com |
08:54:07 | Pratap_Teegala | Hi Team, one order hdr will have multiple orrder lines and order hdr has to collapse and expand . |
08:54:10 | Sukhraj | @David - ok thank you |
08:54:28 | Ashwin | can we sort all the un saved records to view at once in Interactive Grid |
08:55:17 | Naveen Cheekoti | How to change tabular form to interactive grid |
08:55:17 | * Anthony Rayner | @Srihari: Regarding read-only columns, so you would like to better differentiate column headings, where the column is read-only? |
08:56:47 | * Anthony Rayner | Here’s a link to a German blog post regarding blob-columns, it’s in German, so you may have to Google Translate it: https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/4221/index.html |
08:57:19 | alan.quigley | I would also like to know about the lazy loading on the IG for auditing purposes. That is something that I have recently thought about. |
08:57:36 | Naveen Cheekoti | Column filter for icons not working |
08:57:57 | * David Peake | @Naveen - Will ask about icon column sorting |
08:58:09 | * David Peake | *filters |
08:58:29 | Scott Wesley | Alan: I'll ask about this on the forums |
08:58:44 | alan.quigley | Great, I will keep an eye out for it |
08:59:08 | * Anthony Rayner | Upgrading tabular forms to IG can be done via App > Utilities > Upgrade Application |
08:59:30 | RGOOTAM | Is it possible to keep a button next to action without using any js? |
08:59:32 | Alastair | I joined late so sorry if this was shown, is it possible to 'tone down' IG to look like IRs or CRs to take advatange of some but not all features |
09:01:13 | * Anthony Rayner | @Alastair: There are some configuration options both declaratively, and via the JS options (https://docs.oracle.com/database/apex-18.2/AEXJS/interactiveGrid.html) to simplify the toolbar for example. |
09:01:29 | Jeffrey Kemp | thank you |
09:01:35 | Alastair | thanks |
09:01:36 | * Joel Kallman | Thanks. Have a great day! |
09:01:43 | Srihari R | thank you |
09:01:43 | Naveen Cheekoti | Thanks David |
09:01:44 | Niels de Bruijn | Thx John! |
09:01:46 | * Anthony Rayner | Dynamic Actions in 2 weeks@ |
09:01:46 | Juan Wall | Great presentation John & David, thanks! |
09:01:47 | Srihari R | we love IG :) |
09:01:49 | * Joel Kallman | Well done John! |
09:01:51 | jzalazar | Thanks Apex Team!! |