Skip to main content
Question

Find the second to last activity

  • June 5, 2023
  • 5 replies
  • 28 views
rene.szere
Level 2

Hello,

 

I am using PU_LAST to find the last activity in each case to find the user.

PU_LAST ("OCH_Cases", "OCH_Activities". "User_Group_NAM")

 

But now I always want to find the second to last activity. How could I do that?

 

Thank you

 

Regards,

Rene

 

5 replies

G
Level 12

ACTIVITY_LAG(PU_LAST ("OCH_Cases", "OCH_Activities". "User_Group_NAM"))

 

or something like that

 

HTH

rene.szere
Level 2
  • rene.szere
  • Author
  • Level 2
  • June 6, 2023

Hello. Thank you for your suggestion. Unfortunately, this does not work because "OCH_Cases" is not an activity table.

imageDo you have another idea to solve the problem?

G
Level 12

Hello. Thank you for your suggestion. Unfortunately, this does not work because "OCH_Cases" is not an activity table.

imageDo you have another idea to solve the problem?

Then try LEAD(). I think you will need to add an order by term. Out of my place atm
G
Level 12

Hello. Thank you for your suggestion. Unfortunately, this does not work because "OCH_Cases" is not an activity table.

imageDo you have another idea to solve the problem?

Then try LEAD(). I think you will need to add an order by term. Out of my place atm
F
Level 5

If you need to find all the activities except for the first one, I would suggest to just print all of them, and then add a filter statement like activity != PU_FIRST(blabla)

Community Code of ConductAccessibility statement