- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi @twilliams629 ,
Analyse your usecase based on table structure.
1) Let's suppose your data structure is based on 'Store Order' and based on email address you want to know the status of order purchased. Then, put an additional condition in where clause and it can be based on latest purchase or Order with status not equal to 'Cancelled' or 'Completed'.
2) Also, if your table structure is simple i.e just recipients details, then you should find status based on most recent date.
You have define more precisely which type of data your table stores and what output you desire to get.
Thanks,
Jyoti