Visual Builder

Get Involved. Join the Conversation.

Topic

    Stephen Bryant
    Data Grid - Jet Cookbook - how to implement in VBCS 19.1.3Answered
    Topic posted July 28, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Composite Component, Custom Code, JET, Layout, UI, Validation, Web 
    43 Views, 6 Comments
    Title:
    Data Grid - Jet Cookbook - how to implement in VBCS 19.1.3
    Summary:
    Data Grid - add to VBCS
    Content:

    Hello,

    I would like to add the Jet Cookbook Data Grid to a VBCS application because I believe it would be a lot easier to manage the state of the grid as users enter data.  In other words an "observable array" in the knockout.js style.  Currently, I have to employ a series of functions to keep the state of the grid current and it is getting a little too clunky in my opinion.  That is, users will see field refreshes far too often.  This can be avoided using an observable array.

    This subject was previously discussed in this post a while back:

    https://cloudcustomerconnect.oracle.com/posts/a1307bbb7e

     

    I am on version 19.1.3 and was wondering if anyone knows how to incorporate the JET Cookbook data grid (editable) that is seen here:

    https://www.oracle.com/webfolder/technetwork/jet-420/jetCookbook.html?component=dataGrid&demo=editableGrid

    I've tried but cannot get it to render.

    Thanks,

    Steve

     

     

    Version:
    19.1.3

    Best Comment

    David Konecny

    No, I have not used data grid before. Recently there have been few questions about it so I built the sample I shared with you but that's all. I added another page to my sample app where there are three data grids: one using SDP, second for ADP and third for JET ADP. Keep in mind that SDP and ADP are VB implementations of JET DataProvider APIs and they are different from JET ADP. And JET Cookbook is always using JET ADP which means that using VB's ADP may lead to a different outcome (in theory it should NOT). I can see that SDP is not working and I will file bug for it. But VB ADP and JET ADP work both fine - see the new sample attached.

    From other questions about data grid I've seen the click event handling might be challenge too - event does not get "row" context you would expect from oj-table. I need to enquire about that too.

    -David

     

    Comment

     

    • David Konecny

      Attached is 19.1.3 VB app which shows how to use Data Grid in VB. There are few things to be aware of:

      * JET APIs seem to be changing a lot in between releases so in order to convert JET Cookbook example into VB you need to follow JET cookbook for JET version used in VB. Which for VB 19.1.3 is JET 6.1. The attached sample may or may not work when VB switches to JET 7.

      * JET Data Grid examples are all using knockout templates which are real pain to work with in VB because they are not using "$current" for accessing available data but their own accessor and structure (Knockout's $context)

      -David

       

      • Stephen Bryant

        David,

        Thanks again for being a great help.

        I will take a look.

        Thanks,

        Steve

      • Stephen Bryant

        David,

        Have you attempted to use the data grid in VBCS?  I've tried to assign an ADP to the grid but it will not render.

        Any thoughts?  There isn't much chatter about this at all so I just keep trying things.

        Thanks,

        Steve

        • David Konecny

          No, I have not used data grid before. Recently there have been few questions about it so I built the sample I shared with you but that's all. I added another page to my sample app where there are three data grids: one using SDP, second for ADP and third for JET ADP. Keep in mind that SDP and ADP are VB implementations of JET DataProvider APIs and they are different from JET ADP. And JET Cookbook is always using JET ADP which means that using VB's ADP may lead to a different outcome (in theory it should NOT). I can see that SDP is not working and I will file bug for it. But VB ADP and JET ADP work both fine - see the new sample attached.

          From other questions about data grid I've seen the click event handling might be challenge too - event does not get "row" context you would expect from oj-table. I need to enquire about that too.

          -David