SQL DB Query

[jameshollis]

Hi all,

We have direct access to the Proclaim SQL database through SSMS.

Our question is how can we tell if there has been a change committed against a case (aka has a field been updated, a file dropped on, correspondent updated)

We currently are looking at the case_record table and using the locked_last_date to see if this has been amended today.

Added some extra gubbins to the stored procedure for UNIX time so we can check whether someone has entered (or ideally someone has updated a case) after the last time it was checked.

Cant see anything other than the case_record table so sending feelers out if anyone can think of another method