Can anybody provide me with details of how I can either display in the case
form or the SQL equivalent so I can produce a report of the date, time and
title of the latest activity that was created on a Case.

We have a business requirement to supply clients not only with details of
outstanding cases, but when the last activity took place and the details of
that activity

There are probably several approachs you could take to accomplish your
objective, write some custom code based on the sdk that updates fields on the
case form when activities are created, etc. One of the easiest methods is to
create a SQL report to display the information you want. You can fairly
easily create a query that pulls the lastest activity information from the
filtered views and display whatever you would like to the end user.

Best Regards,
Donna

"AneelK" wrote:

Donna
can you let me know which table holds the details of the activity
information so that I can see if I can get an Excel report completed over the
next couple of days showing this information

thanks
Aneel


"Donna" wrote:

Hi Aneel,

Pull from the Views rather than incident base. You should be able to find
the information you need in the FilteredIncidentResolution table.

Best Regards,
Donna

"AneelK" wrote:

You will need FilteredActivity rather than FilteredIncidentResolution since
FilteredIncidentResolution is for closed cases. You may need to do a join on
FilteredIncident to obtain all the information you need.

Best Regards,
Donna

"Donna" wrote: