This content has been marked as final. Show 2 replies
ID Statut operator begin.Day End. Day
245 Open idle Smith 01/01/2012 13/01/2012
245 Open linked Jones 13/01/2012 23/01/2012
245 Resolved Jones 23/01/2012 25/01/2012
245 Closed Jones 25/01/2012
298 Open idle Smith 17/02/2012 29/02/2012
298 Open linked Jones 29/02/2012 10/03/2012
298 Resolved Jones 10/03/2012 12/03/2012
298 Closed Jones 12/03/2012
765 Open idle Smith 15/03/2012 27/03/2012
765 Open linked Jones 27/03/2012
For the interaction ID from the table Interaction (where I want to fille the fields) i need to look for in the Table Statut, the statut which have the latest date for degin day, in order to find the current statut (or last statut if the interaction is old, so closed).
This value fill the "last statut" field of the Table interaction and i need also to fill the "begin & end date".
how i can do that in the script page ?
Thank you for your help