Hello
In a scenario where there are multiple instances of “WIP CB IP” activity, I am trying to identify the first instance along with the next activity taken by a user. I am easily able to identify the first WIP activity (highlighted in blue) using PU_FIRST. However, when I attempt to identify the next activity following the first WIP, I end up retrieving the activity for the 2nd WIP line (highlighted in yellow and red). I would like to report on the activity highlighted in green.
I have tried wrapping the PU_FIRST within the ACTIVITY_LEAD but the syntax failed indicating that “/IRM/IPCBITM” is not within the Activity table. I have also attempted to use a CASE WHEN statement but that just generated two WIP lines. I am only interested in the first instance of WIP.
Thanks in advance,
Phil
