Thank you for your solution.

status = 1 means approved.

I have a new requirement that should show all the approved and unapproved (status1,2,3). In John's case since he has the status...

• This reply was modified 2 years, 10 months ago by  edsmith.