Hello all !
I face some issue, this is about filtering and sorting. Maybe I’ll find someone to help.
I’ve a table “Users” and a table “calls”. Users are unique. There’re 1 or more calls for 1 user.
Each call have a “max date”, and a field for the user. Each user has a field for all his calls.
I need to display a list of calls, sorted by max date, but only the first one for each user (the next one, in term of dates), means if USER A have 2 calls, one on next monday and one in one month, I need to diplay only the call for monday.
I spent hours and hours without success.
If someone has an idea, it will be very nice to me !!! thanks