Oops.. I deleted documents from ProLaw
We've all done it at some point. Accidently deleted documents from ProLaw, only to discover there is no undo button! Not fun. Luckily...
Matters Waiting Closeout - No Attorney Time
I love helping accounting folks and billing reviewers too. This was a recent request from one of my favorite firms. Can we flag all the...
Adding "code" to SSRS Reports, I finally get it....
I finally figured out how and when to use the code portion of SSRS reports. Basically, we need to write code when there is not a default...
Year End Vendor Contact Cleanup
One of my favorite firm leaders recently asked me for a ProLaw report she could run to identify which vendors have become inactive in the...
Toggling Date Field Format in Events Reports (Auto Show Time of Day)
The default field for event date for dockets is SQL datetime which appends midnight onto the day for any docket that is set as an all day...
XML Path Function Delimiters for ProLaw Data in Cascades
One of my favorite methods of extracting cascade information from ProLaw is using the XML PATH() function in SQL. The XML Path function...
Who is marking dockets complete?
If you have events audit trail turned on you can use the SQL code below to create reporting metrics (last 30 days) on who, and how many,...
Future Westlaw Dockets Missing Assigned Professional from Matters
Had an interesting problem recently, that I think is probably fairly common, especially if you do a lot of case reassignments in ProLaw...
