• Session Chats

Breadcrumb

Filter

Chat

TimestampEntered ByComment
08:00:08DaxlaiRequire one session for Reporting. means wish to print customized report or in pdf format. like invoice printing etc.,
08:04:11* Joel KallmanHi Daxlai - I'm sorry, but I don't understand the question.
08:09:57SukhrajIs 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:34Amjad KhanIs 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:50Amjad KhanThank 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:00SukhrajThanks 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:42Kevin ZhangCould IG support multiple cursor editing?
08:16:51Yvo BreuerIs 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:36Scott Wesleywith 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:40Yvo BreuerTnx
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:31Jerry (Gerald) SidlerI 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:59Kevin 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:23Naveen CheekotiFilters not working for Icons
08:23:41Scott WesleyThanks David, thinking of client with sensitive data. They have solution in Oracle Forms, exploring issues of web world.
08:24:07Scott Wesleyseeing who's potentially seen what is important.
08:24:32Eric OlsonThe 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:07Naveen CheekotiHow to display blob images in Interactive Grid
08:28:48RGOOTAMHow 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:23RGOOTAMThanks
08:30:41pratapHow 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:42Naveen CheekotiHow to add custom validation before save into the table in Editable Interactive grid
08:34:09Jens KaschubaWhat's about editing in cards mode?
08:34:09Scott Wesleythese (mostly) read only looking IG seem interesting.
08:34:25Denis SavenkoSorry, 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:26Denis Savenko-
08:34:28Denis SavenkoA 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:29Denis Savenko-
08:34:41Denis SavenkoIs 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:42Denis Savenko-
08:34:46Nikola@John Snyders please show double grid example
08:35:11Niels de BruijnIs there an inline reporting possibility for a row in an Interactive Grid?
08:35:53Niels de BruijnDoes IG support subtotals (sum displayed for a group of rows)?
08:36:01Scott WesleyNeils - like the pretius nested report plugin?
08:36:13Ricardo Franciscothe popup for long text is only when IG is set editable?
08:36:19Brenda.Toddhow 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:44Daxlaihow we get these plugins
08:37:22Niels de BruijnYep, just like the pretius nested report plugin.
08:37:38toomican i get checkbox value of interactive grid with custom pl/sql when process the row ?
08:37:54* Anthony RaynerHere 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:57Brenda.Toddthanks for the URL @Anthony
08:40:21Scott Wesleythat lazy load feature should be available to IR/Classic reports, too!
08:40:35Daxlaii am not getting clearly that what John describe now where those plugin we get?
08:40:38Alastair2nd lazy load on IRs
08:40:54Naveen CheekotiFilters 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:30Niels de BruijnLazy 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:58pratapThans @David, But is there a way access data one by one of a column and process in custom PL/SQL validation block.
08:42:17MeierAWhen will the filter dialog (over actions menue) get an user freindly shape and functionality. Currently it's very ugly and combersome.
08:43:14Srihari RMaking 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:00Scott WesleyDavid, 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:48MeierAWell like in IR for example :-)
08:44:54Ajith MoniIs 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:55MeierAe.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:35Daxlaifrom where i download the app. is it inbuild in sample ?
08:47:42MeierA@Anthony: Thank you, that sounds quite good! Timeframe? :-)
08:48:33Srihari RWhen 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:45Srihari REnable 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:56Srihari RHow 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:14Niels de BruijnIt 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:14MeierA@Anthony: fun, fun, fun :-) thanks !
08:50:32Niels de Bruijn@Anthony: To change the menu options at least.
08:51:18* Anthony Rayner@Niels: Noted.
08:51:28SukhrajNot exactly related to IG's, but can APEX 18.1/18.2 integrate with EBS 12.2 easily like v5.1 did?
08:51:44Srihari 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:15garypDo 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:35Sukhraj@David - thanks. Any changes to the approach or just being revised for updated version numbers?
08:52:36Srihari R@Anthony: Declarative option to select diferent color for read-only column headers
08:52:57RGOOTAMI am unable to expand last column width?
08:53:31Srihari R@Anthony: thank you :)
08:53:41* David Peake@Sukhraj - Please contact me directly at david.peake@oracle.com
08:54:07Pratap_TeegalaHi Team, one order hdr will have multiple orrder lines and order hdr has to collapse and expand .
08:54:10Sukhraj@David - ok thank you
08:54:28Ashwincan we sort all the un saved records to view at once in Interactive Grid
08:55:17Naveen CheekotiHow 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 RaynerHere’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:19alan.quigleyI 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:36Naveen CheekotiColumn 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:29Scott WesleyAlan: I'll ask about this on the forums
08:58:44alan.quigleyGreat, I will keep an eye out for it
08:59:08* Anthony RaynerUpgrading tabular forms to IG can be done via App > Utilities > Upgrade Application
08:59:30RGOOTAMIs it possible to keep a button next to action without using any js?
08:59:32AlastairI 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:29Jeffrey Kempthank you
09:01:35Alastairthanks
09:01:36* Joel KallmanThanks. Have a great day!
09:01:43Srihari Rthank you
09:01:43Naveen CheekotiThanks David
09:01:44Niels de BruijnThx John!
09:01:46* Anthony RaynerDynamic Actions in 2 weeks@
09:01:46Juan WallGreat presentation John & David, thanks!
09:01:47Srihari Rwe love IG :)
09:01:49* Joel KallmanWell done John!
09:01:51jzalazarThanks Apex Team!!
  • 1 - 118