5 Replies Latest reply on Feb 19, 2019 10:07 PM by LinoS

    APEX 18.2 - Interactive grid issue with virtual aggregate column when using Automatic Row Processing

    LinoS

      If you add a virtual aggregate column to your IG your Automatic Row Processing process stops working completely!!

       

      First you get

      After you set Prevent Lost updates on your page process to No

      the error changes

       

      but it still does not work.

       

      It simple to reproduce

      - Create a page,

      - create an IG region with select * from emp;

      - make it editable

      - save and run (everything works fine right!!?)

      - Add row_number() over(order by empno desc) row_nbr,

      - set it to be hidden and Source to be Query only

       

      Your IG Save process for some reason is now broken. Demo example on apex.oracle.com -> https://apex.oracle.com/pls/apex/f?p=84111:15

       

      Did anyone find a proper workaround or has seen this issue before? I assume using a manual PL/SQL process should do the trick but I would expect Automatic Row Processing to still work.

       

      Thank you.

       

       

      p.s. Even with a manual processing it still does not seem to work

       

       

       

      Weird thing is as soon as you add it to your source IG reorders your columns too!!!