In the dataset I have many Case ID’s all of them that goes through some statuses, the process is not fixed, but at a point in time the Case’s should be Closed in the CLSD status.
For the two CaseId examples I would like to get (for each) the rows that is before including CLSD row. For instance, CaseId 789101 I would like to get all the rows except NCMP and PLIP since they have a higher FromDateTime and / or EventNumber than CLSD row. There is cases that has now reach CLSD status yet and those I want all the rows from.
ToDateTimeWithNull column with NULL values represent the current status of the CaseId.
harvis is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2