4 Replies Latest reply on Apr 22, 2020 1:16 PM by inuser494271

    How to add conditions and order by to Object List?

    New Member

      Hi,

       

      I am having a requirement to get the max(id) from an oracle source view inside my ICRT process. I am using a temp object at Start pointing to the Oracle connection -> List of xyzView. ICRT pulls the first 100 rows from this view and stores in the temp variable.

       

      However, I want to retrieve the maximum value of the "Id" field from the xyzView.

       

      In the assignment step I am able to add only condition and not able to use standard oracle functions.

      Any idea how do I proceed?

       

      PS: The underlying requirement for me is to have a sequence generator in place. Since I am not able to achieve it, I am trying to get the Max(id) and increment it by one before an insert.

       

      Thanks,

      Venkat