Skip to main content

Hi, We are using V14.5 and are trying to get a report from Astea to show “on time” reporting, so we want to compare the work date/time that they report that they did the work, to the actual date/time they wrote the report.  The problem were are having is to find the date that they first wrote their report.  All the dates we have found available get updated if anyone else makes a change to the status at a later date/time.

Does anyone have any suggestions of how/where we can capture the date that an SA first creates their Activity start and end dates/times?  We are trying to encourage on-time, on-site reporting so need a reliable way to know which SA’s are achieving that and of course, which are not.

Hi Chris,

Not sure if this will give you what you want but can’t you compare the transaction log entries for the order?  For example order changes, activity updates, etc. result in a transaction log entry for each event and the entry has a CREATION datetime that is independent of the data they are inserting into the application.  The next event results in a new transaction log row. Of course you would have to look for the first instance, I suppose…

You are on v14 so transaction log entries are in the demand table.

Just thinking what could be reviewed.

Hi Phil,

Thanks for your answer.  We can find the details in the transaction log, as you stated but finally decided that was going to be too complicated a report for our needs, so instead have opted for a simpler approach, comparing the worktime of just the last activity, to the recorded resolve date.  We can use that to find any that are very late reporters to begin with (the low hanging fruit), which will help achieve what we need.

Thanks for your support.

Reply


Terms & ConditionsCookie settings