M
maggiethomas
Helpdesk calls are logged in 2 tables, 'Calls' with 1 row per call, and
'CallActions' with a variable number of entries per call log. The schema for
CallActions is:
CallID, ActionID, datestamp, narrative
The Narrative can be made up of free-form text or just contain specific text
to show something has happened to the call, e.g. '**new', '**open',
'**investigating' etc. The CallID is unique in the 'Calls' table, the
ActionID is unique in the 'CallActions' table.
I need to pick out both '**New' and the first '**Open' actions for all
calls, and for each call calculate the time difference between them. There
could be multiple '**Open' actions for a single call which is why I need to
measure to the first one only. I'm not sure even where to start!
Maggie
'CallActions' with a variable number of entries per call log. The schema for
CallActions is:
CallID, ActionID, datestamp, narrative
The Narrative can be made up of free-form text or just contain specific text
to show something has happened to the call, e.g. '**new', '**open',
'**investigating' etc. The CallID is unique in the 'Calls' table, the
ActionID is unique in the 'CallActions' table.
I need to pick out both '**New' and the first '**Open' actions for all
calls, and for each call calculate the time difference between them. There
could be multiple '**Open' actions for a single call which is why I need to
measure to the first one only. I'm not sure even where to start!
Maggie