Hi

I am trying to calculate the time elapsed since the occurrence of a particular activity and all subsequent activities in the case.

For example, if there are 5 activities in a case, of which the activity 'Lodgement' is the second activity.

I would like to calculate the time take between 'Lodgement' and the 3rd activity, 'Lodgement' and the 4th activity and 'Lodgement' and the 5th activity.

Note:

1.The number of activities per case is not a fixed number.

2.The occurrence of 'Lodgement' activity is not fixed in the activity order.

Any pointers on how this can be done in PQL is much appreciated.

Many Thanks

Ashwin Hosbett