Tricky way to get index of row in query rule

Dear all,

I am trying to get data from the DB to show milestone and trying to figure out how to build a query rule to return the index of the last non-null value a list of rows .  See the attached picture.  How can I code this query rule to return the last non-null index of the approverDecision column?  In this case, the index is 2 (the last non null approverDecision row).

Thanks

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data