2 Replies Latest reply on Jul 28, 2017 6:09 AM by Anthony Rayner-Oracle

    Apex 5.1 Interactive Grid: Filter error after supplying advanced JS code

    trent

      Not sure if on the radar already, but just picked up on this error in apex.oracle.com when clicking the filter button. Actually, the first time it didnt happen, then I added an advanced JS function to the grids attributes, and it happened every time - even after logging out, removing the js function, etc.

       

      Reproduce steps (on apex.oracle.com)

       

      1. Create an IG (I created just by adding to an existing page - query select * from emp).

       

      2. Open filters box

       

      3. Click cancel

       

      4. Repeat step 2

       

      Error appears in console:

       

      Error in menu action. TypeError: Cannot read property 'length' of null

          at $.(anonymous function).(anonymous function)._renderRow (https://apex.oracle.com/i/libraries/apex/widget.grid.js?v=5.1.1.00.08:3939:30)

          at $.(anonymous function).(anonymous function)._renderRow (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:401:25)

          at $.(anonymous function).(anonymous function)._insertRecord (https://apex.oracle.com/i/libraries/apex/widget.grid.js?v=5.1.1.00.08:3681:18)

          at $.(anonymous function).(anonymous function)._insertRecord (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:401:25)

          at Object.modelChangeHandler [as onChange] (https://apex.oracle.com/i/libraries/apex/widget.tableModelViewBase.js?v=5.1.1.00.08:408:41)

          at notifyChange (https://apex.oracle.com/i/libraries/apex/model.js?v=5.1.1.00.08:251:26)

          at Object.insertNewRecord (https://apex.oracle.com/i/libraries/apex/model.js?v=5.1.1.00.08:2636:13)

          at HTMLDivElement.load (https://apex.oracle.com/i/libraries/apex/widget.interactiveGrid.js?v=5.1.1.00.08:3797:44)

          at HTMLDivElement.open (https://apex.oracle.com/i/libraries/apex/widget.recordView.js?v=5.1.1.00.08:2188:57)

          at $.(anonymous function).(anonymous function)._trigger (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:785:13)

       

      debug.error @ debug.js?v=5.1.1.00.08:190

      invokeItem @ widget.menu.js?v=5.1.1.00.08:716

      mouseup @ widget.menu.js?v=5.1.1.00.08:951

      handlerProxy @ jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:702

      dispatch @ jquery-2.2.3.js?v=5.1.1.00.08:4737

      elemData.handle @ jquery-2.2.3.js?v=5.1.1.00.08:4549

       

      Uncaught TypeError: Cannot read property '2' of null

          at $.(anonymous function).(anonymous function)._getColumnMetadata (https://apex.oracle.com/i/libraries/apex/widget.grid.js?v=5.1.1.00.08:4109:37)

          at $.(anonymous function).(anonymous function)._getColumnMetadata (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:401:25)

          at HTMLTableCellElement.ttOptions.content (https://apex.oracle.com/i/libraries/apex/widget.grid.js?v=5.1.1.00.08:1261:39)

          at $.(anonymous function).(anonymous function)._updateContent (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:6764:27)

          at $.(anonymous function).(anonymous function)._updateContent (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:401:25)

          at $.(anonymous function).(anonymous function).open (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:6751:8)

          at $.(anonymous function).(anonymous function).open (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:401:25)

          at HTMLDivElement.handlerProxy (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:702:7)

          at HTMLDivElement.dispatch (https://apex.oracle.com/i/libraries/jquery/2.2.3/jquery-2.2.3.js?v=5.1.1.00.08:4737:27)

          at HTMLDivElement.elemData.handle (https://apex.oracle.com/i/libraries/jquery/2.2.3/jquery-2.2.3.js?v=5.1.1.00.08:4549:28)

       

      widget.grid.js?v=5.1.1.00.08:4109 Uncaught TypeError: Cannot read property '2' of null

          at $.(anonymous function).(anonymous function)._getColumnMetadata (https://apex.oracle.com/i/libraries/apex/widget.grid.js?v=5.1.1.00.08:4109:37)

          at $.(anonymous function).(anonymous function)._getColumnMetadata (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:401:25)

          at HTMLTableCellElement.ttOptions.content (https://apex.oracle.com/i/libraries/apex/widget.grid.js?v=5.1.1.00.08:1261:39)

          at $.(anonymous function).(anonymous function)._updateContent (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:6764:27)

          at $.(anonymous function).(anonymous function)._updateContent (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:401:25)

          at $.(anonymous function).(anonymous function).open (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:6751:8)

          at $.(anonymous function).(anonymous function).open (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:401:25)

          at HTMLDivElement.handlerProxy (https://apex.oracle.com/i/libraries/jquery-ui/1.10.4/ui/jquery-ui-1.10.4.custom.js?v=5.1.1.00.08:702:7)

          at HTMLDivElement.dispatch (https://apex.oracle.com/i/libraries/jquery/2.2.3/jquery-2.2.3.js?v=5.1.1.00.08:4737:27)

          at HTMLDivElement.elemData.handle (https://apex.oracle.com/i/libraries/jquery/2.2.3/jquery-2.2.3.js?v=5.1.1.00.08:4549:28)

      See page/example: https://apex.oracle.com/pls/apex/f?p=133171:1:13709292379288:::::

       

      The JS function I supplied was just something basic, and I've since removed it.